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