How to check and delete obsolete objects from SCCM?

Pull the SCCM Servers list from SCCM Central Database or refer the SCCM Design documents to get the Site servers list.

Select Device Collections -> Right Click -> Folder -> Create Folder -> Click.

sccm 2012 delete computer from database
sccm 2012 delete computer from database

 

Create a new folder name as SCCM Client Health Collections.

delete obsolete objects from SCCM
delete obsolete objects from SCCM

 

Create a new Collection under SCCM Client Health Collections Folder.

remove obsolete objects sccm
remove obsolete objects sccm

 

Create a new Collection name as All Obsolete Clients and limiting that collection to All Systems then click Next.

** Recommended to limit All Systems Collection **

delete obsolete client discovery data sccm 2012
delete obsolete client discovery data sccm 2012

 

Click Add Rule then Select Query Rule.

sccm 2012 obsolete clients
sccm 2012 obsolete clients

 

Type Query Rule Name as All Obsolete Clients then Click Edit Query Statements.

delete obsolete client discovery data sccm 2012
delete obsolete client discovery data sccm 2012

 

Place the below WQL Query inside the textbox and click OK. Ensure there is no Human error while placing the WQL Query.
WQL Query:
SELECT SMS_R_SYSTEM.ResourceID, SMS_R_SYSTEM.ResourceType, SMS_R_SYSTEM.Name, SMS_R_SYSTEM.SMSUniqueIdentifier, SMS_R_SYSTEM.ResourceDomainORWorkgroup, SMS_R_SYSTEM.Client FROM SMS_R_System WHERE SMS_R_System.Obsolete = 1

sccm 2012 obsolete clients
sccm 2012 obsolete clients

 

Ensure that All Obsolete Query Rule is added and change the Schedule full update on these collection settings as “Occurs every 1 day…” then click Next.

delete computer from sccm 2012
delete computer from sccm 2012

 

Click Next.

 How to remove or schdeule to remove Old Computers in SCCM?

How to remove or schdeule to remove Old Computers in SCCM?

 

Click Next.

delete computer from sccm powershell
delete computer from sccm powershell

 

Select the All Obsolete Clients Collection -> Right Click -> Select -> Show Members.

delete computer from sccm 2012
delete computer from sccm 2012

 

Select all Obsolete Clients -> Right Click -> Select -> Delete.

** Before deleting Obsolete clients, Ensure all objects are showing as Obsolete status is Yes **

delete computer from sccm 2012
delete computer from sccm 2012

delete computer from sccm 2012

Hope this will be helpful.


You May Also like the Following SharePoint Online Tutorials:

About Ramu Rao

I have been working as a Team Lead in IT last 6 years with a strong focus on Microsoft Server Technologies I have been working on Windows Server 2008, 2008 R2, 2012 & SCCM 2012 R2 etc. Interested in everything related to Configuration Manager & Windows Azure. Keep learning Keep sharing and keep growing !!

View all posts by Ramu Rao →