Hi
I'm trying to create a collection with a dynamic membership query.
I want only the clients on which an advertisement status is not successful.
So I can see on which clients the advertisement didn't not apply.
When I use this query, I see the clients on which the advertisement was successful:
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 where SMS_R_System.ResourceId in (select ResourceID from SMS_ClientAdvertisementStatus where AdvertisementID = "BMA20408" and LastStateName = "Succeeded")So my idea was to set the != Succeeded
But then I have no clients in the collection.
Any Idea how I can solve that?
- Moved by Stan White [MSFT]Microsoft employee, Moderator Tuesday, August 17, 2010 2:00 PM (From:Configuration Manager General)