Ended up figuring it out :)
The key unexposed class is: SMS_SUMDeploymentAssetDetails and I'm assuming it's
new to 2012.
I had to limit my query to some collections but simply put IsCompliant = 0 or 1
depending on your purpose. I'm assuming the summarization task has to run as
well for this to update?
SELECT SMS_R_SYSTEM.ResourceID, SMS_R_SYSTEM.ResourceType,
SMS_R_SYSTEM.Name, SMS_R_SYSTEM.SMSUniqueIdentifier,
SMS_R_SYSTEM.ResourceDomainORWorkgroup, SMS_R_SYSTEM.ClientFROM
SMS_R_SystemWHERE ResourceID NOT IN (SELECT
SMS_SUMDeploymentAssetDetails.ResourceID FROM SMS_SUMDeploymentAssetDetails
WHERE SMS_SUMDeploymentAssetDetails.CollectionID in ('XXX0000E','XXX0000F')
AND SMS_SUMDeploymentAssetDetails.IsCompliant = 0)
From: [email protected]
To: [email protected]
Subject: [mssms] Collection based on SUG Deployment Compliance State
Date: Tue, 27 May 2014 13:08:10 -0500
Has anyone done this? Basically I want to create a collection that includes
clients that are "compliant" for a specific software update group deployments.
Much appreciated!
Thank you,Stephen
