SCCM Device Collections don't add up?

[Blue_Cookeh]

Hi Guys,

 

I've got 3 collections (well... more, but this is a great example) that should all add up to the same number of devices but put simply... don't.

 

Any ideas why this might be? I've included collections and queries below... x86 shows 29 computers, x64 shows 18, and All Workstations shows 57 (ignoring the fact not all our workstations are listed) 29 and 18 don't equal 57 in my books!

 

The limiting collections on all are 'All Systems'.

 

x86 School Workstations:

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 INNER JOIN SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_R_System.SystemOUName = "ad.SCHOOL.co.uk/SCHOOL/Devices" and SMS_G_System_SYSTEM.SystemType = "X86-based PC"

 

x64 School Workstations:

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 INNER JOIN SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_R_System.SystemOUName = "ad.SCHOOL.co.uk/SCHOOL/Devices" and SMS_G_System_SYSTEM.SystemType = "X64-based PC"

 

All School Workstations:

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 INNER JOIN SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_R_System.SystemOUName = "ad.SCHOOL.co.uk/SCHOOL/Devices"