IT Analytics offers customers unparalleled flexibility in the way they visualize, analyze, and consume their business critical data. In addition to providing users a valuable and comprehensive reporting solution out of the box, IT Analytics’ flexible architecture and use of standard technologies gives users several options for report creation. This article outlines the various way the same report can be created within IT Analytics.
This example shows how to create a report showing computers with critical patches through using the pivot table cube viewer in IT Analytics.
Drag Software Update – Severity up into the “Drop Filter Fields Here” pane. Click on the downward facing triangle next to the Software Update – Severity header to filer the result set. Uncheck all severity levels except Critical. Then click OK.
Drag and drop the Software Update - Reference attribute into the “Drop Totals or Details Fields Here” data pane.
Right-click on the Software Update – Reference column header and select Sort Descending. This will sort the number of critical patches with the most recent at the top.
The above example illustrates the ease of use with creating a report in IT Analytics, without previous knowledge of the Symantec CMDB schema or requiring any other programming skills. This very specific view can be saved for re-use or can be shared with other individuals in the organization.
This example shows how to export a pivot table view from IT Analytics and work with it in Microsoft Excel.
You should see the same report that was created in the pivot table format now within Excel. Note that even in Excel the same capabilities that were seen in the Symantec Management Platform console still exist, along with all the measures and dimensions that were available.
Locate and click the Computer – OS Name attribute from the PivotTable Field List pane on the right.
To regroup this report by Operating System Name first, click on the downward facing triangle next to the Computer – OS Name field in the Row Labels window in the bottom right, and select Move to Beginning.
You can then drill down within each operating system and see the same critical software updates by specific computer OS type.
This example includes building a report utilizing IT Analytics cubes in Microsoft Report Builder. Report Builder is a component included with SQL Server Reporting Services that allows ad-hoc reporting functionality, enabling end users to build their own reports and charts. Report Builder uses wizard driven steps to easily connect to data sources and locate the desired fields for creating a report. Users can then publish these reports back into the Symantec Management Platform console for viewing, as well as other venues like SharePoint and Reporting Services. For more information on using Report Builder, please see the Microsoft website.
Allow a few minutes for the application to load. Note that depending on which version of SQL Server you have, you may have a different version of Report Builder. This example covers Report Builder 3.0, which comes standard with SQL Server 2008 SP2 or higher. Note that while SQL Server 2005 meets the minimum prerequisites for installation of IT Analytics, it will only include Report Builder 1.0. If possible, Symantec strongly recommends using SQL Server 2008 SP2 or higher to take advantage of new features included in Report Builder 3.0 for a more robust custom report authoring experience.
Refresh your browser and expand the Reports folder.
Locate and select the report you just added.
IT Analytics provides users several ways to author custom reports, from simple drag-and-drop views to leveraging proven 3rd party applications, all in an effort to deliver flexible and robust reporting. Creating the above examples without IT Analytics would require advanced knowledge of the underlying database schema, as well as proficiency in writing SQL queries. By utilizing IT Analytics and the techniques described above, users can significantly expand their options for custom reporting with very little effort or programming experience.
This article is so useful for beginners like us