000028137 - How to determine Aveksa ACM aka RSA IMG aka RSA Via L&G product version information

There are many places where the current application version can be found.
From the Application: 
Prior to V6.9, when the Aveksa logo (or the rebranded logo)  is 'clicked' on, from any ACM UI screen (except for the initial login page), Aveksa version information is displayed. This version information is retreived from the Oracle database. This information is also written to various log files and in a webserver properties file for cross checking (to ensure that the installed product is the same version as the installed database)
Starting with IMG 6.9, the application version is now displayed on the bottom line of the UI screen.

Outside of the Application:
there are several places where the RSA IMG  ( Aveksa ACM )  version can be found. These include:
 

1) Internally in the Oracle database, in the T_SYSTEM_SETTINGS table

2) Text information found in /home/oracle/database/aveksa-properties.file, on an appliance or soft-appliance installation
3) In a webserver version properties file.

4) In the Aveksa ASR

5a) In more recent versions (6.x) this can be found in the file aveksaServerInfo.log, which can be found at: 
/home/oracle/jboss/server/default/deploy/aveksa.ear/aveksa.war/log/aveksaServerInfo.log
5b) In Version 7.0, for a standalone Wildfly installation, this can be found in the file aveksaServerInfo.log, which can be found at:
/home/oracle/wildfly/standalone/log/aveksaServerInfo.log
5c) In Version 7.0, for a clustered Wildfly installation, this can be found in the file aveksaServerInfo.log, which can be found at:/home/oracle/wildfly/domain/servers/<server-name>/log/aveksaServerInfo.log, where <server-name> is the application server name on that node in the cluster.
6) In more recent versions, patch information  is stored in the file, patch-version.properties, which can be found at:
/home/oracle/jboss/server/default/deploy/aveksa.ear/aveksa.war/WEB-INF/classes/patch-version.properties

There are two components of this information, one is the Product Version and one is the Build. If a HotFix is installed, that HotFix version will be noted, although not in all log files.

If for some reason the UI is not accessible, it may still be necessary to determine or confirm the installed version. Sometimes it's necessary to confirm that the installed version (ie the information stored in the webserver properties file) matches the database settings. (If these do not match, it could indicate that a database migration is necessary: refer to KB-1242 https://na3.salesforce.com/50150000000Rkhl)

Database:

To see the version information directly from the database, run the following sqlplus query, as avuser:
(note, that this query applies to versions prior to 6.8.1, as RSA no longer releases 'hotfixes'. instead Service Packs (Patches) are referenced., 

$ sqlplus avuser/<password>

sql> col parameter format a20
sql> col value format a20
sql> select parameter, value from t_system_settings where parameter in ('productVersion', 'Build', 'HotFixes') order by parameter desc;
sql> exit

Note that if no HotFix value is returned, then no HotFixes have been installed yet.

Webserver:

ACM Product Version and Build information is stored in various locations, depending on the ACM version and Server type. Note that this file does NOT include any hotfix information.

For 3.x, Tomcat Server, the Product and Build information:

/usr/bin/tomcat/webapps/aveksa/WEB-INF/classes/version.properties

For 4.0, 4.0.1, Jboss Server, the Product and Build information is stored in two places:

/home/oracle/jboss/server/default/deploy/aveksa.ear/aveksa.war/WEB-INF/classes/version.properties

/home/oracle/database/version.properties

For 4.1+, V5.x+ and V6.x+ Jboss Server, the Product and Build information is stored in two places:

/home/oracle/jboss/server/default/deploy/aveksa.ear/aveksa.war/WEB-INF/classes/aveksa-version.properties

/home/oracle/database/aveksa-version.properties

For V6.8.1+, V6.9.x+, There is a file, patch-version.properties file, which contains the current Service Pack version, It can be found at:
/home/oracle/jboss/server/default/deploy/aveksa.ear/aveksa.war/WEB-INF/classes/patch-version.properties
For WebSphere and WebLogic V4.2+ the Product and Build information is stored in:

<your site specific installation directories../../..>/aveksa.ear/aveksa.war/WEB-INF/classes/aveksa-version.properties

For V5.x+, and V6.x+, the Product and Build information is stored in in the same locations as noted for 4.2+.

For the older Aveksa Hotfix information, hotfix on any platform, the first line of aveksa.ear/aveksa.war/WEB-INF/database/run-once-avuser.sql will indicate the HF_ID value. E.g.: HF_ID=HF02.

Current Version/Build values for  RSA Via L&G GA releases are:
Version Build 

7.0     93958
 

Version Build      Version Build
6.8   (Not GA)  6.9     74968
6.8.1   66089   6.9.1   83768
 

Version Build    Version Build    

6.0     46406    6.5     55950(not GA) 
6.0.1   48457    6.5.1   58856 
6.0.2   51498    6.5.2   62212

Version Build    Version Build     Version Build 
4.0     24360    4.1     26745   4.2     30695
4.0.1   25252    4.1.1   28115   4.2.1   31413
                 4.1.2   29397   4.2.2   32030
                 4.1.3   29819   4.2.3   32748
                 4.1.4   30637   4.2.4   33350
                                 4.2.5   33761
                                 4.2.6   34311
                                 4.2.7   35057
                                 4.2.8   36593
                                 4.2.9   37693
                                 4.2.10  39598
                                 4.2.11  41462