Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 692
  • Last Modified:

delete old pc accounts from sms database

hello. just a simple question. changed about 60 pcs this year. then i looked in sms server. found also all pcs i removed from my AD. how can i remove all old entries from sms database ?
0
soki
Asked:
soki
  • 5
  • 4
  • 3
1 Solution
 
merowingerCommented:
if u have a active directory discovery u first should delete the old computer objects there, else they will be recreated on next sync!

In the SMS Console go to the collection "All Systems" there u can delete the computer objects
0
 
sokiAuthor Commented:
thats impossible. i want to chjeck all AD computer accounts and wants sms to delete them too
0
 
merowingerCommented:
just sort the "All Systems" Collection to obsolete and delete them which are listed as obsolete
0
Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

 
balmasriCommented:
you may schedule Tasks in the site maintenance
follow this path
Open SMS console>Site database>Site Hierarchy > SMS Site > Site Maintenance> TASKS
0
 
sokiAuthor Commented:
the goal is to have only these pc accounts in sms database as i have in AD. should work automaticall or scripted. means in AD i have 300 pc accounts and in sms database i have 385
0
 
merowingerCommented:
u can configure a site maintenance task that you can configure to delete obsolete clients.
0
 
sokiAuthor Commented:
any chance for a screen copy?. useing a german version and haven't found it yet
0
 
merowingerCommented:
there's no exact maintenance task to do this...
try this:
http://www.myitforum.com/forums/m_147700/mpage_1/key_SMS%252CIssues/tm.htm#147700
0
 
balmasriCommented:
I uploaded a snapshot click the following link
http://allyoucanupload.webshots.com/v/2001195671983008958
0
 
merowingerCommented:
i think u need at least sms sp1 for this taks
0
 
balmasriCommented:
any news ?
0
 
sokiAuthor Commented:
the task was sheduled for this wekkend. gonna check it now
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 5
  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now