Hello Friends, We have carried out the stale computer removal activitity from AD. and after that we got the hostname report which we have to remove from our SCCM Database, so we cann't do this activity as manually because have around 900 entries. so have any option to remove those stale hostnames from SCCM database. any help would be appriciatable. Regards.Chandan.

You can create collections based on last heartbeat and delete all older than a certain date. You can also implment Client Status from R2/R3 and combine that with the Site Maintenance tasks (Delete Inactive and Delete Obsolete records).Kent Agerlund | My blogs: blog.coretech.dk/kea and SCUG.dk/ | Twitter: @Agerlund | Linkedin: Kent Agerlund

And here is the query to create a collection based on heartbeat inventory http://eskonr.com/2011/11/sccm-collection-based-on-heartbeat-agent/Anoop C Nair - @anoopmannur MY BLOG: http://anoopmannur.wordpress.com User Group: ConfigMgr Professionals This posting is provided AS-IS with no warranties/guarantees and confers no rights.

You can create collections based on last heartbeat and delete all older than a certain date. You can also implment Client Status from R2/R3 and combine that with the Site Maintenance tasks (Delete Inactive and Delete Obsolete records).Kent Agerlund | My blogs: blog.coretech.dk/kea and SCUG.dk/ | Twitter: @Agerlund | Linkedin: Kent Agerlund