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

Posted on 2011-03-08
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
  • 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:

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"
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.


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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

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…
Remote Apps is a feature in server 2008 which allows users to run applications off Remote Desktop Servers without having to log into them to run the applications.  The user can either have a desktop shortcut installed or go through the web portal to…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

937 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now