This topic provides an example for creating a custom report that contains a chart and a table.

Create a report with the following information:

  • Patching trend of the server 
  • Server Name
  • Job Run Date
  • Missing Patch Count
  • Total Patch Count
  • Compliance %

The report should be filtered by Server Name and Operating System. 

Perform the following steps:

  1. Log in to TrueSight Server Automation - Data Warehouse. The TrueSight Smart Reporting Home page appears.

    1. To view the home page for the console on Microsoft Windows or UNIX systems, click Start > Programs > TrueSight Server Automation - Data Warehouse > Console.
      Alternatively, you can enter the following address into a web browser: 
      https://reportsServer:portNumber/tssa-dw

      • reportsServer is the server that hosts TrueSight Server Automation - Data Warehouse
      • portNumber is the web server secure port that you specified during installation. 
    2. In the User Name and Password fields, enter the user credentials. By default, the password is hidden. To view the password, click .

    3. In Site, select a site. The Primary Site is the default site.
    4. In Authentication Method, select a authentication method. SRP is the default authentication method.
    5. Click LOG IN.
    6. In the Roles window, select the role you want to use and click OK. Through role-based access control (RBAC), you can be granted multiple roles, but you can use only one role at a time.

  2. Click  and click Report.
  3. From the Select a View list, select Patch Model - Summarized Information.

  4. In the View pane, expand the folders to view the fields for the report. Drag and drop the following fields in to the Columns field. 

  5. Server Name, Year, Quarter, Month, Week of Year, Job Run Start Time, Installed Patch Count, Missing Patch Count, Total Patch Count, Graph Dimension
    You can also search for the fields in the View pane. 

  6. By default, the value of a numeric field is displayed as aggregated value. Click on the drop-down menu on the Installed Patch Count field and set the Aggregation to None. Perform this step for Missing Patch Count and Total Patch Count.

  7. Click Column Formatting in the main Formatting bar in order to open the formatting menu for the columns. 

  8. Select the Server Name field and toggle the Suppress Duplicates field to remove the duplicate entries from the report. Perform this step for Year, Quarter, Month, Week of Year fields.

  9. Select the Job Run Start Time field and select the Date Format as dd/MMM/YYYY.

  10. To filter the report by Operating System and Server Name, drag and drop the following fields in to the Filters section.
    Server Name , OS Name

  11. To find the percentage of installed patch count, click on the drop-down menu on the Installed Patch Count field and select Advanced Function.

  12. In the Select Function list, select Analysis and Percentage Against Column. In the Column list, select Total Patch Count.

  13. Click Save.

  14. Click Column Formatting in the main Formatting bar. Select % of Installed Patch Count and in the Suffix field, add %.

  15. Click Design. 

  16. In the Filters list, click  next to the OS Name and select Change Operand > Equal To.


  17. In the Filters list, click  next to the Server Name and select Change Operand > Equal To and Entry StyleDrop Down.

  18. In the Filters list, click  and select Format. 

  19. Select Server Name filter and click Specify Parent Filter.

  20. In the Parent Filter list, select OS Name. Toggle the Dependent Values and Dependent Display fields.
  21. Click Submit.
  22. Click GO.

  23. Click Charts. This displays the dimensions (For example, Server Name, Year, Month) and the metrics (Missing Patch Count, Total Patch Count, % of Installed Patch Count) which you can use to create the chart.

  24. Click Auto Chart and then click Select Chart Type to open the Select Chart pane. Select Line to use as an output for your trend report. Alternatively, click  in the upper right corner.

  25. Drag and drop the Graph Dimension field to the Horizontal Axis. Drag and drop the Missing Patch Count and % of Installed Patch Count to the Vertical Axis.

  26. Click Series  in the main Formatting bar in order to open the formatting menu for the series. You can define the custom style for the series. You can also display a shape at each data point on the line.

  27. Click Axisin the main Formatting bar in order to open the formatting menu for the axis. You can define the custom style for the axis. You can also rotate the axis labels.

  28. Click Publish. In the Save Report window, enter a name and description for your report. In the Report Access area, select Public or Private.

  29. Click Save to generate and view the report.
  30. In the generated report, in the Filters box, you can see the filters from the filter group that you selected. Select a filter value and click GO. You can see the filtered data in the report.

Upgrade Assistance

The BMC Assisted Migration Offering (AMIGO) program is designed to assist customers with the planning of product upgrades to a newer version – “Success through proper planning”.
Explore AMIGO Program ›
Was this page helpful? Yes No Submitting... Thank you