Custom DCM report for showing summary compliance for a configuration baseline by computer

Recently I had to come up with a custom Desired Configuration Management (DCM) report which shows summary compliance for a configuration baseline by computer.
This report is linked from the builtin Summary compliance by configuration baseline report which passes Configuration Baseline Name and Configuration Baseline Content Version as input parameters to my custom report.

Here is the actual query used within my custom report:

SELECT
v_R_System.Name0 AS 'Computer Name',
v_CICurrentComplianceStatus.ComplianceStateName AS 'Compliance State Name',
v_CICurrentComplianceStatus.ComplianceState AS 'Compliance State',
v_LocalizedCIProperties_SiteLoc.DisplayName AS 'DCM Baseline Name',
v_ConfigurationItems.CIVersion AS 'DCM Baseline Content Version'
FROM
v_BaselineTargetedComputers
INNER JOIN v_R_System ON v_R_System.ResourceID = v_BaselineTargetedComputers.ResourceID
INNER JOIN v_ConfigurationItems ON v_ConfigurationItems.CI_ID = v_BaselineTargetedComputers.CI_ID
INNER JOIN v_CICurrentComplianceStatus ON v_CICurrentComplianceStatus.CI_ID = v_ConfigurationItems.CI_ID AND v_CICurrentComplianceStatus.ResourceID = v_BaselineTargetedComputers.ResourceID
INNER JOIN v_LocalizedCIProperties_SiteLoc ON v_LocalizedCIProperties_SiteLoc.CI_ID = v_ConfigurationItems.CI_ID
WHERE
v_LocalizedCIProperties_SiteLoc.DisplayName = @name
AND
v_ConfigurationItems.CIVersion = @cicontentversion

Advertisements
Custom DCM report for showing summary compliance for a configuration baseline by computer

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s