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:

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 ViewPassword.png.
    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 ViewPassword.png.
    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. 

    InventoryViews.png

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


    GeneralTabViews.png


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*