How to Identify Computers that Have Not Reported Compliance for a Specified Time for Desired Configuration Management

Aplica-se a: System Center Configuration Manager 2007, System Center Configuration Manager 2007 R2, System Center Configuration Manager 2007 R3, System Center Configuration Manager 2007 SP1, System Center Configuration Manager 2007 SP2

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 CenterConfiguration 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:

      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:

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

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

Consulte Também

For additional information, see Configuration Manager 2007 Information and Support.
To contact the documentation team, email SMSdocs@microsoft.com.

Conteúdo da Comunidade

Mostrar: