I would configuration settings DCM build the configuration item to check
for the install and easily populate the collection that you can target
deployment to.

On Fri, Oct 23, 2015, 10:55 AM Nick <[email protected]> wrote:

> 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_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   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] <[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] <[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.
>
>
>



Reply via email to