SCCM 2012 OU Based query missing objects RRS feed

  • Question

  • 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?

    Friday, November 15, 2013 11:29 PM


All replies

  • 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.

    Nash Pherson, Senior Systems Consultant
    Now Micro - My Blog Posts
    <-- If this post was helpful, please click "Vote as Helpful".

    Friday, November 15, 2013 11:38 PM
  • 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.

    Friday, November 15, 2013 11:48 PM
  • Hi,

    Have you checked colleval.log on the site server? This log records details about when collections are created, changed, and deleted by the Collection Evaluator.

    Best Regards,

    Joyce Li

    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time.
    Thanks for helping make community forums a great place.

    • Proposed as answer by Joyce L Tuesday, November 26, 2013 1:29 AM
    • Marked as answer by Garth JonesMVP Monday, February 1, 2016 5:21 PM
    Thursday, November 21, 2013 2:26 AM
  • Elvis,

    I am encountering a similar problem, only the my collection is based on SMS_R_System.SystemGroupName.  Fully populated and then you deploy clients and the membership numbers drop significantly.

    I went to look at the colleval.log but it has already wrapped so I am not able to get meaningful data.

    Have you made any progress on this issue?


    Tuesday, March 29, 2016 5:49 PM
  • Additional note - After reading your post and doing a lot of digging, my collection is populating from another collection based on OU membership so my problem is identical to yours.
    Tuesday, March 29, 2016 6:15 PM