• Replies 7 replies
  • Subscribers 62 subscribers
  • Views 9670 views
  • Users 0 members are here

Projectwise Audit Trail Action Name

Ben Fullenkamp
I am creating some reports in Access based off the dms_audt table for Projectwise and while it references action code in the table, it doesn't have any obvious link to another table where it actually pulls the "Checked Out" or "Exported" etc... text and it doesn;t seem to follow a logical pattern as to what code relates to what action.  Where does the text for the action name come from and how can I link it to my query so I can show what action the users in the reports are doing?
  • Offline in reply to Jon Evans

    Folder/Work Area:

    o_action ID

    CREATE

    1

    MODIFY

    2

    ASSIGN WORKFLOW

    3

    DELETE

    4

    STATE

    5

    ASSIGN ACCESS CONTROL LIST

    6

    MODIFY ACCESS CONTROL LIST

    7

    REMOVE ACCESS CONTROL LIST

    8

    ASSIGN CONNECT PROJECT

    9

    CHANGE CONNECT PROJECT

    10

    REMOVE CONNECT PROJECT

    11

    RESTORE

    12

    MOVED_FROM

    13

    MOVED_TO

    14

     

    Document:

     

    UNKNOWN

    1000

    CREATE

    1001

    MODIFY

    1002

    CHANGE ATTRIBUTE

    1003

    FILE IMPORT (Advanced in Properties)

    1004

    FILE REMOVE (Advanced in Properties)

    1005

    FILE REPLACE (Advanced in Properties)

    1006

    CHECK IN

    1007

    VIEW

    1008

    CHECK OUT

    1009

    COPY OUT

    1010

    GIVE OUT

    1011

    CHANGE STATE

    1012

    SET FINAL

    1013

    REMOVE FINAL

    1014

    CREATE VERSION

    1015

    MOVE

    1016

    COPY

    1017

    PERMISSIONS CHANGED

    1018

    REDLINE CREATED/ACCESED

    1019

    DELETE

    1020

    EXPORT

    1021

    FREE

    1022

    EXTRACT

    1023

    DISTRIBUTE

    1024

    SEND_TO

    1025

    COMMENT

    1026

    IMPORT

    1027

    ASSIGN ACCESS CONTROL LIST

    1028

    MODIFY ACCESS CONTROL LIST

    1029

    REMOVE ACCESS CONTROL LIST

    1030

    REVIT SPACIFIC INFORMATION

    1031

    PACK  (e.g. using PW i-model Packager)

    1032

    UNPACK (e.g. using PW i-model Packager)

    1033

    WRE_START

    1034

    WRE_END

    1035

    WRE_FAILURE

    1036

    RESTORE

    1037

    MOVED_TO

    1038

     

     

    Set:

     

    SET_CREATE

    2001

    SET_ADD

    2002

    SET_REMOVE

    2003

     

    User:

     

    USER_LOGIN

    3001

    USER_LOGOUT

    3002

    USER_CREATE

    3003

    USER_MODIFY

    3004

    CHANGE USER_SETTINGS

    3005

    USER_RENAME

    3006

    USER_DELETE

    3007

    USER_DISABLE

    3008

    USER_ENABLE

    3009

     

    Group:

     

    GROUP_CREATE

    4001

    GROUP_MODIFY

    4002

    GROUP_ADD

    4003

    GROUP_REMOVE

    4004

    GROUP_RENAME

    4005

    GROUP_DELETE

    4006

    GROUP_ASSIGN ACCESS CONTROL LIST

    4007

    GROUP_MODIFY ACCESS CONTROL LIST

    4008

    GROUP_REMOVE ACCESS CONTROL LIST

    4009

     

    User List:

     

    USER_LIST_CREATE

    5001

    USER_LIST_MODIFY

    5002

    USER_LIST_ADD

    5003

    USER_LIST_REMOVE

    5004

    USER_LIST_RENAME

    5005

    USER_LIST_DELETE

    5006

    USER_LIST_ASSIGN ACCESS CONTROL LIST

    5007

    USER_LIST_MODIFY ACCESS CONTROL LIST

    5008

    USER_LIST_REMOVE ACCESS CONTROL LIST

    5009

     

    State:

     

    STATE_CREATE

    6001

    STATE_RENAME

    6002

    STATE_DELETE

    6003

     

    Workflow:

     

    WORKFLOW_CREATE

    7001

    WORKFLOW_ADD

    7002

    WORKFLOW_REMOVE

    7003

    WORKFLOW_RENAME

    7004

    WORKFLOW_DELETE

    7005

    WORKFLOW_MOVE

    7006

     

    Interface:

     

    INTERFACE_CREATE

    8001

    INTERFACE_RENAME

    8002

    INTERFACE_DELETE

    8003

     

    Environment:

     

    ENVIRONMENT_CREATE

    8101

    ENVIRONMENT_MODIFY

    8102

    ENVIRONMENT_RENAME

    8103

    ENVIRONMENT_DELETE

    8104

    ENVIRONMENT_VIEW_REMOVE

    8105

    ENVIRONMENT_VIEW_CHANGE

    8106

     

    View:

     

    VIEW_CREATE

    9001

    VIEW_RENAME

    9002

    VIEW_DELETE

    9003

    VIEW_CHANGE

    9004

     

    Application:

     

    APPLICATION_CREATE

    9101

    APPLICATION_RENAME

    9102

    APPLICATION_DELETE

    9103

    APPLICATION_VIEWER

    9104

    APPLICATIONS_EXPORT

    9105

    APPLICATIONS_IMPORT

    9106

     

    Department:

     

    DEPARTMENT_CREATE

    9201

    DEPARTMENT_RENAME

    9202

    DEPARTMENT_DELETE

    9203

     

    Attributes:

     

    ENVIRONMENT_ATTR_ADD

    9301

    ENVIRONMENT_ATTR_REMOVE

    9302

    ENVIRONMENT_ATTR_MODIFY

    9303

     

    Work Area type (WA_TYPE):

     

    WA_TYPE_CREATE

    20001

    WA_TYPE_PROPERTY_ADD

    20002

    WA_TYPE_PROPERTY_REMOVE

    20003

    WA_TYPE_RENAME

    20004

    WA_TYPE_DELETE

    20005
  • Offline in reply to Kevin
    FWIW, you can determine the action codes from the header files delivered with the ProjectWise SDK.

    Here's what you see for the ones you mention:

    #define AADMSAT_ACT_USER_FIRST 3001
    #define AADMSAT_ACT_USER_LOGIN (AADMSAT_ACT_USER_FIRST+0)
    #define AADMSAT_ACT_USER_LOGOUT (AADMSAT_ACT_USER_FIRST+1)
    #define AADMSAT_ACT_USER_CREATE (AADMSAT_ACT_USER_FIRST+2)

    These particular ones are in the file "aadmsdef.h".
  • Offline in reply to Jon Evans
    I need the same code listing for object type 6 ... please ... getting 3 thousand type codes ... 3001 ,3002
  • Offline

    For reports I ended up doing this is what I came up with.

    If you would happen to figure out anymore let me know. 

    Report Info, o_action column in the dms_audt Table
    1001 is Created
    1002 is Modified
    1004 is File Added/Renamed 
    1007 is Checked In 
    1008 is Viewed 
    1009 is Checked Out
    1010 is Copied Out
    1011 is Copied To File 
    1013 is Final Status Set
    1014 is Final Status Removed
    1016 is Moved
    1017 is Copied From File 
    1021 is Exported 
    1022 is Freed
    1023 is DS Extracted
    1024 is DS Distributed 
    1025 is Sent to Email Recipient
    2001 is Set Formed
    2002 is Member Added 
    2003 is Member Removed
  • in reply to John Schown
    That worked great.  I just created my own table with these values and it seems to correspond perfectly.  Thanks for your help.

Communities
Support and Services
Training and Learning
Social Media