Layton ServiceDesk - Procedures - General - How to Find the Version Number

Back to Contents

Application Version

The version number listed in Programs and Features may be incorrect. When Layton ServiceDesk is installed, the version number is correct. Later updates may not change this version, however.

In Layton ServiceDesk, click the Administration button and scroll to the bottom of the page. The version number appears in the lower left.

Database Version

The version of the database may be different to that of the application. The database structure may not need to be modified between versions. In terms of disaster recovery, the same application version could be installed and connected to the database.

In the database table admin, look for the value db_compatible_app in the sys_admin_id column. The version number appears in the sys_admin_value column in this row. This SQL query will also return the version number:

   SELECT sys_admin_value AS "Database Version Number"
   
   FROM [admin]
   
   WHERE sys_admin_id = 'db_compatible_app'

Back to Contents