Collection based on advertisement Status
For those cases when you happened to oversee something during your package testing, it could be very useful if you could group all clients with a specific problem together rather than just exporting them from the advertisement status they are in
Based on that group you could then create a new program to rectify the situation.
to achieve this, paste the following WQL in a new query based rule and modify the advertisementID or status according to your needs:
select SYS.ResourceID,SYS.ResourceType,SYS.Name,SYS.SMSUniqueIdentifier,SYS.ResourceDomainORWorkgroup,SYS.Client from sms_r_system as sys inner join SMS_ClientAdvertisementStatus as offer on sys.ResourceID=offer.ResourceID WHERE AdvertisementID = ’00120019′ and LastStateName = “Failed”
Categories: SCCM