Video Screencast Help

Publishing IT Analytics Symantec Endpoint Protection Dashboards in Microsoft SharePoint

Created: 02 Jan 2013 • Updated: 22 Nov 2013
Language Translations
dprager's picture
+14 14 Votes
Login to vote

IT Analytics offers users several ways in which they can consume their systems management data. One of the more popular ways to expose IT Analytics data to business users, without granting them access to the Symantec Management Console, is through utilizing some of the rich reporting capabilities within Microsoft SharePoint. This article will provide step by step guidance on creating dashboards using the IT Analytics Symantec Endpoint Protection Content Pack while leveraging Microsoft SharePoint’s PerformancePoint solution. There is also an optional process for including a link to the out-of-the-box IT Analytics reports hosted by SQL Reporting Serivces.

NOTE: This example uses Microsoft PerformancePoint, which is only available in the Enterprise version of SharePoint. If you are running SharePoint Standard you can still add links to IT Analytics default reports and dashboards by simply using the URL exposed by SQL Reporting Services. However, without PerformancePoint you will not be able to create and publish the dashboards outlined below. 

 

Creating a Dashboard in PerformancePoint

  1. Within SharePoint, navigate to the Business Intelligence Center and select the "Create Dashboards"

  1. Click "Start using PerformancePoint Services”

  1. Click "Run Dashboard Designer"

  1. Wait a few moments for the application to launch

  1. Select the "Workspace" tab, click "Create" in the ribbon bar and select "Data Source"

  1. Select "Analysis Services" and click "OK"

  1. Select the "Properties" tab and enter a meaningful Name, Description, and Display Folder, then click on the "Editor" tab

  1. Enter the analysis server “Name”, choose the “IT Analytics” database, select the cube “SEP Alerts”, then click “Test Data Source” and ensure the connection succeeds, click “Close”

  1. Repeat steps 5 and 6 to add another Data Source
  2. Select the "Properties" tab and enter a meaningful Name, Description, and Display Folder, then click on the "Editor" tab

  1. Enter the analysis server “Name”, choose the “IT Analytics” database, select the cube “SEP Server System Events”, then click “Test Data Source” and ensure the connection succeeds, click “Close”

  1. Click the “Save All” icon, specify a location and file name for the project, then press “Save”

  1. Click “PerformancePoint Content” in the workspace browser and select the “Workplace” tab and chose “Analytic Chart” from the Create ribbon bar

  1. Select the “SEP Alerts” data source created in step 8, then click “Finish”

  1. Select the "Properties" tab and enter a meaningful Name, Description, and Display Folder, then click on the "Design" tab

  1. From the details pane on the right, expand “Measures” and “Dimensions”

  1. Drag “Virus – Threat Type” and “Alerts” to the “Series” section and the “Alert – Actual Action” to the “Bottom Axis” section. The chart will now display data

  1. Right click on the white space in the report, expand “Report Type” and select “100% Stacked Bar Chart”

  1. The chart will be refreshed. Right click on a column, expand “Sort” and select “Smallest to Largest”

  1. The chart will be refreshed. Click on the downward facing triangle next to “Alert – Actual Action” and select everything except “None”, Press “OK”

  1. The chart will be refreshed. Right click on the white space in the report, expand “Format Report” and select “Show Legend at Top” 

  1. The chart will be refreshed. Click on the “Save All” icon to save your changes

  1. Click “PerformancePoint Content” in the workspace browser and select the “_SEP” folder and chose “Analytic Chart” from the Create ribbon bar

  1. Select the “SEP Server System Events” data source created in step 11, then click “Finish”

  1. Select the "Properties" tab and enter a meaningful Name, Description, and Display Folder, then click on the "Design" tab

  1. From the details pane on the right, expand “Measures” and “Dimensions”

  1. Drag “Server System Event Type – Type” to the “Series” section, and the “Event Count” to the “Bottom Axis” section. The chart will now display data

  1. Right click on the white space, expand “Report Type” and select “Pie Chart”

  1. The chart will be refreshed. Right click on the chart, expand “Filter” and select “Top 10…” from the “Series” section

  1. Change the number in the screen to “5” and click “OK”

  1. The chart will be refreshed. Click on the “Save All” icon to save your changes

  1. Click “PerformancePoint Content” in the workspace browser and select the “_SEP” folder and chose “Reporting Services” from the Create ribbon bar

  1. Select the "Properties" tab and enter a meaningful Name, Description, and Display Folder, then click on the "Editor" tab

  1. Enter your “Server Name” and click “Browse”

  1. Select “Scan Trend” from the list and click “OK” NOTE: If the report you are selecting contains parameters, you can select from the predefined parameter set in the report itself, the <Default> value is automatically selected

  1. Click on the “Save All” icon to save your changes
  2. Click “PerformancePoint Content” in the workspace browser and select the “_SEP” folder and chose “Dashboard” from the Create ribbon bar

  1. Select “2 Rows” and press “OK”

  1. Select the "Properties" tab and enter a meaningful Name, Description, and Display Folder, then click on the "Editor" tab

  1. From the "Details" pane on the right hand side of the screen, expand "Reports" and browse to the PerformancePoint Content previously created

  1. Drag the report “SEP Alerts by Event Type and Severity” from the Details pane to the "Top Row" pane of the dashboard, then drag the report “Top 5 SEP Server System Events by Type” from the Details pane to the "Bottom Row" pane of the dashboard

  1. Right click on Top Row and select “Add Right”

  1. Drag the report “Scan Trend” from the Details pane to the "Zone 1" pane of the dashboard

  1. Right click “Top Row” and select “Zone Settings”

  1. Select the “Size” tab and enter “30” in the “Width” box, then select “OK”

  1. Your dashboard should look like this now. Click on the “Save All” icon to save your changes

  1. Click on the Home button and select "Deploy"

  1. In the "Deploy To" dialog box, select "Include page list for navigation" and select "OK"

  1. Once the Dashboard is deployed, it will automatically be opened in Internet Explorer to view

  1. To access the dashboard from the Business Intelligence Center, click on the "Dashboards" link and then click on your dashboard

  1. Click on the "Name" hyperlink to display the dashboard