Advanced Exercise 1: Create a New Report for Compliance Settings in Configuration Manager
Updated: January 1, 2014
Applies To: System Center 2012 Configuration Manager, System Center 2012 Configuration Manager SP1, System Center 2012 R2 Configuration Manager
In this exercise, you will create a Configuration Manager report that displays the name and description of the configuration baselines that are deployed to a specified computer and whether the computer returns compliant or noncompliant for the configuration baseline.
Important
Before you begin this exercise, you should review the basic exercises to learn about the report elements, the properties for a report, and the different ways to create the report SQL statement.
Report Requirements
Use the following report requirements to create the new report.
SQL Server Views in the SQL Statement
Use the following Configuration Manager SQL views when creating the report SQL statement:
v_CICurrentComplianceStatus: This SQL view contains compliance information for all configuration items. For more information about this SQL view, see Compliance Settings Views in Configuration Manager.
v_ConfigurationItems: This SQL view contains all of the configuration items. For more information about this SQL view, see Compliance Settings Views in Configuration Manager.
v_LocalizedCIProperties: This SQL view contains the localized titles and descriptions for the configuration items. For more information about this SQL view, see Compliance Settings Views in Configuration Manager.
v_R_System: This SQL view contains all of the discovered system resources. For more information about this SQL view, see Discovery Views in Configuration Manager.
JOINS in the SQL Statement
Create the following JOINS in the SQL statement:
v_CICurrentComplianceStatus is joined to v_ConfigurationItems by using the CI_ID column.
v_CICurrentComplianceStatus is joined to v_LocalizedCIProperties by using the CI_ID column.
v_CICurrentComplianceStatus is joined to v_R_System by using the ResourceID column.
Columns in the SQL Statement
Use the following report columns, in the order listed:
ComplianceStateName from v_CICurrentComplianceStatus
DisplayName from v_LocalizedCIProperties
Description from v_LocalizedCIProperties
Netbios_Name0 from v_R_System
CIType_ID from v_ConfigurationItems (Not displayed)
Sort the returned data in ascending order, using the Netbios_Name0 column.
Filters in the SQL Statement
The report SQL statement should meet the following filtering criteria:
- Select only configuration baselines. You can filter specifically on configuration baselines by selecting the CIType_ID. Configuration baselines are CI type 2.
Report Prompts
The Configuration Manager report should contain a report prompt for the computer name that will be reported on.
Solution
See Advanced Exercise 1 Solution: Create a New Report for Compliance Settings in Configuration Manager for detailed information about how to create this report.