PENDING Device collection based off OU not syncing

[SJC_Adam]

Hello,

Hoping someone can help me with this issue.

We have device collections setup using queries statements as per below.

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/STUDENT COMPUTERS/YEAR 7"

Encountering a problem where the device collection count is over the OU client count.

I have removed the query and also the device collection and readded but end up with the same number of devices in the collection.

Can someone point me in the right direction on what i could try next to clean up this syncing issue?

Adam

 

[Garth]

First, ou data comes from heartbeat discovery. How often are you doing it? Next are their sub ou?

 

[SJC_Adam]

Thanks Garth for taking the time to reply very much appreciated.

Heartbeat discovery is enabled to send every hour. (1)

Currently have the OU set in sub categories as per student year levels.
EG: Student Computers>(Each Year Level 7-12)

It looks like stale or inactive devices are not being automatically removed in the collections.
Edit: Delete aged discovery data was set to 90 days, I have just adjusted to 60 days.

Regards
Adam

 

[Garth]

So you are good then????

 

[SJC_Adam]

No sorry still showing all the same numbers in collections

 

[Garth]

No sorry still showing all the same numbers in collections

so exactly what are the difference in the numbers? expired devices? Stale devices? other???

 

[SJC_Adam]

Hello Garth,
I have come in this morning and check the device collections and they are all now syncing correctly.

I did make some changes yesterday by manually starting a heartbeat for our devices.
Also disabled and enabled delete aged discovery data from 90 to 60 days.

This seems to have done the trick.

I really do appreciate you taking the time in pointing me in some directions to help me out.

Thank you.
Adam