Manual Query finds matches for collection, but automatic collect displays 0 members

[Brian S]

The following query for duplicate serial number information identifies 77 matches when run manually. by manual i mean I select the membership query of which it is the only rule, and go into the query editor and hit the green arrow to test for query results.

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_PC_BIOS as b on b.ResourceID = SMS_R_System.ResourceId full join SMS_G_System_PC_BIOS as s1 on s1.ResourceID = b.ResourceID full join SMS_G_System_PC_BIOS as s2 on s2.SerialNumber = s1.SerialNumber where s1.SerialNumber = s2.SerialNumber and s1.ResourceID != s2.ResourceID

When this same query is done automatically by choosing update members for the collection, I get no results. Any ideas? version 2211

[Garth]

When this same query is done automatically by choosing update members for the collection, I get no results. Any ideas? version 2211

What exactly do you mean by this?

[Brian S]

我将更详细地解释。When I look at the Dashboard for the collections, the member count of this particular collection is showing 0 members. If I right click on the collection and select update membership it remains at 0 after doing a re-evaluation. If I open the properties for the collection. select edit on the membership query. Open the edit query statement and run that query I get returned results matching the criteria that should be listed in the collection. Currently I get 49 returned results. Hopefully that clarifies. I'm baffled why I don't see the 49 in the collection results particularly after selecting update membership.

[Brian S]

The issue seems like it could be a bug. I have 68 members of the group today. perhaps its due to pruning of devices, because some of the devices listing as having duplicates don't have a corresponding host with a duplicate serial number.

If the hosts have duplicate serial numbers and you sort by serial number on the column there should be N+1 for each serial number , but on occasion there will appear a serial number that is not duplicated. I can only guess that perhaps the duped serial number host has been pruned, or deleted. I did delete those that were aged 30 days.