Duplicate Workstation Collection

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:

Duplicate Workstation Collection - Help

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

Logged in as: Guest

Printable Version

All Forums >> [Management Products] >> Microsoft Systems Management Server >> SMS 2003 >> Duplicate Workstation Collection - Help

Page: [1]

Message

<< Older Topic Newer Topic >>

Duplicate Workstation Collection - Help - 8/13/2008 6:25:34 AM

jsteeves

Posts: 5
Score: 0
Joined: 5/15/2006
Status: offline

I need to create an SMS collection for my SMS objects that have duplicate names. The problem is that I want to analyze these duplicate objects and only include the ones that are older. This is so that I can delete the old objects and keep the newest. The other problem is that some objects have 6, 7, 8, 15 entries so it needs to be dynamic in the number of objects that it looks at.

Post #: 1

RE: Duplicate Workstation Collection - Help - 8/15/2008 11:07:20 AM

okis14

Posts: 29
Score: 3
Joined: 12/28/2006
Status: offline

I wish the count function would work in wql. It would make life easier.

select SMS_R_system.name from sms_r_system
inner join sms_r_system as s1 on s1.resourceid <> sms_r_system.resourceid and s1.Name = sms_r_system.Name

You could then add on if the client is obsolete, active, hasn't reported hw inventory in x amount of days, etc.

(in reply to jsteeves)

Post #: 2

RE: Duplicate Workstation Collection - Help - 8/15/2008 1:22:06 PM

jnelson993

Posts: 899
Score: 127
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline

Yeah, you're not going to be able to pull that off (getting all but the latest one). The problem is you're not able to use MAX or COUNT or any of those other useful aggregate functions that would get you what you need. But what okis14 just gave you should give you the dupes anyway.

_____________________________

Number2 (John Nelson)
MyITForum - Blog
MyITForum - Forum Posts

(in reply to okis14)

Post #: 3