Hey Jared,
I do not have a database query for this. I can think of another way to accomplish this.
Leverage the Agent variables to determine the location of the installation:
:SET &jobreport# = GET_VAR('UC_EX_PATH_JOBREPORT','AGENTNAME')
:SET &agentbin# = GET_VAR('UC_EX_PATH_BIN','AGENTNAME')
So you could drive this script with a hostgroup of all the agents in question and at least get the Agent Install locations. With that you could do the prep_process granted that the servicemanger is always installed the same relative to the Agent files.
Additionally, you could also use each agent to run './ucybsmgr -v' granted the servicemanager path is always relative to the Agent installation.
Original Message:
Sent: 07-22-2019 02:59 PM
From: Jared Kessans
Subject: ServiceManager version
Does anyone know of a way (database query?) to check the version of the ServiceManager that is installed on the agent servers without having to log onto each server?
I ran into an issue when using the CAU that the agent was transferred to the server and upgraded, but didn't come back up and sat in a 'Waiting on upgrade' status after being shutdown. When starting them through the Administration tab they did get upgraded. I found that somehow some servers didn't get the v12 ServiceManager and are still on v10. I would like to find those servers that need to be remediated before attempting to push agent upgrades in production.
It appears the ServiceManager CLI doesn't have a response for the version, and running a prep_process_file against the 00 temp file for the versions isn't necessarily going to work due to the possible path differences or access to those servers.
Any ideas?