SOLVED Query based Collection not Upgrading

[janos98]

Hello Guys,

I have problem with a collection. It's doesn't refreshing any item from AD Group.
At this moment has got 7 member, but when I run the query it gives back much more..
So I think there is no problem with the query.

Update membership doesn't helped.

Any Idea?

 

[Garth]

Did you refresh the membership? How Exactly did you create the collection? How exactly did you query it? What exactly does your query look like?

 

[derekhansell]

Check your limiting collection and any exclusions.

 

[janos98]

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 = "DomainYX\\Group_XY"

 

[janos98]

It's an old collection and suddenly stopped working. when I run the query from the collection options it gives the right result.

 

[janos98]

Sorry guys, the servers have more collections, and they were in the exclusion list. Thank you for your help. I'am a beginner with SCCM.

 

[Garth]

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 = "DomainYX\\Group_XY"

Keep in mind that this REQUIRES that the Heartbeat discovery is run on the computer BEFORE it will show up within this list.