Accessing out-of-the-box views


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.

You can access and edit the out-of-the-box views in TrueSight Network Automation - Data Warehouse if you are one of the following users:

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

This topic provides the list of out-of-the-box views, and the instructions on accessing out-of-the-box views.

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

Do the following:

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

    To log in as the DWNetworkAdmin user
    1. Click Start > Programs > TrueSight Network Automation - Data Warehouse > Login to open the TrueSight Network Automation - Data Warehouse console.
      Alternatively, you can enter the following address into a web browser: 
      https://<appServer>:<portNumber>/network-warehouse-ui
      • appServer is the application server that hosts TrueSight Network 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 TrueSight Network Automation - Data Warehouse administrator (DWNetworkAdmin) credentials.
    3. Click LOG IN.
    4. Click Reports.
    To log in as a reporting user:
    1. Do one of the following:
      • Click Start > Programs > TrueSight Network Automation - Data Warehouse > Login.
      • Enter the following address into a web browser:
        https://<appServer>:<portNumber>
        where:
        • appServer is the application server that hosts TrueSight Network Automation - Data Warehouse. 
        • portNumber is the web server secure port that you specified during installation. Default is 9443.
    2. Enter the user name and password for the reporting user.

      Important

      If a user with the name admin exists in TrueSight Network Automation, do not use this user to cross-launch to TrueSight Smart Reporting - Platform from the Network Automation - Data Warehouse console.

      If you cross-launch with the admin user, permissions of the TrueSight Smart Reporting - Platform administrator are replaced by the permissions of the Network Automation - Data Warehouse admin user. As a result, the TrueSight Smart Reporting – Platform administrator cannot perform the tasks associated with the role because the permissions are changed.

    3. Click LOG IN.
  2. In the left navigation bar, expand Browse > Views.
  3. Under By Folder, click All.
    All the available views are displayed in the main pane in Thumbnails view.
  4. (optional) To see the views in a list, click Layout in the toolbar, and select List. The main pane displays a list of all the views.
    OOTB_Views.png

  5. Double-click the view that you want to check.
    ViewSummary.png
    The View Summary window appears, which contains the following tabs:

    Tab

    Description

    General

    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

    Contains the list of columns in the view.

    SQL

    Contains the SQL query that is used to create the view

    Reports

    Contains the list of the reports in which the view is used

 

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