SCCM query to check for obsolete clients

This query will help you check obsolete clients in SCCM:



********************************************

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 obsolete = 1

*****************************************