non-compliance collection query
This query is being used inside of a collection to create a colleciton based on non-compliance. I followed the steps outlined in the non-compliant computer remediation article from microsoft. Can anyone see what i might be missing? it is certainly not working so i am wondering if maybe its just syntax? Thanks for any help, select SMS_R_SYSTEM.ResourceID, SMS_R_SYSTEM.ResourceType, SMS_R_SYSTEM.Name, SMS_R_SYSTEM.SMSUniqueIdentifier, SMS_R_SYSTEM.ResourceDomainORWorkgroup, SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_CI_ComplianceState on SMS_G_System_CI_ComplianceState.ResourceID = SMS_R_System.ResourceId Where SMS_G_System_CI_ComplianceState.ComplianceStateName = "<non-compliant>" and SMS_G_System_CI_ComplianceState.LocalizedDisplayName = "<CHP - CA Antivirus Install Configuration Item>" and SMS_G_System_CI_ComplianceState.CI_UniqueID = "<1>"
November 4th, 2008 1:15am

I gave that one a shot but still no dice, do i have the unique id wrong possibly? Thanks for the help
Free Windows Admin Tool Kit Click here and download it now
November 4th, 2008 6:26pm

CIUniquieID should be something like 00359dc6-054a-455d-92dc-82496d75ec09 http://technet.microsoft.com/en-us/library/bb680546.aspx copy the corrected verison I put up and then edit it in the Query crieteria editor for each value. The query will look like this: select SMS_R_System.ResourceId, SMS_R_System.ResourceType, SMS_R_System.Name, SMS_R_System.SMSUniqueIdentifier, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.Client from SMS_R_System inner join SMS_G_System_CI_ComplianceState on SMS_G_System_CI_ComplianceState.ResourceID = SMS_R_System.ResourceId where SMS_G_System_CI_ComplianceState.ComplianceStateName = "Non-Compliant" and SMS_G_System_CI_ComplianceState.LocalizedDisplayName = "Cumulative Security Update for Internet Explorer 6 for Windows XP (KB956390)" and SMS_G_System_CI_ComplianceState.CI_UniqueID = "00459dc6-054a-455d-99dc-82496d75ec09"
November 4th, 2008 7:07pm

Any hints where i can find that unique ID?I cant think of anyplaceI have seen something like that. Thanks
Free Windows Admin Tool Kit Click here and download it now
November 4th, 2008 8:33pm

Check the Report: Compliance 6 - Specific computer Category: Software Updates - A. Compliance Far right hand column is the UpdateID
November 4th, 2008 8:47pm

I tried this query and it's not returning any resultsselect SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_CI_ComplianceState on SMS_G_System_CI_ComplianceState.ResourceID = SMS_R_System.ResourceId where SMS_G_System_CI_ComplianceState.ComplianceStateName = "Non-Compliant" and SMS_G_System_CI_ComplianceState.LocalizedDisplayName = "Cumulative Security Update for Internet Explorer 6 for Windows XP (KB978207)" and SMS_G_System_CI_ComplianceState.CI_UniqueID = "e6c1a5e2-8d1a-471e-b81e-74b488b8b60e"Why?
Free Windows Admin Tool Kit Click here and download it now
March 5th, 2010 8:35pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics