Transcription

1 Creating a Patch Management Dashboard with IT Analytics Hands-On Lab Description This lab provides a hands-on overview of the IT Analytics Solution. Students will learn how to browse cubes and configure Pivot Tables and Charts using a number of common usage scenarios. In addition, students will learn advanced report creation by using the Report Builder to create and publish their own SQL Server Reporting Services report. At the end of this lab, you should be able to Understand the features and benefits of IT Analytics and be able to create your own reports and dashboards. Understand the basics of an OLAP cube and how to browse them for data mining. Configure reports and charts using Pivot Tables and Pivot Charts. Configure a Key Performance Indicator. Create and publish a SQL Server Reporting Services chart using Report Builder. Notes A brief presentation will introduce this lab session and discuss key concepts. The lab will be directed and provide you with step-by-step walkthroughs of key features. Feel free to follow the lab using the instructions on the following pages. You can optionally perform this lab at your own pace. Be sure to ask your instructor any questions you may have. Thank you for coming to our lab session.

2 Introduction to IT Analytics What is IT Analytics Solution? o o o o o Leverages Business Intelligence to offer: Advanced ad-hoc data-mining Analyze Trends and historical information Graphical dashboards and powerful reporting Expands upon traditional reporting Designed to facilitate analysis of information Leverages OLAP cubes to provide multi-dimensional data exploration Built on Standard Technologies (SQL Server Analysis and Reporting Services) What it enables you to do? o o o Continuously improve your IT Operations Answers existing scalability issues Resources & time savings Who is it intended for? o New and existing Symantec Management Platform (SMP) clients Optimize your Altiris investment Drill through your Symantec CMDB to mine the right information at the right time Make it easy for users to understand your complex environment Identify trends and opportunities faster Accelerate the decision making process Make fully informed decisions about your organization s performance. Continuously measure & continuously improve 2 of 58

3 Configure Pivot Tables and Pivot Charts Exercise 1: Configure a PivotTable report Using the ad-hoc data mining capabilities of IT Analytics we will perform some forensic analysis of the AntiVirus policy settings that have been applied within the Symantec Endpoint Protection Manager. 1. Launch the Altiris Console by double clicking the Symantec Management Console 7.1 shortcut on the desktop. 2. Click the Reports menu item and select All Reports. 3. Expand the Reports folder. 4. Expand the IT Analytics folder. 5. Expand the Cubes folder. 6. Select the Patch Management Cube. 7. Click Ok when prompted. 8. 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. 9. Drag and drop the Vulnerable Computer Count measure into the Totals pane: 3 of 58

5 11. 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 for the Provider: 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. 12. Drag and drop the Software Update - Severity attribute into the Columns pane: a. Resize\Move the Pivot Table Field List box to optimize your view of the Patch Cube data. 5 of 58

6 13. Right Click on the Critical column and select Filter by Selection. 6 of 58

8 15. Drag the Computer OS Name attribute from the field list directly into the Filter pane. 8 of 58

9 16. 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. 9 of 58

10 17. 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. 18. Finally you can save this report by clicking this icon in the toolbar. 19. Select the Save as new view radio button and name it appropriately. 20. 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. 10 of 58

11 21. 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. 22. 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. 11 of 58

12 Exercise 2: Configure a Pivot Chart report Using the Patch Management Cube we will create a Chart that will allow us to see the Installed versus Vulnerable counts of Adobe Patches on Windows Servers. 1. Launch the Altiris Console by double clicking the Symantec Management Console 7.1 shortcut on the desktop. 2. Click the Reports menu item and select All Reports. 3. Expand the Reports folder. 4. Expand the IT Analytics folder. 5. Expand the Cubes folder. 6. Select the Patch Management Cube. 7..Click this icon in the toolbar. 8. Click inside the Pivot Chart to display the Field List. 9. Click this icon in the toolbar above the pivot chart. 10. From the Commands and Options dialog window select Bar and then the first chart type. 12 of 58

13 11. Close Commands and Options window using the X on the top right of the pane. 12. Drag and drop the Installed Computer Count and the Vulnerable Computer Count measures into the pivot chart. 13. Drag and drop the Software Update Provider attribute from the field list to the filter pane. 13 of 58

14 14. Click on the dropdown arrow on the Software Update Provider attribute in the filter pane and select only Adobe Systems and click OK. 15. Drag and drop the Computer OS Name attribute into the "Drop Category Fields Here" pane. 14 of 58

16 18. Right click on the Computer OS Name attribute and select Expand. 19. You should now see all of the patch references expanded for each of the server operating systems. 16 of 58

17 20. Close the field list and click this icon in the toolbar to expand the Legend. Now that we have the basic structure we are ready to do some formatting to make this chart easier to read. 21. Click this icon in the toolbar to launch the Commands and Options window. 17 of 58

18 22. In the Commands and Options window select the Chart Workspace value from the dropdown list. 18 of 58

19 23. Click this icon to add a Chart Title. 19 of 58

20 24. Now switch from Chart Workspace to Title in the dropdown list 25. Select the Format tab and update the following: a. Change the font size from 12 to 14. b. Update the Caption text box at the bottom and replace Chart Workspace Title to Adobe Patches Installed vs. Vulnerable Server Count or another appropriate title. 20 of 58

21 26. Click the General tab and switch from Title to Legend from the dropdown list. 27. Click the Format tab and change the Position from Right to Bottom. 21 of 58

22 28. Select the General tab and switch from Legend to Chart Workspace from the dropdown list. 29. Select the Show/Hide tab and uncheck the Field buttons/drop zones checkbox. a. This will remove the drop panes to make the chart appear cleaner. 30. Close the Commands and Options window. 22 of 58

23 31. Finally click the Save icon and name this chart appropriately to save it for later use. 23 of 58

24 Exercise 3: Configure a Key Performance Indicator Using the Patch Management Cube we will create a KPI that will allow for the monitoring the Patch Installations versus Patch Applicability for a specific softoware provider bulletin. 1. Select the Patch Management Cube. 2. Drag both the Installed Computer Count and Applicable Count totals into the data pane. 24 of 58

32 Advanced Reporting This section will dive into advanced report creation using Report Builder to create and publish a SQL Server Reporting Services report. What is Report Builder Report Builder is a component of SQL Server Reporting Services that allows ad-hoc reporting functionality enabling end users to build their own reports and charts. Users can then publish these reports into Reporting Services where they can be accessed and viewed. Exercise 4: Create and publish a report using Report Builder In this exercise we will create a pie chart that displays the trend of Software Updates. 1. Launch a new web browser and type in 2. Click Report Builder. 32 of 58

33 3. When Microsoft Report Building loads, click on the report body and in the Properties pane, expand Size and set the Width to 11in and Height to 8.5in. 4. Click on the text Click to add title and type in Software Update Dashboard. 33 of 58

37 9. In the Connection Properties window, enter. for the Server name, select IT Analytics as the database and click OK. 10. Click OK in the Data Source Properties window. 37 of 58

38 11. Right-click on Datasets and select Add Dataset. 38 of 58

39 12. In the Dataset Properties window, select the Use a dataset embedded in my report radio button, click on the dropdown for Data source and select ITAnalytics. 13. Click the Query Designer button in the Dataset Properties window. 39 of 58

40 14. Click the cube selector on the upper left part of the Query Designer. 15. Select Patch Management from the Cube Selection window. 40 of 58

42 18. Drag and drop the Software Update Severity attribute to the query pane. 19. Click OK in the Query Designer window and the Dataset Properties window to go back to the main report builder. 42 of 58

43 20. Click on Insert in the report builder menu and select Chart and Chart Wizard. 21. In the New Chart window, select DataSet1 and click Next. 43 of 58

44 22. Select Pie under Chart Type and click Next. 44 of 58

45 23. From Available fields, drag Software_Update Severity to the Series pane and Vulnerable_Computer_Count to the Values pane and click Next. 45 of 58

51 30. Select the chart and in the Properties pane, expand size and set Width to 5in and Height to 3in. 31. Preview the report by clicking the Run Report button in the toolbar and make any other adjustments. 51 of 58

52 32. After selecting the Run Report button you will be presented with a preview of your report with realtime data. 33. Select the Design button on the toolbar to return to the Design view. 52 of 58

