Delete Duplicate Entry

myITforum.com Community Forum

Home Forums Blogs Live Support chat Search Articles Wiki FAQ Email Lists Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

All Forums RSS Feed Subscription:

Delete Duplicate Entry

View related threads: (in this forum | in all forums)

Logged in as: Guest

Printable Version

All Forums >> [Management Products] >> System Center Products >> System Center Configuration Manager >> Delete Duplicate Entry

Page: [1]

Message

<< Older Topic Newer Topic >>

Delete Duplicate Entry - 4/25/2008 4:10:12 AM

ridvan

Posts: 35
Score: 0
Joined: 3/13/2008
Status: offline

Hi there,

Lately the number of machines, in "All System" Collection is growing every day...

And i figured out that here are to many duplicate names. or worst... 3 same hostnames in one collection... Actually i think this is happening for these reasons: if a hostname change it IP...

...OK but what i want is how to do some quickly and easily erase of all duplicate entrys in all collections??!!

Regards,
Ridvan

Post #: 1

RE: Delete Duplicate Entry - 4/25/2008 5:08:33 AM

iburnell

Posts: 239
Score: 1
Joined: 5/14/2003
From: London, UK
Status: offline

Most likely its because your support people are reimaging PCs using the same name as previous - ideally they should be using a new name or you get these duplicates. They should be listed under the Obsolete column as "Yes". Simply sort and then do a delete special on the selected items

If this happens all the time create a collection of obsolete computers - sorry haven't got console in front of me at the moment so can't give you the syntax but it will something like system.obsolete = 1. Then just right-click the collection and do a delete special from time to time

Don't forget there's a task to delete the obsolete records by default every 7 days that you should enable

_____________________________

Ian Burnell
London UK

(in reply to ridvan)

Post #: 2

RE: Delete Duplicate Entry - 4/25/2008 5:35:18 AM

ridvan

Posts: 35
Score: 0
Joined: 3/13/2008
Status: offline

Iburnell Thank you very much,

It works fine and the exact query is this:
select NetbiosName, LastLogonUserName from SMS_R_System where Obsolete = 1 order by NetbiosName

Once again thank you.

Regards,
Ridvan

(in reply to iburnell)

Post #: 3