As a TrueSight Server Automation - Data Warehouse Administrator, you can access and edit the out-of-the-box views in TrueSight Smart Reporting for Server Automation.
A view is a metadata layer that defines relationships between tables and to identify fields to be accessed by the reports. Each view contains multiple folders, which contain fields that you can use to create reports.
The following table provides the list of out-of-the-box views:
Folder | View name | Details |
---|---|---|
Command Usage | Command Usage Summary Command Log Detail | Command Usage Summary is used for the out-of-the-box Command Usage Summary report. Command Log Detail is used for the out-of-the-box Command Log Detail report. |
Patching | Patch Model - Summarized Information Patch Model - Detail information | Patch Model - Summarized Information is used by the following out-of-the-box reports:
Patch Model - detail information is used by the other out-of-the-box patch reports. |
Inventory | Inventory Model | This view is used by all the Inventory reports. |
Compliance | Compliance SCAP | Compliance view is used by all the Compliance reports. SCAP view is used by all the SCAP reports. |
Job Activity | Job Activity | This view is used by all the Job Activity reports. |
Change Tracking | Change Tracking Model | This view is used by all the Change Tracking reports. |
RBAC | RBAC | This view is used by all the RBAC reports. |
Provisioning | Provisioning | This view is used by all the Provisioning reports. |
Utilization Dashboard | Utilization Dashboard Job Utilization Dashboard Server Utilization Dashboard Server Activity Utilization Dashboard User/Policy | These views are used by the Utilization Dashboard. |
To access out-of-the-box views
Log in to TrueSight Server Automation - Data Warehouse console.
Click Reports to launch the TrueSight Smart Reporting Home page.
In the left navigation bar, expand Browse > Views > TrueSight Server Automation - Data Warehouse.
Select the folder for which you want to access the views. All the available views are displayed in the main pane. For example, to access the Inventory views, select the Inventory folder.
Double-click the view that you want to check. The View Summary window appears. It contains the following tabs.
Tab Description General This tab contains the details of the view, for example, the source name, the current status, and so on. You can also download the view documentation including the data dictionary in PDF or word format by using the Download PDF documentation or Download DOC documentation link. Fields This tab contains the list of columns in the view. SQL This tab contains the SQL query that is used to create the view. Reports This tab contains the list the reports in which the view is used.