Here's WQL we use to populate a collection of systems that fail a particular baseline. You could set your configuration item to whatever you want and FAIL them when you want them to fall into the collection.
select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SY STEM.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 join SMS_ConfigurationItemLatest on SMS_ConfigurationItemLatest.CI_UniqueID = SMS_G_System_CI_ComplianceState.CI_UniqueID where SMS_G_System_CI_ComplianceState.LocalizedDisplayName = "System Last Reboot Check" and SMS_ConfigurationItemLatest.ModelName like "ScopeId_5AA5043E-FF0B-4007-96DF-1DBAF20D4CC1/OperatingSystem_0b03446f-1264- 4cc4-a93c-1de15dcc00ae" and SMS_G_System_CI_ComplianceState.ComplianceStateName = "non-compliant" From: [email protected] [mailto:[email protected]] On Behalf Of Beardsley, James Sent: Friday, October 23, 2015 1:41 PM To: [email protected] Subject: [mssms] RE: Collection Populated by Deployment Status OK thanks. I'll give that a shot. From: [email protected] [mailto:[email protected]] On Behalf Of Daniel Ratliff Sent: Friday, October 23, 2015 1:38 PM To: [email protected] Subject: [mssms] RE: Collection Populated by Deployment Status Although its currently not supported by Microsoft, your simplest bet might just be a task sequence with a step for each. Daniel Ratliff From: [email protected] [mailto:[email protected]] On Behalf Of Beardsley, James Sent: Friday, October 23, 2015 1:34 PM To: [email protected] Subject: [mssms] Collection Populated by Deployment Status I'd like to build a collection that contains all machines that have successfully installed a specific application deployment. But because its security related, I need it to populate as quickly as possible so they will run a package that's deployed to that collection ASAP. Because of this, I'll need to avoid using inventory to populate the collection since that could take up to a day. I've heard of creating a collection off of status messages but never done it. I've played around with the status message queries but not having any luck. Is this possible? Note: The security app is an application and the follow-up is a package so I can't daisy-chain them together with Dependencies or "Run this program after" Thanks, James _____ Confidentiality Notice: This e-mail is intended only for the addressee named above. It contains information that is privileged, confidential or otherwise protected from use and disclosure. If you are not the intended recipient, you are hereby notified that any review, disclosure, copying, or dissemination of this transmission, or taking of any action in reliance on its contents, or other use is strictly prohibited. If you have received this transmission in error, please reply to the sender listed above immediately and permanently delete this message from your inbox. Thank you for your cooperation. The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information. _____ Confidentiality Notice: This e-mail is intended only for the addressee named above. It contains information that is privileged, confidential or otherwise protected from use and disclosure. If you are not the intended recipient, you are hereby notified that any review, disclosure, copying, or dissemination of this transmission, or taking of any action in reliance on its contents, or other use is strictly prohibited. If you have received this transmission in error, please reply to the sender listed above immediately and permanently delete this message from your inbox. Thank you for your cooperation.
