Query Based On Adobe Reader Version

I'd like to create a query based on a product version that is less than what the most recent version. example: Query all Adobe Reader that is less than 9.1.3

I'm guessing that I need to query the product name and query the file version but I can seem to get the query correct. Any ideas? Thanks in advance.

0 Comments   [ + ] Show comments

Answers (2)

Posted by: pachou 13 years ago
Senior Yellow Belt
Figured it out I believe..

select SMS_R_System.Name, SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName 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 Reader%" and SMS_G_System_ADD_REMOVE_PROGRAMS.Version < "9.1.3" order by SMS_R_System.Name
Posted by: anonymous_9363 13 years ago
Red Belt
Hmmm...been a member almost a year and somehow missed the fact that AD has an SMS-specific forum? :)
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