How to check when and to what versions the software and database versions were upgraded. What database query should I make? I need to get the whole history of updates made.
This thread was automatically locked due to age.
How to check when and to what versions the software and database versions were upgraded. What database query should I make? I need to get the whole history of updates made.
There is no such history of the number of upgrades which might be done on your existing Safeguard Server and database. You can find out the last update date and target version (which also represents the current DB version) using this query:
SELECT [TIF_TABLE_NAME]
,[TIF_VERSION]
,[TIF_MODIFY_DATE]
,[TIF_CREATED_BY]
,[TIF_MODIFIED_BY]
FROM [SafeGuard].[dbo].[TABLE_INFO] where TIF_TABLE_NAME = 'TABLE_INFO'
I hope this will help bit to know the last version from you upgraded.
Regards,
Jasmin
Community Support Engineer | Sophos Support
Sophos Support Videos | Knowledge Base | @SophosSupport | Sign up for SMS Alerts |
If a post solves your question use the 'This helped me' link