Insight ACRWV.AUDITEVENT column values

Follow

Tracy Cullen

• February 08, 2021 22:21

Can you tell me where I can find a list of values for PRODUCT, ACTION and OBJECTTYPE columns in the ACRWV.AUDITEVENT table?  Assuming '1' = Insight, and action '3' =logoff or login.  trying to do some analysis on what reports are being accessed, etc...

0

• 

  Gerard Cafaro

  • February 09, 2021 14:24

  The data in the AUDITEVENT table gets translated into the actual values in the Audit Trail report in the UI. You can access this report under Reports -> Audit Trail:

  

  For your report analysis, a filter on Object Type for Control Report, Freeform Report or User Report would show the activity associated with each of them.

  0

  Comment actions Permalink
• 

  Matthew Kennedy

  • February 09, 2021 14:50

  Tracy,

  Navigating to the "Help Documentation" within the UI, there is a section detailing information that may be helpful on this topic :

  

  

  Matthew Kennedy

   

  0

  Comment actions Permalink
• 

  Stephanie Brockway

  • February 26, 2021 16:42

  We are doing our own reporting and controls off of the table directly and were hoping to save some time by getting the key to the info directly from Infogix, versus having to do trial and error and cross referencing the Audit Trail Report.  While we will undoubtedly manage, if you have the mapping of the flag values to the activities, that would add a ton of value and save us a good amount of time.

  0

  Comment actions Permalink
• 

  Matthew Kennedy

  • February 26, 2021 17:24
  • Edited

  Stephanie, are you looking for something similar to the following :

  Action Type :

  -1 : "Unknown"
  0 : "Generated PDF"
  1 : "Exported"
  2 : "Accessed"
  3 : "Removed"
  4 : "Assigned"
  5 : "Rolled Off"
  6 : "Created"
  7 : "Edited"
  8 : "Deleted"
  9 : "Imported"
  10 : "Manual Start"
  11 : "Loaded"
  12 : "Reloaded"
  13 : "Taken"
  14 : "Released"
  15 : "Submitted"
  16 : "Rejected"
  17 : "Escelated"
  18 : "Approved"
  19 : "Opened"
  20 : "Closed"
  21 : "Approve Requsted"
  22 : "Reopened"
  23 : "Batch Updated"
  24 : "Logged In"
  25 : "Logged Off"
  26 : "Timeoff"

  Object Type :

  -1 : "Unknown"
  0 : "Control Report"
  1 : "User Report"
  2 : "Result Catalog"
  3 : "Key History"
  4 : "Freeform Report"
  5 : "Job History"
  6 : "Control"
  7 : "Control Execution"
  8 : "Contact"
  9 : "Control Group"
  10 : "Control View"
  11 : "Compliance Program"
  12 : "Info Source"
  13 : "Insight Rules"
  14 : "Note"
  15 : "Auto Assignment"
  16 : "System Opts"
  17 : "History Extract"
  18 : "Autoload Status"
  19 : "Dashboard"
  20 : "Dashboard Component"
  21 : "Case Queue"
  22 : "Case Routing Rule"
  23 : "Case"
  24 : "Report"
  25 : "Process Model"
  26 : "Basic Job Info"
  27 : "User Report Info"
  28 : "Basic File Info"
  29 : "History Analysis Report"
  30 : "History Analysis Process"
  31 : "History Analysis"
  32 : "Internal Translation Table Info"
  33 : "Cycle Table Info"
  34 : "External Translation Info"
  35 : "Login Info"
  36 : "Logoff Info"
  37 : "Custom View"
  38 : "Custom Component"
  39 : "User Prefs"

  Matthew Kennedy

  0

  Comment actions Permalink
• 

  Stephanie Brockway

  • February 26, 2021 17:21

  Yes, this is exactly what we were hoping for. Thank you so much!

  0

  Comment actions Permalink

Please sign in to leave a comment.