Solved

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

Posted on 2011-03-08
6
4,551 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
  • 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
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.

 
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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Suggested Solutions

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…
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 Migration Tip #1 – Source Server Health can be found listed in my profile here: http:…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

809 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