53 34. Click the icon in the Report Builder toolbar to save this report to Reporting Services IT Analytics folder and name it Software Update Dashboard. 35. To link this report into the Altiris Console Open the Altiris Console from the shortcut on your desktop then navigate to the Reports > IT Analytics > Dashboards folder. 53 of 58

55 38. In the Report Name dropdown box locate and select the report you just saved and click the Add Report button. 39. Refresh your browser and expand the Dashboards folder. 40. Locate and select the report you just added. 55 of 58

56 Exercise 5: Optional In this exercise we will add an additional report to the dashboard created in Exercise Repeat steps 11 to 19 from exercise 4 to create another Dataset, but instead of using the measure, Vulnerable Computer Count in step 17 and the attribute Software Update Severity in step 18, use Vulnerability Count for the measure and Software Update Provider for the attribute. 56 of 58

57 2. Repeat steps 20 to 30 to create a second chart. Use Dataset2 for step 21 instead of Dataset1. For step 23, drag Software_Update Provider to the Series pane and Vulnerability_Count to the Values pane. For step 26, name the chart Vulnerability Count by Provider. 57 of 58

58 3. Move the newly inserted chart to the right of the Vulnerable Computer Count by Severity chart by dragging the chart using the icon on the upper left corner of the chart. Click the icon in the Report Builder toolbar to save this report. 4. Open the Altiris Console from the shortcut on your desktop then navigate to the Reports > IT Analytics > Dashboards folder. 5. Locate and the report you just updated. 58 of 58

2013 Create an Excel BI report and share on SharePoint 2013 Hands-On Lab Lab Manual This document is provided as-is. Information and views expressed in this document, including URL and other Internet Web

BID2WIN Workshop Advanced Report Writing Please Note: Please feel free to take this workbook home with you! Electronic copies of all lab documentation are available for download at http://www.bid2win.com/userconf/2011/labs/

EML-09 Keeping Operating Systems and Applications up to date with Patch Management 7.1 Description Maintianing consistant and current patch status is a critical part of any security strategy. In this lab,

UP L04 Introduction to 3 rd Party Patching Using the 4A Model Hands-On Lab Description The objective of this course is to introduce students to the various concepts of 3rd party patching. Students will

Introduction to Microsoft Access 2010 A database is a collection of information that is related. Access allows you to manage your information in one database file. Within Access there are four major objects:

EML 03 Best Practices for Policy Management in Client Management Suite Hands-On Lab Description If you are new to the Symantec Management Technologies or are just looking to reinforce your existing knowledge

Introduction to Microsoft Access 2013 A database is a collection of information that is related. Access allows you to manage your information in one database file. Within Access there are four major objects:

CREATING PIVOT TABLE REPORTS How do I rearrange the format of the detail report so that subtests show as column headings instead of appearing in the body of the report? Show subtests as column headings

USING STUFFIT DELUXE StuffIt Deluxe provides many ways for you to create zipped file or archives. The benefit of using the New Archive Wizard is that it provides a way to access some of the more powerful

Access Your SharePoint Web Site... 2 Work with Folders and Documents in a Shared Documents Library... 2 Edit a Document... 2 Create a New Document... 3 Create a New Folder... 4 Upload One or Multiple Documents...

Appendix A How to create a data-sharing lab Creating a lab involves completing five major steps: creating lists, then graphs, then the page for lab instructions, then adding forms to the lab instructions,

Tutorial 3 Maintaining and Querying a Database Microsoft Access 2010 Objectives Find, modify, and delete records in a table Learn how to use the Query window in Design view Create, run, and save queries

Access Tutorial 3 Maintaining and Querying a Database Microsoft Office 2010 Objectives Find, modify, and delete records in a table Learn how to use the Query window in Design view Create, run, and save

Microsoft QUICK Source Access 2007 Getting Started The Access Window u v w x y z Creating a Database Based on a Template When you create a database based on a template, preformatted tables, queries, forms,

QUICK DOC: [Pivot Table Reporting} Pivot Table Reporting For the purposes of this document we are using the Utility Consumption Tracking Module to create our report and charts, but almost any data exported

