Collection to Exclude Machines with Specific Software Installed (Full Version)

All Forums >> [Management Products] >> System Center Products >> System Center Configuration Manager

Message

---

house -> Collection to Exclude Machines with Specific Software Installed (9/29/2008 2:54:09 PM) 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.

---

gjones -> RE: Collection to Exclude Machines with Specific Software Installed (9/29/2008 3:38:25 PM) You need a subset query. This will help you out. http://smsug.ca/blogs/garth_jones/archive/2007/05/08/subset-query.aspx

---

rbennett806 -> RE: Collection to Exclude Machines with Specific Software Installed (9/29/2008 3:47:13 PM) 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...

---

house -> RE: Collection to Exclude Machines with Specific Software Installed (9/30/2008 9:51:43 AM) This was perfect! Thank you for the query example.

---

Page: [1]

Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI

0.890625