Saturday, April 21, 2012

Collection - ADVERTISEMENT FAILED systems



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 = 'LAB20089' and LastStateName = "Failed"

No comments:

Post a Comment