Introduction Format and manipulate data using pivot tables. Using a grading sheet as and example you will be shown how to set up and use lookup tables and scenarios. Contents Introduction Contents Pivot

Technical Paper Build Your First Web-based Report Using the SAS 9.2 Business Intelligence Clients A practical introduction to SAS Information Map Studio and SAS Web Report Studio for new and experienced

Windows XP Chinese Character Support Installation Instruction Windows XP has a utility to allow user to modify language sets for both multi-language input and viewing of foreign character sets. This document

Converting an Excel Spreadsheet Into an Access Database Tracey L. Fisher Personal Computer and Software Instructor Butler County Community College - Adult and Community Education Exceeding Your Expectations..

Creating PivotTables in Excel 2010 Table of Contents OVERVIEW OF PIVOTTABLE AND PIVOTCHART REPORTS... 4 WHAT IS A PIVOTTABLE REPORT?... 4 Ways to work with a PivotTable report... 5 WHAT IS A PIVOTCHART

NDUS Training and Documentation Analyzing Excel Data Using Pivot Tables Pivot Tables are interactive worksheet tables you can use to quickly and easily summarize, organize, analyze, and compare large amounts

Mitigation Planning Portal MPP Reporting System Updated: 7/13/2015 Introduction Access the MPP Reporting System by clicking on the Reports tab and clicking the Launch button. Within the system, you can

Microsoft Access 2010 handout Access 2010 is a relational database program you can use to create and manage large quantities of data. You can use Access to manage anything from a home inventory to a giant

Crystal Reports Payroll Exercise Objective This document provides step-by-step instructions on how to build a basic report on Crystal Reports XI on the MUNIS System supported by MAISD. The exercise will

Getting Started Before you begin create a folder on your desktop called DreamweaverTraining This is where you will save your pages. Inside of the DreamweaverTraining folder, create another folder called

Task Force on Technology EXCEL Basic terminology Spreadsheet A spreadsheet is an electronic document that stores various types of data. There are vertical columns and horizontal rows. A cell is where the

Microsoft SharePoint 2010 End User Quick Reference Card Microsoft SharePoint 2010 brings together the people, documents, information, and ideas of the University into a customizable workspace where everyone

WebFOCUS BI Portal: S.I.M.P.L.E. as can be Author: Matthew Lerner Company: Information Builders Presentation Abstract: This hands-on session will introduce attendees to the new WebFOCUS BI Portal. We will

Creating a Pie Graph Step-by-step directions In this example, Mrs. Smith is looking to create graphs that represent the ethnic diversity of the 24 students in her 4 th grade class. 1. Enter Data A. Open

Creating a connection using Microsoft Excel 2007, 2010, 2013 The steps for creating a connection in Excel 2007, Excel 2010 and Excel 2013 are the same. In the following example Excel 2010 will be used.

Access(ing) A Database Project PRESENTED BY THE TECHNOLOGY TRAINERS OF THE MONROE COUNTY LIBRARY SYSTEM EMAIL: TRAININGLAB@MONROE.LIB.MI.US MONROE COUNTY LIBRARY SYSTEM 734-241-5770 1 840 SOUTH ROESSLER

MicroStrategy Desktop Quick Start Guide MicroStrategy Desktop is designed to enable business professionals like you to explore data, simply and without needing direct support from IT. 1 Import data from

Basic Pivot Tables Pivot tables summarize data in a quick and easy way. In your job, you could use pivot tables to summarize actual expenses by fund type by object or total amounts. Make sure you do not

SQL Server Integration Services (SSIS) is a set of tools that let you transfer data to and from SQL Server 2005. In this lab, you ll work with the SQL Server Business Intelligence Development Studio to

1 Chapter 4: In its most basic form, a website is a group of files stored in folders on a hard drive that is connected directly to the internet. These files include all of the items that you see on your

2011-2012 Using the SAS Enterprise Guide (Version 4.2) Table of Contents Overview of the User Interface... 1 Navigating the Initial Contents of the Workspace... 3 Useful Pull-Down Menus... 3 Working with

Microsoft Access 2010 Part 1: Introduction to Database Design What is a database? Identifying entities and attributes Understanding relationships and keys Developing tables and other objects Planning a