TRIRIGA version numbers

[Tririga Dev]

Hi there

Are there any db querys to find out the application and platform version?

E.g. select environment, property, value from environment_properties;

For example I find there the build number (select environment, property, value from environment_properties where property = 'db.build.number';) e.g. 146125, as far as I know, this mean I am using TRIRIGA platform 3.4.1.

But how can I find out, which application version (e.g. 10.4.1) is used?

Thanks a lot

[Ravindra Lokhande]

You can check it in Build Number page of Tririga admin console UI. Check the application version by opening application version page from Tririga UI . [ tools-->system setup-->System --> Application Version]

On Monday, 27 October 2014 14:08:42 UTC+5:30, Tririga Dev wrote:

Hi there

Are there any db querys to find out the application and platform version?

E.g. select environment, property, value from environment_properties;

For example I find there the build number (select environment, property, value from environment_properties where property <span style="font-size:10.0pt;f

...

[Bruce Nguyen]

For the platform version, it's a bit easier these days in that you can query where property = 'db.version' for the platform (3.4.1 in your case) rather than cross referencing the build number.

For the application version, you can run the following:

select TRIAUTHORTX, TRIINSTALLDT, TRIVERSIONTX, TRIINSTALLATIONTYPELI from T_TRIAPPLICATIONVERSION1

It will show the initial installed application version and any upgrades to date.  However, this will assume that you run all the patch helper DI files with each application upgrade to keep this application installation version up to date.  This is a relatively new feature introduced in one of the later version 9 apps.  So if you have an older initial install and app upgrades prior to version 10, those may not be listed and there was no easy way to tell the application version back then.

Thanks.

On Monday, October 27, 2014 3:38:42 AM UTC-5, Tririga Dev wrote:

Hi there

Are there any db querys to find out the application and platform version?

E.g. select environment, property, value from environment_properties;

For example I find there the build number (select environment, property, value from environment_properties where property <span style="font-size:10.0pt;f

...

[Tririga Dev]

Hi Bruce

Thanks a lot for that great answer! This is exactly what I was looking for.

Have a nice day.

Best regards.