Hi All, We have created 2 query based collections to identify duplicate records / obsolete records. We are currently deleting all the resources from the said collections manually. We are having SCCM 2007 R3. Is there any way to automate this? Please suggest.Prashant Patil

yes, there is . You can delete the records from this collections automatically. refer http://myitforum.com/cs2/blogs/smslist/archive/2009/07/28/mssms-script-to-remove-computer-from-collection-gjdfs.aspx

And here is a way to automate it directly when it happends: http://ccmexec.com/?s=obsolete

Information given on link "http://myitforum.com/cs2/blogs/smslist/archive/2009/07/28/mssms-script-to-remove-computer-from-collection-gjdfs.aspx" is not useful as it is for direct membership collection, whereas we have dynamic collections (query based). Further Information given on link ( http://ccmexec.com/?s=obsolete ) is not useful for us as we have configured to automatically create new client records for duplicate hardware id's. also we have observed is the past that it does not work in some cases as by the time record is written in the database when event id:2642 is generatted script runs already & nothing found in the database. Is any other option available?Prashant Patil

There is a built-in task to delete obsolete clients. Why not use it? http://www.enhansoft.com/

Hi, We have configured built-in task to delete obsolete recrods, however as per Microsoft's recommendation we have configured it to more than heartbeat discovery value (15 days in our case). we are using SCCM for OSD, once we redepoly OS on existing systems it creates duplicate entry in SCCM console & mark previous entry as obsolete one. we faces problem during software distribution... systems are not getting advertisement due to duplicate records & we have to manually delete obsolete record of the system to fix the issue. To overcome this problem we have created 2 query based collections to identify duplicate records / obsolete records and currently we are deleting all the resources from the said collections manually. We need to automate this.Prashant Patil

I think Maik Koster's webservice can do what you need, you could invoke the webserive every time you execute a build or refresh? http://mdtcustomizations.codeplex.com/wikipage?title=Webservice%20-%20SCCM&referringTitle=DocumentationDon

we can't use webservice in our enviornment. is there any straight forward script that can delete resources from specified collection? Prashant Patil

we can't use webservice in our enviornment. is there any straight forward script that can delete resources from specified collection? Prashant Patil you should be able to produce this, all you need to do is get the results of the query for your collection then starting deleting those machines. here's code to do deletions: http://social.technet.microsoft.com/Forums/en-NZ/configmgrsdk/thread/548a3289-0136-4227-bebd-3444f7f94aa0 and here's some code to list the resource records for a specific collection: http://msdn.microsoft.com/en-us/library/cc146350

we can't use webservice in our enviornment. is there any straight forward script that can delete resources from specified collection? Prashant Patil you should be able to produce this, all you need to do is get the results of the query for your collection then starting deleting those machines. here's code to do deletions: http://social.technet.microsoft.com/Forums/en-NZ/configmgrsdk/thread/548a3289-0136-4227-bebd-3444f7f94aa0 and here's some code to list the resource records for a specific collection: http://msdn.microsoft.com/en-us/library/cc146350