Solved

delete old pc accounts from sms database

Posted on 2007-11-26
12
682 Views
Last Modified: 2013-11-21
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
Comment
Question by:soki
  • 5
  • 4
  • 3
12 Comments
 
LVL 31

Expert Comment

by:merowinger
Comment Utility
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
 

Author Comment

by:soki
Comment Utility
thats impossible. i want to chjeck all AD computer accounts and wants sms to delete them too
0
 
LVL 31

Expert Comment

by:merowinger
Comment Utility
just sort the "All Systems" Collection to obsolete and delete them which are listed as obsolete
0
 
LVL 5

Expert Comment

by:balmasri
Comment Utility
you may schedule Tasks in the site maintenance
follow this path
Open SMS console>Site database>Site Hierarchy > SMS Site > Site Maintenance> TASKS
0
 

Author Comment

by:soki
Comment Utility
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
 
LVL 31

Expert Comment

by:merowinger
Comment Utility
u can configure a site maintenance task that you can configure to delete obsolete clients.
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

Author Comment

by:soki
Comment Utility
any chance for a screen copy?. useing a german version and haven't found it yet
0
 
LVL 31

Expert Comment

by:merowinger
Comment Utility
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
 
LVL 5

Expert Comment

by:balmasri
Comment Utility
I uploaded a snapshot click the following link
http://allyoucanupload.webshots.com/v/2001195671983008958
0
 
LVL 31

Expert Comment

by:merowinger
Comment Utility
i think u need at least sms sp1 for this taks
0
 
LVL 5

Accepted Solution

by:
balmasri earned 250 total points
Comment Utility
any news ?
0
 

Author Comment

by:soki
Comment Utility
the task was sheduled for this wekkend. gonna check it now
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Suggested Solutions

The question has been asked on multiple occasions as to how best to do printing in a remote desktop or terminal services environment.   It seems that this particular question has plagued several people and most especially as Terminal Services, as…
I've always wanted to allow a user to have a printer no matter where they login. The steps below will show you how to achieve just that. In this Article I'll show how to deploy printers automatically with group policy and then using security fil…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now