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?
o_objtype
o_objno
o_action
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 8.11.11.574 on a SQL*Server database.
Thanks in advance.
L.
One's tagged with a ? are ones i figured out on my own and I'm not 100% sure they're correct.
o_action numbers
1
Project/folder created
2
Project/folder modified
3
Project/folder workflow changed
4
Project/folder deleted
5
Project/folder state changed
6
Project/folder access control assigned
?
7
Project/folder access control modified
8
Project/folder access control removed
1000
Unknown document action
1001
Document created
1002
Document's general properties modified
1003
Document attributes modified
1004
Document file added
1005
Document file removed
1006
Document file replaced
1007
Document checked-in
1008
Document viewed
1009
Document checked-out
1010
Document copied-out
1011
Document given-out
1012
Document state changed
1013
Document final status set
1014
Document final status removed
1015
New document version created
1016
Document moved
1017
Document copied
1018
Document permissions changed
1019
Redline created or accessed
1020
Document deleted
1021
Document exported
1022
Document freed
1023
Document extracted
1024
Document distributed
1025
Document send to mail recipient
1026
Commented by user
1027
Document imported
1028
Document Access Control Assigned
1029
Document Access Control Modified
1030
Document Access Control Removed
1031
Revit worksharing mode actions
1032
Document pack
1033
Document unpack
2001
Document set formed
2002
Document set member added
2003
Document set member removed
3001
Login
3002
Logout
3003
User Created
4001
Group Create
4002
Group Modify
4003
Group Member Add
4004
Group Member Remove
5001
User List Create
5002
User List Modify
5003
User List member add
5004
User List member remove
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