You can use a Configuration Manager 2007 report to identify all client computers that have not reported the compliance status of a configuration baseline for a specified number of days.

These procedures guide you through the process of using Configuration Manager 2007 to create and display a report using the Configuration Manager console.

To create a Configuration Manager report that identifies client computers that have not reported the compliance status of a configuration baseline for a specified number of days

  1. In the Configuration Manager console, navigate to System Center Configuration Manager / Site Database / Computer Management / Reporting.

  2. Expand the Reporting node, right-click Reports, click New, and then click Report.

  3. On the General page of the New Report Wizard, specify the following:

    • Name: Specify a name for the report such as Computers that have not reported compliance for a specified configuration baseline in a specified number of days.

    • Category: From the drop-down list select Desired Configuration Management - Errors.

    • Comment: Enter a descriptive comment for the report such as This report displays computers that have not reported compliance status for a specified configuration baseline in a specified number of days.

    • Click Edit SQL Statement.

  4. In the Report SQL Statement dialog box, specify the following:

    • SQL statement: Copy and paste the following code into the SQL statement box:

        Copy Code 
      select distinct
   sys.Netbios_Name0,
   loc.DisplayName as BaselineName,
   cs.ComplianceStateName as ComplianceState,
   cs.LastComplianceMessageTime,
   DATEDIFF(Day, MAX(cs.LastComplianceMessageTime), GetDate()) AS "Days since last report"
from v_CITargetedMachines target with (NOLOCK)
inner join v_ConfigurationItems ci on ci.CI_ID=target.CI_ID
left join v_LocalizedCIProperties_SiteLoc loc on ci.CI_ID=loc.CI_ID
inner join v_R_System sys on sys.ResourceID=target.ResourceID
left join v_CICurrentComplianceStatus cs with (NOLOCK) on cs.CI_ID=ci.CI_ID and cs.ResourceID=target.ResourceID
where loc.DisplayName = @ciid
GROUP BY
   sys.Netbios_Name0,
   loc.DisplayName,
   cs.ComplianceStateName,
   cs.LastComplianceMessageTime
HAVING (@variable <= DATEDIFF(Day, MAX(cs.LastComplianceMessageTime), GetDate()))
ORDER BY sys.Netbios_Name0
    • Click Prompts.

  5. In the Prompts dialog box, click New to create a new prompt.

  6. In the Prompt Properties dialog box, specify the following:

    • Name: Specify the name variable.

    • Prompt text: Specify Enter number of days.

    • Click OK to close the Prompt Properties dialog box.

  7. In the Prompts dialog box, click New to create a new prompt.

  8. In the Prompt Properties dialog box, specify the following:

    • Name: Specify the name ciid.

    • Prompt text: Specify Baseline display name.

    • Select Provide a SQL statement.

    • Click Edit SQL statement.

  9. In the Prompt SQL Statement dialog box, specify the following:

    • Copy and paste the following code into the SQL statement box:

        Copy Code 
      if (@__filterwildcard = '')
begin
   select distinct
   DisplayName,
   CI_UniqueID
   from v_ConfigurationItems ci
   left join v_LocalizedCIProperties_SiteLoc loc on ci.CI_ID=loc.CI_ID
   where ci.CIType_ID=2
   order by DisplayName
end
else
begin
  select distinct
   DisplayName,
   CI_UniqueID
   from v_ConfigurationItems ci
   left join v_LocalizedCIProperties_SiteLoc loc on ci.CI_ID=loc.CI_ID
   where ci.CIType_ID=2
   and Displayname like @__filterwildcard
   order by DisplayName
end
    • Click OK to close the Prompt SQL Statement dialog box.

  10. Click OK to close the Prompt Properties dialog box.

  11. Click OK to close the Prompts dialog box.

  12. In the LinkReportPromptsDialog dialog box, click Yes to update the prompts in the report.

  13. Click OK to close the Report SQL Statement dialog box.

  14. Click Ok to close the dialog box Computers that have not Reported Compliance for a Specified Configuration baseline in a Specified Number of Days.

To run the report that identifies client computers that have not reported the compliance status of a configuration baseline for a specified number of days

  1. In the Configuration Manager console, navigate to System Center Configuration Manager / Site Database / Computer Management / Reporting.

  2. In the Reports node, click the Category column to sort the reports so that you can more easily find the reports relating to desired configuration management.

  3. Right-click the report Computers that have not reported compliance for a specified configuration baseline in a specified number of days, and click Run.

  4. In the Report Information page, specify the following information:

    • Enter Number of Days: Specify the number of days since client computers last reported compliance.

    • Baseline Display Name: Specify the name of the configuration baseline or click Values to select it from a list.

      Note
      It is possible for multiple configuration baselines to share the same display name. To help identify the correct configuration baseline, the configuration item unique ID is displayed alongside the configuration baseline name when you click Values. For further information about distinguishing configuration data with the same name, see How to Distinguish Configuration Data with the Same Name in Desired Configuration Management.

  5. Click Display to view the report. A list of client computers that have not reported compliance for the specified number of days is displayed, together with the last successful compliance state and its date and time.

  6. Close the report.

See Also