Kevin, The ResourceIDs are assigned sequentially. If you were to delete the lowest numerical ResourceID you would be left with the valid client record.
Thanks, ________________________________ Mark Mears [email protected]<mailto:[email protected]%0d> Phone: (757) 945-2651 [cid:[email protected]]<http://www.cireson.com/> [cid:[email protected]]<http://twitter.com/teamcireson> Check out our System Center App Store: www.cireson.com/app-store ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Kevin Ray Sent: Tuesday, November 19, 2013 1:48 PM To: mssms Subject: [mssms] Duplicate computer names with different Resource ID - SQL Query Hi All I'm trying to create the SQL / WQL Query for duplication machines with different resource ID. 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 I got the collection query... But due to some constrains , we should not use the delete special.... So now I'm looking for SQL Query.. It should show up the duplicate machine's with Last Heart discovery date with resource id... Ultimately we need to remove the machine's withought using the delete special ..How we can do it... I'm thinking to check the Heartbeat of 2 duplicate machine's Which is the Old time stamp we need to remove it... If we get the duplicate machine name with Heartbeat Time stamp with resource ID.. We can remove it.. Any help, Any other suggestion to do this ?
<<inline: image005.png>>
<<inline: image006.jpg>>
