How to find out the exact version of CAPC/DA/DC/DR from command line?

Document ID : KB000019508
Last Modified Date : 14/02/2018
Show Technical Document Details

User can find out the CAPC, DA, DR and DCs's exact version from these steps:

  1. For the CAPC

    1. Login to the CAPC machine as root or sudo user.

    2. Login to the MySql prompt with:
      mysql

    3. Change the database:
      use netqosportal;

    4. Run this command:
      SELECT * FROM revision_info;

    5. Example output will be:
      +---------+---------------------+-----------------+---------------------+-------------+-------------+
      | Version | InstallDate | DbSchemaVersion | BuildDate | BuildNumber | Description |
      +---------+---------------------+-----------------+---------------------+-------------+-------------+
      | 2.2.2.0 | 2013-07-19 04:45:19 | 2.1.104.1 | 2013-05-23_16-54-49 | 156 | CAPC |
      | 2.2.3.0 | 2013-08-19 06:43:49 | 2.2.1.0 | 2013-08-02_08-35-25 | 186 | CAPC |
      | 2.3.0.0 | 2013-09-03 23:41:08 | 2.2.105.0 | 2013-08-15_14-06-40 | 52 | CAPC |
      +---------+---------------------+-----------------+---------------------+-------------+-------------+

      3 rows in set (0.00 sec)

  2. For the DA:

    1. User can login to the DA machine as root or sudo user or just the normal user, then go to

      DA Installation directory/IMDataAggregator/apache-karaf-2.1.3/etc/ directory

    2. Run command to verify this file:
      ls -al .da_version.properties

    3. cat this .da_version.properties to find out the current version of the DA:
      cat .da_version.properties

    4. Example output will be:
      da.version.major=2
      da.version.minor=3
      da.version.patch=0
      da.version.build=55

      So the DA version is : 2.3.0, build 55

  3. For the DC:

    1. User can login to the DC machine as root or sudo user or just the normal user, then go to

      DC Installation directory/IMDataAggregator/apache-karaf-2.1.3/etc/ directory

    2. Run command to verify this file:
      ls -al .dc_version.properties

    3. cat this .dc_version.properties to find out the current version of the DA:
      cat .dc_version.properties

    4. Example output will be:
      dc.version.major=2
      dc.version.minor=3
      dc.version.patch=0
      dc.version.build=33

      So the DA version is : 2.3.0, build 33

  4. For the DR

    1. Login to the DR machine as dradmin or equivalent user.

    2. Run the following command to login to vertica:

      /opt/vertica/bin/vsql -U dradmin -w XXXX

    3. Run the following command to check vertica version:
      SELECT VERSION();

    4. Example output will be:
      VERSION
      ------------------------------------
      Vertica Analytic Database v6.0.2-0
      (1 row)

    5. Quit the vertica database command:
      \q