Collection Question

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:

Collection Question

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 >> Collection Question

Page: [1]

Message

<< Older Topic Newer Topic >>

Collection Question - 11/20/2008 11:52:11 AM

jbolton_99

Posts: 11
Score: 0
Joined: 7/31/2007
Status: offline

How can I create a collection for all XP systems that don't have a sepcific program installed?

I'm looking to push the newest Adobe Reader update to my network but I don't want it on servers or systems that have Adobe Acrobat already installed. If anyone has any idea's or links that might help I would be very grateful!

Post #: 1

RE: Collection Question - 11/20/2008 12:26:47 PM

hcortez463

Posts: 793
Score: 65
Joined: 4/8/2005
Status: offline

subselect query

_____________________________

If it Helps, Please rate....

(in reply to jbolton_99)

Post #: 2

RE: Collection Question - 11/21/2008 2:35:48 PM 1 votes

rbennett806

Posts: 885
Score: 18
Joined: 6/14/2006
Status: offline

How about....

select SYS.ResourceID,SYS.ResourceType,SYS.Name,SYS.SMSUniqueIdentifier,SYS.ResourceDomainORWorkgroup,SYS.Client from SMS_R_System as SYS WHERE SYS.ResourceID NOT IN (SELECT ARP.ResourceID FROM SMS_G_System_ADD_REMOVE_PROGRAMS as ARP WHERE ARP.DisplayName = "Adobe Reader 8.1.3" AND ARP.Version = "8.1.3")

Edit it for the desired version and tweak it as desired of course...

(in reply to hcortez463)

Post #: 3

RE: Collection Question - 11/24/2008 11:53:49 AM

jbolton_99

Posts: 11
Score: 0
Joined: 7/31/2007
Status: offline

Thanks a lot for your posts, this was just what I was looking for!

(in reply to rbennett806)

Post #: 4