Kace Agent - Check if current version is installed
Is there a way to create a report to check if machines have the current Kace agent installed without entering the current agent version?
I'm looking for a '$current_agent_variable' basically. I have a report that finds machines with 'Server' in the OS name, but want to also add a way to check if each server has the current Kace agent regardless of what the current agent is. I don't want to have to remember to update the report each time we update the Kace agent.
Sort of like below:
If OS name contains 'Server' and the Kace agent version is < $current_agent_variable
My mostly final code...until I add something, then add something, then ... [code] SELECT NAME, IP, CLIENT_VERSION FROM MACHINE WHERE (( OS_NAME like '%Server%') AND MACHINE.CLIENT_VERSION != (SELECT VERSION FROM CLIENT_DISTRIBUTION WHERE ID = 1)) GROUP BY MACHINE.ID [/code]