Get all duplicate Workstations in SCCM (WQL)

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”


Leave a Reply

Your email address will not be published. Required fields are marked *

eight − four =

Post Navigation