Share via


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:

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:

  1. ComplianceStateName from v_CICurrentComplianceStatus

  2. DisplayName from v_LocalizedCIProperties

  3. Description from v_LocalizedCIProperties

  4. Netbios_Name0 from v_R_System

  5. 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