Some database view fields, like vCurrApplicationInfo return multiple values. Is there a way to filter out just one line of information from this?
In SQL meets Kaseya terms, i'd like to do something along these lines:
select ProductVersion, DirectoryPath from vCurrApplicationInfo where machName='#vAgentConfiguration.machName#' and ApplicationName='AcroRd32.exe';
...to get the installed version and path of this machine's Acrobat Reader. The particular use case here is that i could then further interrogate what language the Reader is so i can upgrade it to a newer one with the correct language (after some investigation, i found that #vCurrentApplicationInfo.DirectoryPath#\Locale contains a directory named as the installed Reader locale :))