Find all Obsolete computerobject in SCCM 2007

When you have a big Microsoft SCCM 2007 environment, it’s very handy to have an overview of all the obsolete computerobject within the SCCM database. This query gives you this overview.

1.) Create a new Collection. (In my example it is All Obsolete Computerobjects)
2.) Create a new query. (In my example it is Query All Obsolete Computerobjects)
3.) Edit the query statement. Use the following 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

4.) Run the “Update Collection Membership”
5.) View the result

Comments

Popular posts from this blog

The install4j wizard could not find a Java Runtime Environment on your system. Please locate a suitable JRE...

Clients Unable to update - "Cached cookie has expired or new PID is available"

Java Control Panel Icon "Application Not Found"