olzblackberry.blogg.se

In this query we’re joining three different views to get the computer name, OS, and last quick/full scan times.

There’s just more “elbow room” there, and you can cheat and use the graphical Design Query in Editor to simplify cross-view joins if you need to. Though you can build the query logic directly in Report Builder, I find it’s easier to just build the query through SQL Server Management Studio. The first step in creating the report is to build the base query from which you’ll derive the data. Also, we’re going to add the computer name, and operating system version to show how easy it is to join data across Configuration Manager and Endpoint Protection views. The example we’re going to run through is creating a simple table that shows start and finish times for both quick and full antimalware scans, with a date-based variable so you can see just clients with a scan-date older than the date you specify. I’m going to cover an example of how you can build a custom-report for last antimalware scan-time using available System Center 2012 Configuration Manager and Endpoint Protection data, Report Builder 3.0, and the reporting point with SQL Reporting Services.

Though we offer over 400 total System Center 2012 Configuration Manager reports out-of-box, there will certainly be scenarios where you’ll need your own reports.įor example, we offer 6 primary out-of-box Endpoint Protection reports, but with the amount of data available from both management and security data-points, you will undoubtedly want to create custom reports tailored to your organizational needs. One of the advantages of having the Endpoint Protection and Configuration Manager data integrated into a single database in Configuration Manager 2012 is that it simplifies building custom reports.

First published on CloudBlogs on Mar, 28 2012