SCCM: How to create query to get all systems that have Acrobat Pro with specific version?

Posted on 2011-03-08
Medium Priority
Last Modified: 2013-11-21
With reference to SCCM, I need to create a query to get all the machines that have Acrobat Pro 9.4.2. Please mention the script and query design as well for my future reference.

Can anyone help me in this regard?
Question by:A1opus
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2

Expert Comment

ID: 35069793
For a WQL query, try this:

select distinct SMS_R_System.Name, SMS_G_System_SoftwareFile.FileVersion from  SMS_R_System inner join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareFile.FileName = "Acrobat.exe" AND
SMS_G_System_SoftwareFile.FileVersion LIKE "9.4.2%"

Expert Comment

ID: 35099037
You may also try this:

select * from SMS_R_System where SMS_R_System.ResourceID not in (select SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID from SMS_G_System_ADD_REMOVE_PROGRAMS where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "Adobe Reader 10.0.1" and SMS_G_System_ADD_REMOVE_PROGRAMS.Version = "10.0.1")
Limit to collection: (your collection of healthy clients)
Notes: I would strongly recommend staying away from the ">", "<", "+" operators when dealing with version numbers. While there's a lengthy answer as to why, the quick answer is that things like 9.0.123 is not a real number (multiple decimal points).

From here:  http://myitforum.com/cs2/blogs/rbennett806/pages/collection-queries.aspx

Accepted Solution

A1opus earned 0 total points
ID: 35100723
I tried y'all queries but couldn't get the correct result. So therefore I tried myself and ran the following query:

select distinct SMS_R_System.Name, SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName, SMS_G_System_ADD_REMOVE_PROGRAMS.Version from  SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "Adobe Acrobat 9 Pro - English, Fran?is, Deutsch" or SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "Adobe Acrobat 9 Pro - English, Francais, Deutsch" or SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "Adobe Acrobat 9 Pro - English, Français, Deutsch" and SMS_G_System_ADD_REMOVE_PROGRAMS.Version = "9.4.2"
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks


Expert Comment

ID: 35102784
So did your query provide the correct results for you? I seem to remember being told the only reliable way to query software of a particular version is to use ADD_REMOVE_PROGRAMS, and it looks like that is what you ended up using. I would like to know if your query worked as expected.

Author Comment

ID: 35106401
Yup, it gave me the perfect results and then by using same query I have made a dynamic collection as well. It is running awesome.

Author Closing Comment

ID: 35499790
My own solution did

Featured Post

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Welcome to my series of short tips on migrations. Whilst based on Microsoft migrations the same principles can be applied to any type of migration. My first tip is around source server preparation. No migration is an easy migration, there is a…
Back in July, I blogged about how Microsoft's new server pricing model, combined with the end of the Small Business Server package, would result in significant cost increases for many small businesses (see SBS End of Life: Microsoft Punishes Small B…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question