Fields in the Audit Trail Data Set

Important: You must enable the respective additional data set to generate this report type.

This report provides detailed information about activities that a user performs in the system.

Field Description

The table below describes fields available in this report data set.

Field name Type Description Example
AUDITTRAIL_USER_ID Integer ID of the user that performed the action 1000250
AUDITTRAIL_USER_FNAME String First name of the user that performed the action John
AUDITTRAIL_USER_MNAME String Middle name of the user that performed the action Martin
AUDITTRAIL_USER_LNAME String Last name of the user that performed the action Smith
AUDITTRAIL_USER_USERNAME String Username of the user that performed the action mverger@mailinator.com
AUDITTRAIL_EFFECTIVE_USER_ID Integer ID of the user on whose behalf the action was performed 1000344
AUDITTRAIL_EFFECTIVE_USER_FNAME String First name of the user on whose behalf the action was performed John
AUDITTRAIL_EFFECTIVE_USER_MNAME String Middle name of the user on whose behalf the action was performed Martin
AUDITTRAIL_EFFECTIVE_USER_LNAME String Last name of the user on whose behalf the action was performed Smith
AUDITTRAIL_EFFECTIVE_USER_USERNAME String Username of the user on whose behalf the action was performed mverger@mailinator.com
AUDITTRAIL_ACTION_TIMESTAMP DateTime Time and date the action took place (machine readable) 1660824511
AUDITTRAIL_ACTION_DATETIME String Time and date the action took place (human readable) 2014-09-24 18:12:34
AUDITTRAIL_ACTION String Audit message for an action Excel configuration import
AUDITTRAIL_REQUEST_METHOD String HTTP method invoked in the corresponding operation POST
AUDITTRAIL_REQUEST_OPERATION String Method name invoked in the corresponding operation applyConfig
AUDITTRAIL_COMPONENT_NAME String Name of component that executed the operation Order Management
AUDITTRAIL_CLIENT_IP String IP addresses from which the operation was performed 10.194.251.10, 127.0.0.1, 10.244.0.18
AUDITTRAIL_USER_AGENT String HTTP request header to identify the client app, OS, vendor, and so on Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.0.0 Safari/537.36
AUDITTRAIL_CONTEXT_DATA JSON Additional data specific to the given operation { "Service Template ID":79, "Account ID":1000004 }
AUDITTRAIL_INTEGRITY_CHECK String Status of the operation, passed or failed PASSED