SMS collection based on advertisement ID or with statusBy Eswar KonetiSeptember 15, 1:30 pm2 Mins Read3,454 Views Here is the collection that gives you a list of machines with specific staus message ID: select sys.ResourceID,sys.ResourceType,sys.Name,sys.SMSUniqueIdentifier,sys.ResourceDomainORWorkgroup,sys.Client from sms_r_system…