Setting up TrueSight Server Automation jobs for data collection in reports

TrueSight Smart Reporting for Server Automation reports are generated from data that is derived from the TrueSight Server Automation database.

Perform the following steps:

1. Collect data from TrueSight Server Automation by using TrueSight Server Automation jobs. 
2. Run ETL.
   TrueSight Server Automation - Data Warehouse uses extract, transform, and load (ETL) to transfer data from the TrueSight Server Automation database to the reports data warehouse. You can run ETL from the command line or as a TrueSight Server Automation Network Shell Script Job. 

3. Refresh the cached filter list in TrueSight Smart Reporting - Platform.

   Click here to see the steps to refresh the filters in TrueSight Smart Reporting.

   
   

   The access filter list is refreshed every time when new users are added to TrueSight Server Automation - Data Warehouse through ETL. This ensures that the latest values are reflected in the reports.

   Ensure that you have added the TrueSight Server Automation - Data Warehouse Administrator user in your client organization.

   As a TrueSight Smart Reporting - Platform Administrator, perform the following steps to refresh the access filter:

   1. Use the following URL to open the TrueSight Smart Reporting - Platform login page:
      https://<hostname>:port/tsr 
   2. In the Log in as list, select TrueSight Smart Reporting - Admin.
   3. In the User Name and Password fields, enter the TrueSight Smart Reporting - Platform administrator credentials.
   4. Click LOG IN.
   5. In the right navigation pane, click admin >Admin Console.
   6. Select the TrueSight Server Automation - Data Warehouse Administrator in the Multi-tenant Login list and click Login.
   7. In the left navigation pane, go to Administration > Admin console > Data Sources.
   8. In the Data Sources panel, click the TrueSight Server Automation - Data Warehouse datasource.
   9. Click Access Filters.
   10. Perform the following steps for all the access filters.
       1. Click an access filter from the list of available access filters.
       2. In the Settings panel, toggle New User Auto Refresh. The access filters are updated when new users are added to TrueSight Server Automation - Data Warehouse through ETL. 
       3. Click Submit. 
       4. Go to Records tab to view the list of users for the specified access filter.