We have a bunch of CIs in our baseline and I want to be able to create a collection for non-compliance on the individual CI instead of the complete baseline. Is it possible to do this in 2012?

I am using SMS_G_System_CI_ComplianceState (ComplianceStateName) instead of SMS_G_System_DCMDeploymentState (ComplianceState) for the collection query.

But the problem is the CI_UniqueID in SCCM 2012 seems to end with the version/revision (like abc/5) of the CI. So the UniqueID changes everytime I make a change to the CI and is not really unique.

Then use the like operator in your query when comparing the CI_UniqueID.

what is your query looks like ?

Thank you Jason, that will work for me for now.

The query looks 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 where SMS_R_System.ResourceId not in (SELECT SMS_G_System_CI_ComplianceState.ResourceID from SMS_G_System_CI_ComplianceState Where  SMS_G_System_CI_ComplianceState.ComplianceStateName = "compliant" and SMS_G_System_CI_ComplianceState.LocalizedDisplayName = "ABC" and SMS_G_System_CI_ComplianceState.CI_UniqueID = "ScopeId_abc/BusinessPolicy_xyz")