Avatar of jeff_c_brown
jeff_c_brown

asked on 

Cleanup old systems from SMS 2003

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
Microsoft Server OS

Avatar of undefined
Last Comment
BlueDelta5
Avatar of BlueDelta5
BlueDelta5
Flag of United Kingdom of Great Britain and Northern Ireland image

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.

Avatar of jeff_c_brown
jeff_c_brown

ASKER

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
ASKER CERTIFIED SOLUTION
Avatar of BlueDelta5
BlueDelta5
Flag of United Kingdom of Great Britain and Northern Ireland image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Microsoft Server OS
Microsoft Server OS

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.

59K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo