Good day, all.
I am trying to do some querying in the dms_audt table to provide to my clients some data that will help them to understand the types and counts of objects that are being audited so that we can review the vast number of audit records that are being kept in the system.
Would somebody be able to help me find the cross-reference/lookup tables that go with the following columns so that I can translate the ID number to an actual English definition?
I'd like to translate these codes into the values that can be seen in the audit trail when viewed through PW Explorer/Administrator (e.g. "Action Name" of "Checked Out", "User Comment", and Object type of "Document", "Folder).
We are using PW SS4 version 22.214.171.1244 on a SQL*Server database.
Thanks in advance.
Below should give you a reference to Auditted object types. o_objno will relate to corresponding objects unique identifier in respective tables (like o_userno in case of user, for documents and vaults o_objguid will be unique identifier, o_objno will usually be '0')
1 - Vault/Folder
2 - Document
3 - Set
4 - Workflow
5 - State
6 - User