Hi all,

I am currently trying to use this collection query that is supposed to pull all objects in a particular OU into a single collection:

• select * from SMS_R_System where SMS_R_System.SystemOUName = "econolite.com/Managed Assets/Forefront Managed/Tecate-Campus, MX"

However, Once I save this query as a membership rule it gets changed to:

• 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.SystemOUName = "domain.com/OU/OU/OU"

I have 175 objects in this OU. When I first created this collection 120 objects were found and placed into this collection. After pushing the SCCM client to this collection the number of objects in this collection got reduced to 33.

There are still 175 objects in the OU but on 33 show in the collection. The objects do populate the default "All Desktop and Server Clients" collection quite nicely once the client was installed.

It was after the clients were installed that I noticed my custom collection emptying.

Why did my objects disappear and how do I get them back?

• Edited by Elvis P. Johnson Friday, November 15, 2013 11:29 PM

If you update your collection membership, do they return?  This can happen as an device goes from not having a client and having a heartbeat discovery.

Only thing I haven't done is delete the collection and re-create it. It did at one time have close to the correct number of objects in it.

So, yes. I updated the collection membership with no luck.