09/18/2009 2816 views
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


Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

All Answers

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
Answered 09/18/2009 by: pachou
Senior Yellow Belt

Hmmm...been a member almost a year and somehow missed the fact that AD has an SMS-specific forum? :)
Answered 09/20/2009 by: VBScab
Red Belt