Purpose: Query for all duplicate Workstations in SCCM 2012
The first principle in SCCM is that… There is no first principle. The second principle is that DO NOT have duplicates in your system. Duplicate Workstations will cause a lot of troubles including disoriented support personnel, customers who thought to receive something but are still waiting for it and similar problems. Create a collection to monitor duplicate workstation names and act accordingly (or create an automation for it).
|Gather all Duplicate Computers in SCCM|
|Limiting collection: All Systems|
|Resource Class: System Resource|
|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 s1.Name <> “Unknown”|