Script to delete duplicate computers from sccm daily basis

There is no support method to delete devices out the CM DB. At best you can delete them from CM and wait for CM to delete them from the db, which happens ever few days. Look at powershell to delete them from CM.

What do you mean by "duplicate devices"? This is where you should be focusing as this is not normal.

Hi, @suport.teche
Thank you for posting in Microsoft Q&A forum.

You may create a collection with below query used to find the computer names appear twice or more with different resource ID,GUID etc

select sys.ResourceID,sys.ResourceType,sys.Name,sys.SMSUniqueIdentifier,  
sys.ResourceDomainORWorkgroup,sys.Client from SMS_R_System as sys  
full join SMS_R_System as sys1 on sys1.ResourceId = sys.ResourceId  
full join SMS_R_System as sys2 on sys2.Name = sys1.Name  
where sys1.Name = sys2.Name and sys1.ResourceId != sys2.ResourceId  

You can delete all these records manually or create a powershell script with schedule to empty the collection. This way , you loose the inventory of active computers but they send back in the next inventory cycle.

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

@ Jason : - Devices with same name , have separate collection , i need script to delete machine from the collection every day..

@ AllenLiu : - I have the query , i am looking for script to schedule the task everyday.

any help !!

Best Regards,
suport.teche