Thursday, April 3, 2014

create collection for Duplicate Computer Names

create collection for Duplicate Computer Names :

WQL Query :

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


No comments:

Post a Comment