Link to home
Create AccountLog in
Avatar of infotech411
infotech411Flag for United States of America

asked on

SCCM - create collection based on multiple criteria

I am trying to create a dynamic SCCM collection based on clients having specific software packages installed.
The software packages below are just examples, Office is actually Office Professional Plus 2010, and I can create collections where the results come back correctly if I only based it on 1 product being installed, once I add the "and" to the query it fails to retrieve anything.

I need to create 4 collections, for example one that has office 2010x86 and Adobe Reader x86, then another collection that has machines which have office 2010x64 and Adobe Reader x64, then 1 that has Office 2010x86 but not Adobe Reader x86 and I need to query to verify adobe reader isn't installed, and the last is Office 2010x64 but not adobe Reader x64.
Avatar of Abdul Jalil Abou Alzahab
Abdul Jalil Abou Alzahab
Flag of Canada image

What version of SCCM you are using? System Center Configuration Manager 2007 or System Center 2012 Configuration Manager ? if it's 2007 which service pack you have?
Avatar of infotech411


I'm on 2007 and Service Pack 2, and I have the collections working, I started with creating a simple query to look for Office 2010 32bit, then created a sub-collection that looks to see if "Test App1" is installed, and then another one to query for "test app2" using the simple add/remove programs query.

Now the headache has been doing the query for "not installed for test app1 and then testapp2".  I found some subselect queries online, but no matter what I try I see an exclamation that I must "define a valid constant".  Is that normal?  It seems to be a popular error..and the queries seem to be working, but I rather know how to build them.  I don't see anything that shows that or how you "browse" to the query from your 1st collection that has the systems that have the software installed.

next I have to figure out how to filter these collections further by having them populated based on these queries, but also adding in a filter to look at only specific OUs, is that possible?
Avatar of jedial19

Link to home
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.