Get KeyWatcher TrueTouch Profile IDs
Morse Watchmans KeyWatcher TrueTouch allows key administrators to assign access to keys based on Profiles. Use of this access, and changes to these profiles, is logged and can be audited using inbuilt reports.
For some reason, the TrueTouch software will display the database
ID of each Profile in the reporting, rather than the actual
ProfileNo shown in the graphical user interface (GUI) as the “ID”. This can make following the audit reports difficult, as auditors and other personnel who routinely review such reports tend to not have access to the database directly.
Because of this, I threw together this simple SQL query that can be used on a KeyWatcher MSSQL database to get the database IDs and their translated IDs shown in the GUI into a single table, which can then be used to cross-reference and audit.
You can use the below MSSQL query:
Get the Query File
You can download the above query using the below command:
This is a pretty niche issue, but I hope that someone else find this useful.