Collection to Exclude Machines with Specific Software Installed

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 to Exclude Machines with Specific Software Installed

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 >> Collection to Exclude Machines with Specific Software Installed

Page: [1]

Message

<< Older Topic Newer Topic >>

Collection to Exclude Machines with Specific Software I... - 9/29/2008 2:54:09 PM

house

Posts: 34
Score: 0
Joined: 11/6/2006
Status: offline

I am trying to create a collection in SCCM to exclude computers that have a specific software installed. I can get the collection to give me who has it installed but not who doesn't. I know it is something simple but I am just missing it. When I try and use NOT it gives me all the machines with software installed or not.

Any assistance would be greatly appreciated.

Post #: 1

RE: Collection to Exclude Machines with Specific Softwa... - 9/29/2008 3:38:25 PM

gjones

Posts: 824
Score: 50
Joined: 6/5/2001
From: Ottawa, Ontario, Canada
Status: offline

You need a subset query. This will help you out.
http://smsug.ca/blogs/garth_jones/archive/2007/05/08/subset-query.aspx

_____________________________

Garth@enhansoft.com

For a List of my Articles
http://www.myitforum.com/contrib/default.asp?cid=116
Blogs:
http://smsug.ca/blogs/garth_jones/default.aspx
http://myitforum.com/cs2/blogs/gjones/default.aspx

(in reply to house)

Post #: 2

RE: Collection to Exclude Machines with Specific Softwa... - 9/29/2008 3:47:13 PM

rbennett806

Posts: 825
Score: 13
Joined: 6/14/2006
Status: offline

Here's an example membership query using Mozilla Firefox...

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 = "Mozilla Firefox (2.0.0.16)" AND ARP.Version = "2.0.0.16 (en-US)") AND sys.Decommissioned = 0 AND sys.Client = 1 AND sys.Obsolete = 0

Make sure to limit it to another one of your collections...

(in reply to gjones)

Post #: 3

RE: Collection to Exclude Machines with Specific Softwa... - 9/30/2008 9:51:43 AM

house

Posts: 34
Score: 0
Joined: 11/6/2006
Status: offline

This was perfect! Thank you for the query example.

(in reply to house)

Post #: 4

Page: [1]

All Forums >> [Management Products] >> System Center Products >> System Center Configuration Manager >> Collection to Exclude Machines with Specific Software Installed

Page: [1]

Jump to:

New Messages	No New Messages
Hot Topic w/ New Messages	Hot Topic w/o New Messages
Locked w/ New Messages	Locked w/o New Messages

Post New Thread

Reply to Message

Post New Poll

Submit Vote

Delete My Own Post

Delete My Own Thread

Rate Posts

0.250