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