Query version of Automation Engine from command line

[Michael A. Lowry]

I would like a simple way to query the version of an Automation Engine from the command line, using one of the Utility programs such as ucybdbun. I do not wish to unload any data or make any changes. I just want to find out the version of the AE server. Thanks in advance.

[Anon Anon]

Would the SYS_INFO script function address your needs?

[Michael A. Lowry]

Mark Hadler said:

Would the SYS_INFO script function address you needs?

No, because it cannot be run from the OS command line.

[Anon Anon]

Well if that's an absolute requirement could you not use the CallAPI to execute the script function?  It seems a rather kludgy solution, but I'm guessing it would meet the requirement as stated thus far. 

I've never used the CallAPI due to its potential security issues in our V8 environment.

[Pete Wirfs]

I've noticed that the CP log files display the version for "ucsrvcp.exe", which I believe could meet your needs?  This DOS FIND command returns that version line from my log file;

find /n /i "ucsrvcp.exe" \\uc4prod\c$\uc4\AutomationEngine\Temp\CPsrv_log_001_00.txt

[Michael A. Lowry]

Pete Wirfs said:

I've noticed that the CP log files display the version for "ucsrvcp.exe", which I believe could meet your needs?  This DOS FIND command returns that version line from my log file;

find /n /i "ucsrvcp.exe" \\uc4prod\c$\uc4\AutomationEngine\Temp\CPsrv_log_001_00.txt

That would work only on the same machine that runs the Automation Engine. I’m looking for a command I can run on a machine that has only the Utilities installed (as well as INI files of course).

[Anon Anon]

Though I haven't searched, perhaps this is a column in an AE table and could be accessed via a query.  Maybe someone from Automic will chime in.

[Simone Martineschen]

I would really like to know the table that stores the AE and agents versions. It would be really helpful to plan system upgrades. Could not find it on the db index document. If anyone knows it, please share!

[Luu_Le_185]

Hi Michael,

To my knowledge there isn't a utility out there that can do that.  But if on those box you have access to the database, you can query the version of it.  The version information is located in the HOST table.

For example you can do something like this:

select HOST_OH_Idnr, HOST_Version, OH_Name from HOST
inner join OH on OH_Idnr = HOST_OH_Idnr where HOST_HostAttrType in ('C','W')

Which will give you the Version of the CP/WP & its name.

@Simone, for the Agent information you would also be to find it using something like the example.  Just replace the 'C', 'W' with your Agent  HOST_HostAttrType you are looking for (windows, unix etc...)

[Michael A. Lowry]

Luu Le said:

Hi Michael,

To my knowledge there isn't a utility out there that can do that.  But if on those box you have access to the database, you can query the version of it.  The version information is located in the HOST table.

For example you can do something like this:

select HOST_OH_Idnr, HOST_Version, OH_Name from HOST
inner join OH on OH_Idnr = HOST_OH_Idnr where HOST_HostAttrType in ('C','W')

Which will give you the Version of the CP/WP & its name.

That looks like a straightforward solution. Thanks!

Update:
I modified the query a bit, so that it returns just the major version of WP1.

select substr(HOST_Version, 1, instr(HOST_Version,'.', 1,1) -1)
from HOST, OH
where OH_Idnr = HOST_OH_Idnr
and OH_Name like '%WP001'

The substr and instr functions simply truncate the version starting from the first dot character. E.g., 9.00A514-8C1 becomes just 9, and 11.1.1+build.527 becomes just 11. For my purposes, the major version alone is sufficient.

[Simone Martineschen]

>@</p>Luu Le", maybe this is a little bit off topic but by any chance, is it possible to retrieve also the initial data version from the database? 

[Anon Anon]

SimoneMartineschen607563 Great question, it could be it's own post, but we can leave it under this topic. Here's the SQL Query:

select VERSI_DBVersion from UC_VERSI
where versi_dateimpl =(select MAX(VERSI_DateImpl) from UC_VERSI)

[Simone Martineschen]

Great! Thank you Jennifer_Jinhong_34 !!