This article is dedicated to providing working examples for DCM (Desired Configuration Managment) reports, using reporting services 2008. 1. This report displays three statenames for the baseline called BL - WK DCM. A count of Conpliance state populates the third column. SELECT CIProp.DisplayName AS 'DCM Baseline Name', SNames.StateName, COUNT(CCS.ComplianceState) AS 'Compliance State Count' FROM dbo.v_BaselineTargetedComputers AS BTC INNER JOIN dbo.v_ConfigurationItems AS CI ON CI.CI_ID = BTC.CI_ID INNER JOIN dbo.v_CICurrentComplianceStatus AS CCS ON CCS.CI_ID = CI.CI_ID AND CCS.ResourceID = BTC.ResourceID INNER JOIN ...