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.
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)
Please log in to answer
Posted by:
pachou
15 years ago
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
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
15 years ago
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.