I have no suggestions, because delete special is exactly what one would use for this situation.
What are the blockers? If it's just that a human shouldn't have to open the console and do the right-click delete special, that action can be automated via a script. It is not supported to delete machine records any other way (other than the "delete aged" tasks, or delete special action) Kevin Ray <[email protected]> wrote: >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 ?
