In order to install the report pack you need to meet the following pre-requisites (NOTE refer to the IT Analytics System Requirements and also the SMP Planning and Implementation Guide):
- Symantec Management Platform (SMP)
- SQL Reporting Services
- SQL Analysis Services
Configuring the IT Analytics Pack for SEP
There are also several fields we need to fill out in order for the connection to be complete once the installation is done. In the SMP navigate to Settings -> Notification Server -> IT Analytics Settings. There is a folder labeled "Connections" and in my case I have connections for all the products in my demo:
Select the Symantec Endpoint Protection connection and fill out the correct information needed to connect to the database. NOTE: This requires using SQL Authentication instead of Windows Authentication to the SEM5 (default name of the SEP database) database. Information should look like the following:
Apply the changes and the connection should be created successfully.
Once the connection has been created the cubes need to be installed, click on the folder labeled "Cubes" and then navigate to the tab labeled "Available" and select the SEP Cubes and install them:
Once the cubes are selected, towards the bottom of the page there is a butto labeled "Install" click on that and wait for the cubes to be installed.
Configuring the SEP Cubes for Processing
One of the strengths of IT Analytics is the cubes are processed off hours from the normal reporting within the Symantec Management Platform and the reporting is then run off of SQL Analysis and Reporting Services instead of the SEP Database. In order to process these cubes navigate in the IT Analytics section to the folder labeled "Processing"
As mentioned, these cubes process on a schedule, but by clicking on the "Run Now" button the cubes will be process immediately:
The following image is an example of an IT Analytics report written against my SEPM: