Accessing out-of-the-box views

You can access the out-of-the-box views in TrueSight Smart Reporting - Platform, if you are one of the following users:

  • DWAdmin
  • Reporting user with the TrueSight Component Administrator role in TrueSight Smart Reporting - Platform

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.

Recommends

We recommend that you do not edit the out-of-the-box views.

The following table provides the list of out-of-the-box views:

FolderView nameDetails
AuditAudit DomainThis view is used by all the Audit reports.
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 Summary by Server
  • Patch Analysis Trend by Policy
  • Patch Summary
  • Patch Trend by Server 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.
ComplianceCompliance
SCAP

Compliance view is used by all the Compliance reports.

SCAP view is used by all the SCAP reports.

Job ActivityJob ActivityThis view is used by all the Job Activity reports.
Change TrackingChange Tracking ModelThis view is used by all the Change Tracking reports.
RBACRBACThis view is used by all the RBAC reports.
ProvisioningProvisioningThis 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

  1. Log in to the TrueSight Server Automation - Data Warehouse console.

     To log in as the DWAdmin user, do the following:

    1. Use the following URL to open the TrueSight Server Automation - Data Warehouse login page:
      https://<TrueSight Server Automation - Data Warehouse hostname>:<portNumber>/tssa-dw
    2. In the User Name and Password fields, enter the TrueSight Server Automation - Data Warehouse administrator credentials.
      Default user name: DWAdmin
      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. Click Reports to launch the TrueSight Smart Reporting - Platform Home page.

     To log in as a reporting user, do the following:

    1. Use the following URL to open the TrueSight Server Automation - Data Warehouse login page:
      https://<TrueSight Server Automation - Data Warehouse hostname>:<portNumber>/tssa-dw

    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. In the left navigation bar, expand Browse > Views > TrueSight Server Automation - Data Warehouse.

  3. 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. 



  4. Double-click the view that you want to check. The View Summary window appears. It contains the following tabs.

    TabDescription
    GeneralThis 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.
    FieldsThis tab contains the list of columns in the view.
    SQLThis tab contains the SQL query that is used to create the view.
    ReportsThis tab contains the list the reports in which the view is used. 





Was this page helpful? Yes No Submitting... Thank you

Comments