Importing scripts for running ETL and archiving data by using TrueSight Server Automation jobs

TrueSight Server Automation provides scripts for agent log data collection and running the ETL and archival processes by using TrueSight Server Automation jobs . This topic describes how to download and import the scripts.

Do the following:

1. Log in to the system where TrueSight Server Automation - Data Warehouse is installed.

2. Navigate to the following path:
   <TSSA-DWInstallationDirectory>/bsa/content_installer

3. Copy the content_installer.zip file to your TrueSight Server Automation Application Server.

4. Extract the zip file to a temporary location on the TrueSight Server Automation Application Server:

   • (Windows) %temp%

   • (Linux) /tmp

5. Open the command prompt and navigate to the directory where you have extracted the files.

6. Start the Network Shell (NSH) and run the following command:
nsh

7. Run the blcred utility to acquire credentials. Run the command with these parameters:

   • Profile Name: Name of the profile created on TrueSight Server Automation. For example, defaultProfile.
   • User Name: TrueSight Server Automation user. For example, BLAdmin.
   • Password: Password for the TrueSight Server Automation user

   blcred cred -acquire

8. Run the following script:
   nsh load-bsara-nsh-script.nsh -v <authenticationProfileName>

   where <authenticationProfileName> is the authentication profile name for the local or remote Application Server.  
   Use this parameter if you do not want to use the default profile or when the default profile is not available.

9. Select one of the following options:
   • Load TSSA-DW Collect Agent Logs Scripts: Select to create agent log collection jobs. With this option selected, the collect_agent_logs.nsh script is imported.
   • Load TSSA-DW ETL and Archival Scripts: Select to create TrueSight Server Automation - Data Warehouse server NSH script jobs to run the ETL and archival processes. With this option selected, the run_etl_from_tssa.nsh and run_archival_from_tssa scripts are imported.
   • Load All: Select to import all the scripts.
   • Exit: Select to stop the execution of the load-bsara-nsh-script.nsh script.

10. Verify that the script was executed successfully. See the content-install.log file in the contents_installer directory.

11. Verify that the scripts are imported. Do the following:

    1. Log in to the TrueSight Server Automation console.

    2. Navigate to the following path and verify that the Collect Agent Logs Script file is present.
       BladeLogic\Depot\TSSA Reports Scripts\Collect Agent Logs
    3. Navigate to the following path and verify that the Run ETL From TSSA Script file is present.
       BladeLogic\Depot\TSSA Reports Scripts\Run ETL from TSSA

    4. Navigate to the following path and verify that the Run TSSA-DW Archival Script file is present.
       BladeLogic\Depot\TSSA Reports Scripts\Run TSSA-DW Archival

Where to go from here

Running ETL using TrueSight Server Automation jobs