:::: MENU ::::

Collection Query Based on Advertisement Last staus

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_ClientAdvertisementStatus join SMS_R_System on SMS_R_System.ResourceID = SMS_ClientAdvertisementStatus.ResourceID where SMS_ClientAdvertisementStatus.AdvertisementID in(‘A0120005’) and SMS_ClientAdvertisementStatus.LastStateName In(‘Succeeded’)


So, what do you think ?