Solved

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

Posted on 2011-03-08
6
4,761 Views
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?
0
Comment
Question by:A1opus
[X]
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
6 Comments
 
LVL 3

Expert Comment

by:socrates2012
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%"
0
 
LVL 4

Expert Comment

by:jhindson
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
0
 
LVL 2

Accepted Solution

by:
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"
0
Free NetCrunch network monitor licenses!

Only on Experts-Exchange: Sign-up for a free-trial and we'll send you your permanent license!

Here is what you get: 30 Nodes | Unlimited Sensors | No Time Restrictions | Absolutely FREE!

Act now. This offer ends July 14, 2017.

 
LVL 4

Expert Comment

by:jhindson
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.
0
 
LVL 2

Author Comment

by:A1opus
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.
0
 
LVL 2

Author Closing Comment

by:A1opus
ID: 35499790
My own solution did
Work...
0

Featured Post

Free NetCrunch network monitor licenses!

Only on Experts-Exchange: Sign-up for a free-trial and we'll send you your permanent license!

Here is what you get: 30 Nodes | Unlimited Sensors | No Time Restrictions | Absolutely FREE!

Act now. This offer ends July 14, 2017.

Question has a verified solution.

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

This is my 3rd article on SCCM in recent weeks, the 1st (http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/Windows_Server_2008/A_4466-A-beginners-guide-to-installing-SCCM2007-on-Windows-2008-R2-Server.html) dealing with installat…
Some time ago I faced the need to use a uniform folder structure that spanned across numerous sites of an enterprise to be used as a common repository for the Software packages of the Configuration Manager 2007 infrastructure. Because the procedu…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
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 …

717 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