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   [ - ] Hide Comments


Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.
Answer this question or Comment on this question for clarity


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

Please log in to comment
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

Please log in to comment