Use the Below Query which will give you all the system where the particular Advertisement is in Particular state
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 Join SMS_ClientAdvertisementStatus ON SMS_ClientAdvertisementStatus.ResourceID = SMS_R_System.ResourceID Where SMS_ClientAdvertisementStatus.AdvertisementID = 'ADV ID' and SMS_ClientAdvertisementStatus.LastStateName = 'state (No Status/Succeeded..e.t.c.)'
No comments:
Post a Comment