<div>
By old, do you mean obsolete? &nbsp;If so<br />
<br />
I created a collection based on following query to check for obsolete clients<br />
<br />
select SMS_R_System.ResourceID,SM<wbr />S_R_System<wbr />.ResourceT<wbr />ype,SMS_R_<wbr />System.Nam<wbr />e,SMS_R_Sy<wbr />stem.SMSUn<wbr />iqueIdenti<wbr />fier,SMS_R<wbr />_System.Re<wbr />sourceDoma<wbr />inORWorkgr<wbr />oup,SMS_R_<wbr />System.Cli<wbr />ent from SMS_R_System where obsolete = 1<br />
<br />
I can then delete special on the clients in this container.<br />
<br />

</div>


By old, do you mean obsolete?  If so

I created a collection based on following query to check for obsolete clients

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

I can then delete special on the clients in this container.



<div>
So removing old unused systems from SMS has to be done by SQL query? &nbsp;After you run the SQL query what do you do? &nbsp;I've increased the points.<br />
<br />
Jeff
</div>


So removing old unused systems from SMS has to be done by SQL query?  After you run the SQL query what do you do?  I've increased the points.

Jeff

<div>
<div class="content wysiwyg-content">
We are using SMS 2003 and about 50% of the inventoried systems are gone. &nbsp;In the SMS console, I can delete an old system but I cannot select multiple systems to delete. &nbsp;Is there anyway to delete multiple systems at a time? &nbsp;It will take forever to do one at a time.<br />
<br />
Thank you,<br />
<br />
Jeff
</div>
</div>


We are using SMS 2003 and about 50% of the inventoried systems are gone.  In the SMS console, I can delete an old system but I cannot select multiple systems to delete.  Is there anyway to delete multiple systems at a time?  It will take forever to do one at a time.

Thank you,

Jeff

Cleanup old systems from SMS 2003

The Microsoft Server topic includes all of the legacy versions of the operating system, including the Windows NT 3.1, NT 3.5, NT 4.0 and Windows 2000 and Windows Home Server versions.