Connect with TrueSight - TSSA:Creating Reports using Smart Reporting Webinar Q&A

Version 1
    Share This:

    Subscribe to the BMC TrueSight Server Automation YouTube Channel

    https://www.youtube.com/c/BMCTrueSightAutomation

    Presentation References

     

    TrueSight Server Automation YouTube Channel Video Patching Playlist

    https://www.youtube.com/watch?v=qnDn_CFLoyo&list=PLf5s5_weC7C-H6B1rNgMARX-AAmZFqg5K

    TSSR - How to Create Reports Documentation

    https://docs.bmc.com/docs/display/tssrsa192/Creating+reports

     

    TSSR BLOG

    https://communities.bmc.com/community/bmcdn/truesight-server-automation/blog/2020/03/05/helix-support-truesight-smart-reporting-for-server-automation-tssr-sa-19202

     

    Executing Initial ETL - KA#000218203

    https://communities.bmc.com/docs/DOC-123870

     

    Best Practices while creating reports in TSSR – KA#000186741

    https://communities.bmc.com/docs/DOC-126518

     

     

    Q&A

     

    Q: With cumulative patches, the number of missing patches isn't really something that would tell what the actual patching status of the server is. Would it be possible to create a report with installed patches with the install date for each patch with description of what each patch is?

     

    A: Summary reports show data for installed and missing patches, such as the number of patches installed, the number of missing patches, and the number of servers audited. Details reports show data for missing patches.  See https://docs.bmc.com/docs/tssrsa200201/patching-reports-945193609.html

     

    For installed patches, currently you can list the “Patch Status” (Installed) however, you cannot list the Patch Description or Install Date on a Server.  The Patch Description is present in TSSA so that is an Enhancement Request we can submit for TSSR-SA.  It does not seem that the Patch Installed Date is listed in TSSA so that would need to be first added to TSSA before it could be displayed in TSSR-SA

     

    This may be possible via an Extended Object/Snapshot Job in TSSA which can capture the results for reporting. Something like the following may work but has not been tested - For Windows

    1. Create an extended object, use: wmic qfe get HotFixID,InstalledOn /format:csv in Command/Script
      See the video https://www.youtube.com/watch?v=r9hCQDpn5Kw for more information
    2. Create a snapshot job of extended object created in step 1
    3. Run ETL
    4. Create report of Patch installed date from snapshot

     

    or

     

    1. Login to console as BLAdmins
    2. Go to Configuration > Config Object Dictionary
    3. Then select "Extended Object" and OS as Windows in the drop down
    4. Add a new EO for Windows, using the green plus sign at the top
    5. Give any name to the EO and put "powershell.exe Get-Hotfix" or "wmic qfe list brief" as the command
    6. Select the grammar as whole line as record grammar or (generic.gm)
    7. Once the EO is saved me can  see that in the Extended Objects once you Live Browse the server

     

     

    Q: What is the difference between filters in green vs filters in blue?

     

    A: See the following page directly from the Yellowfin documentation for a description of the different Filter Types - https://wiki.yellowfinbi.com/display/USER74/Filters#Filters-FilterTypes

     

     

    Q: Can you explain Drill Through concept once again?

     

    A: Basically, it’s when you have two reports.  One is the higher level (Master) and one is more detailed (Child).  You can add hyperlinks on the Master report to link into the Detailed report (drill through into the child report) to get more detailed information on an item.

     

     

    Q: The presenter logged in with GlobalReportAdmin Role which was meant for BDSSA. Is this role still functional for TSSA SR ?

     

    A: This topic is best answered on this page. The GlobalReportAdmin is typically only used in TSSR-SA when there are multiple TSSA sites (as there was in the demo). See https://docs.bmc.com/docs/display/tssrsa192/RBAC+access+to+report+data

     

     

    Q: So, for every latest inventory report a new snapshot will be needed?  if yes, then what about the space issue on DB server which will be there due to snapshot(s)?  Is there any cleanup for those snapshots as well ?

     

    A: The data will be updated in TSSA via the latest Snapshot Job run. So, if the last Snapshot Job Run for an asset/server is from Sept 10th, that will be the latest date in the TSSA DB.  Then ETL will transfer that data to the Data Warehouse for reporting.  So, the data in Reports will be as up to date as your last Snapshot Run followed by ETL.  TSSA has a cleanup command specifically for cleaning up old Snapshot Job results - cleanupHistoricalData SnapshotResult see - https://docs.bmc.com/docs/tssa2002/types-of-data-commonly-included-in-cleanups-911442475.html

     

     

    Q: Is it a live demo or pre-recorded version as reports are coming very fast , generally they take good amount of time?

     

    A: The demos are pre-recorded.  Executing reports can take time depending on data volume.

    There can be other factors which can affect performance e.g. network, DB performance, filters, DB size, state of cleanup and archiving. Please do continue to work with BMC Support to assist with performance analysis and troubleshooting.

     

     

    Q: Does patch remediation also part of patch report?

     

    A: Patch Reports are based on Patch Analysis results. So, they will show Missing and Installed patches.

     

    Summary reports show data for installed and missing patches, such as the number of patches installed, the number of missing patches, and the number of servers audited. Details reports show data for missing patches.  See https://docs.bmc.com/docs/tssrsa200201/patching-reports-945193609.html

     

     

    Q: Is this the live report?

     

    A: No,  the webinar is for True Sight Smart Reporting (TSSR-SA). TSSR-SA relies on the ETL job to transfer the data from the TSSA DB to the Data Warehouse. So, it is only as live as the last time you ran ETL.  TSSA Live Reporting is different. It is live, but it does not allow for custom report creation and provides a small set of out of box reports. Both solutions do use Yellowfin so it can be a common point of confusion.  Here are the docs on both:

     

     

    Q: Can we do specific Inventory model and special filters for our own needs that can be Distributed to all users?

     

    A: From the inventory model, you must use the default filters to show accurate data. See step 8 here https://docs.bmc.com/docs/tssrsa192/creating-reports-868136094.html  If you want to create reports for the Inventory Domain for any asset using the Server and Job attributes, use the filters that are available under the individual Asset folders.  You can also add your own custom filters based on properties.  See https://docs.bmc.com/docs/display/tssrsa192/Use+cases+for+filtering+reports+by+using+property+values

     

     

    Q: Can we export co-display report in excel?

     

    A: Yes, we can export the co-display reports to Excel format

     

     

    Q: Will Co-display report exported in one excel in same sheet or two sheets in the same excel?

     

    A: It will display in 2 tabs in single excel

     

     

    Q: Can we take out report only based on remediation jobs run within specified period?

     

    A: Patch reports are based on Patch Analysis job results not on remediation results.  You could look at Job Activity reports for this: https://docs.bmc.com/docs/display/tssrsa192/Job+Activity+reports

     

     

    Q: Can we get the "installed patch date details" for the already installed patches on the servers?

     

    A: Summary reports show data for installed and missing patches, such as the number of patches installed, the number of missing patches, and the number of servers audited. Details reports show data for missing patches.  See https://docs.bmc.com/docs/tssrsa200201/patching-reports-945193609.html

     

    For installed patches, currently you can list the “Patch Status” (Installed) however, you cannot list the Patch Description or Install Date on a Server.  The Patch Description is present in TSSA so that is an Enhancement Request we can submit for TSSR-SA.  It does not seem that the Patch Installed Date is listed in TSSA so that would need to be first added to TSSA before it could be displayed in TSSR-SA

     

    This may be possible via an Extended Object/Snapshot Job in TSSA which can capture the results for reporting. Something like the following may work but has not been tested - For Windows

    1. Create an extended object, use: wmic qfe get HotFixID,InstalledOn /format:csv in Command/Script
      See the video https://www.youtube.com/watch?v=r9hCQDpn5Kw for more information
    2. Create a snapshot job of extended object created in step 1
    3. Run ETL
    4. Create report of Patch installed date from snapshot

     

    or

     

    1. Login to console as BLAdmins
    2. Go to Configuration > Config Object Dictionary
    3. Then select "Extended Object" and OS as Windows in the drop down
    4. Add a new EO for Windows, using the green plus sign at the top
    5. Give any name to the EO and put "powershell.exe Get-Hotfix" or "wmic qfe list brief" as the command
    6. Select the grammar as whole line as record grammar or (generic.gm)
    7. Once the EO is saved me can  see that in the Extended Objects once you Live Browse the server