PENDING SCCM Collection Query works in preview but never populates the collection.

[BMontanye]

SCCM will occasionally leave a duplicate entry in the console for new devices and that causes issues with multiple instances of a device. I have a query that I have setup as the membership rules in a collection that will show me the duplicate devices. This works when I test the query when making the rule in the collection rules creation process. But, this never populates the collection. I have been using the preview to show me the duplicates, which I then manually track down and eliminate the copy. Has anyone run into this previously? This is the query in question: select R.ResourceID,R.ResourceType,R.Name,R.SMSUniqueIdentifier,R.ResourceDomainORWorkgroup,R.Client from SMS_R_System AS R FULL JOIN SMS_R_System AS S1 ON S1.ResourceId = R.ResourceId FULL JOIN SMS_R_System AS S2 ON S2.Name = S1.Name WHERE S1.Name = S2.Name AND S1.ResourceId != S2.ResourceId AND R.Client IS NULL