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 by using jobs.
   Data is collected, in part, using several TrueSight Server Automation jobs. To ensure that the data is available for transfer from the TrueSight Server Automation database to the reports data warehouse, you must import any job-related templates and scripts and then set up the TrueSight Server Automation jobs that gather data for the reports you want to use.

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. TrueSight Server Automation - Data Warehouse provides several scripts to execute the ETL process. You can view the ETL status by using the TrueSight Server Automation - Data Warehouse console.

   Some reports are based on jobs that run in TrueSight Server Automation, while some reports use data collected in other ways. 

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

   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 Administrator, perform the following steps to refresh the access filter:

   1. Use the following URL to open the TrueSight Smart Reporting 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 administrator credentials.
   4. Click LOG IN.
   5. In the left navigation pane, click Administration >Admin Console.
   6. Select the TrueSight Server Automation - Data Warehouse Administrator in the Multi-tenant Login list and click Login.
   7. In the right 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.