SCCM Collection based on AD group having inconsistent results

SAMUEL VALAPARLA 131 Reputation points
2021-09-01T11:47:43.537+00:00

Hi All,

We're running MECM 2010.

Have created a device collection with the below query which is basically populating the members from an AD Group.

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.SystemGroupName = "Domain_Name\My_Testing"

The above query is giving different results (lesser members) than what we observe when directly checking the AD Group members in Users and Computers. Basically the SMS_R_System WMI class doesn't seem to have correct information pertaining to the AD group, as we have some machines not showing up in the query results. But the same machine shows up in the AD group membership under Users and computers.

And this seems to be a repetitive cycle. i.e. machine A doesn't show up in the collection today.. and then it shows up subsequently.. but then goes missing again.

I'm basically checking the SCCM Console as well as running AD Users and Computers on the Site Server itself, so I believe the same domain controller is being used. So my question is, what exactly populates the SMS_R_System WMI class and what could be the possible reasons for this inconsistent results?

Thank You

Microsoft Configuration Manager
0 comments No comments
{count} votes

Accepted answer
  1. Garth Jones 1,356 Reputation points
    2021-09-01T12:11:49.05+00:00

    Your question is "loaded" as it will depended on a few things.

    If the device does NOT have CM client on it, it will be populated by AD Group discovery or AD system discovery.
    If the device HAS CM client on it, it will be populated by Heartbeat discovery. AND the device need to know that it belongs to the group (aka logon (reboot))

    If the groups membership changes from one time to the next, that could be many things. Some of them are:

    • AD is having replication issues.
    • You have duplicated CM client GUIDs
    2 people found this answer helpful.

1 additional answer

Sort by: Most helpful
  1. Amandayou-MSFT 11,141 Reputation points
    2021-09-06T10:31:16.213+00:00

    Hi,

    Haven't heard from you for some time, is Garth's answer helpful to you? If it is helpful, please accept answer. It will make someone who has the similar issue easily find the answer.

    If you have any other issues, please don't hesitate to let us know.

    Thanks and have a nice day.

    Best regards,
    Amanda

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.