KACE K1000 Smart Label - Smart Label for Latest (or Max) Software Version
10/15/2018 317 views
I am trying to find a way to create a Smart Label for use with my KACE K1000 that would automatically apply to the latest (or Max) version of software when it is detected. That way I can create another Smart Label for any computer with the software installed, but that is missing the latest version.
I am admittedly not a SQL person, and that looks like it is going to be the only way to create something like this. I know that SQL has the MAX() variable, but I do not see anything similar in the Smart Label Wizard options.
As an example, let's say that I want to find all versions of Adobe Reader detected by my K1000. The SQL statement should looks something like this:
SELECT DISPLAY_NAME, PUBLISHER, SOFTWARE.ID as TOPIC_ID FROM SOFTWARE WHERE ((DISPLAY_NAME like '%Adobe%') AND (DISPLAY_NAME like '%Reader%'))
The question is, how do I then filter the results further, only showing the latest version number or the max value that is shown for DISPLAY_VERSION?