This article will discuss how to combine SEP and DLP data within IT Analytics by leveraging Microsoft Report Builder to create and publish a SQL Server Reporting Services report. For the purposes of this exercise, we will utilize some of the out-of-the-box functions in Report Builder to link data from multiple cubes into one report.
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, viewed and incorporated back into IT Analytics alongside existing reporting.
NOTE: To complete this exercise, you should have IT Analytics already installed and configured, with both the Symantec Endpoint Protection and Data Loss Prevention Content Packs. Also, note that while the output produced by Report Builder is integrated with IT Analytics, the tools and subsequent query language behind it are separate Microsoft entities and are thereby outside the default capabilities of the IT Analytics product itself.
Resize the font of the title so that it fits within the given area. Also, widen the columns of the table so that you can read the column headers. You can do this in the same way you would with Excel, simply click on the line between the columns, and when a grey bar appears at the top of the table, then expand by dragging the columns.
=Lookup(Fields!Agent___Name.Value,Fields!Computer___Computer_Name.Value,Fields!Virus_Definition___Version.Value, "SEPVersion")
=Lookup(Fields!Agent___Name.Value,Fields!Computer___Computer_Name.Value,Fields!Last_Checkin_Date___Date.Value, "SEPVersion")
=Lookup(Fields!Agent___Name.Value,Fields!Computer___Computer_Name.Value,Fields!Alerts.Value, "SEPAlerts")