Working With Pivot Tables in IT Analytics Solution 7.1
This article provides a hands-on overview of IT Analytics Solution 7.1. You will learn how to browse cubes and configure Pivot Tables using a number of common usage scenarios. Using the ad-hoc data mining capabilities of IT Analytics we will perform some forensic analysis of vulnerable computers in an environment managed by Altiris Client Management 7.1.
- Launch the Symantec Management Console.
- Click the Reports menu item and select All Reports.
- Expand the Reports folder.
- Expand the IT Analytics folder.
- Expand the Cubes folder.
- Select the Patch Management Cube.
- Click anywhere in the PivotTable window to display the Field List. Clicking on this icon in the toolbar will also cause the field list to be displayed.
- Drag and drop the Vulnerable Computer Count measure into the Totals pane:
- Drag and drop the Software Update - Provider attribute into the Rows pane:
- Drag and drop the Software Update - Reference attribute after the Software Update - Provider attribute and expand one of the Software Update Providers to show the Updates available:
Now that we have built our initial patch management view which showcases the number of vulnerable computers per software update, we will expand upon this view by bringing in more information and adding filtering capabilities.
- Drag and drop the Software Update - Severity attribute into the Columns pane:
Resize\Move the Pivot Table Field List box to optimize your view of the Patch Cube data.
- Right Click on the Critical column and select Filter by Selection.
- Drag Software Update - Severity from the Columns pane into the filter pane.
- Drag the Computer – OS Name attribute from the field list directly into the Filter pane.
- Click on the dropdown arrow for the Computer – OS Name attribute in the Filter page and select only Microsoft Windows XP, Windows 7 Professional and Windows 7 Ultimate and click OK.
- Drag in the Computer - Name attribute into the Rows pane before the Software Update – Provider attribute to see the critical software updates that are missing per computer.
- Finally you can save this report by clicking this icon in the toolbar.
- Select the “Save as new view” radio button and name it appropriately.
- You may also check the “Available to all users” checkbox in the event that you would like this report to be available to all users. Leaving this unchecked will make this a private view only available to you.
- Refresh the SMP Console and navigate back to the Patch Management Cube (Reports > IT Analytics > Cubes). This will bring you back to the initial Patch Management screen.
- To open the view you just saved click this icon in the toolbar and select the report you just created in the dropdown list. Note that the report is loaded exactly as you left it.