User audit log

A user audit log consists of a table with a name of the form DNI_A_USR_ou. Each table contains the following information:
Table 1. User audit database fields
Field name Data type Mandatory Description
AU_LOG_GMT_TS TIME STAMP Yes Date and time, in Coordinated Universal Time (UTC), when the message was stored in the audit log.
AU_AUDIT_GMT_TS TIME STAMP Yes Date and time, in UTC, when the service requested that the message be stored in the audit log.
AU_ACTION_TYPE CHAR(16) Yes The type of user action. Possible values:
  • AccessFailed
  • Approve
  • Authorize
  • Commit
  • Deploy
  • Revoke
AU_AGENT_USR_ID CHAR(100) Yes The user ID that performed the action.
AU_AGENT_MSG_ID CHAR(24) FOR BIT DATA   The identifier of the message that caused the auditing of the action.
AU_OU_NAME CHAR(8) Yes OU for which the user is acting.
AU_DNI_OBJ_TYPE CHAR(4)   The entity type that is affected by the user action. Possible values:
COS
For a configuration object set.
CT
For a configuration object type.
OU
For an organizational unit.
RG
For a role group.
RO
For a role.
USR
For a user.
AU_DNI_OBJ_NAME VARCHAR (254)   The name of the entity that is affected by the action.
AU_CT_NAME VARCHAR (254)   CT for which the access failed. This field is filled only if the field AU_ACTION_TYPE contains the value AccessFailed.
AU_CO_NAME VARCHAR (30)   Configuration object for which the access failed. This field is filled only if the field AU_ACTION_TYPE contains the value AccessFailed.
AU_ATTR_NAME VARCHAR (30)   The attribute of the configuration object for which the access failed. This field is filled only if the field AU_ACTION_TYPE contains the value AccessFailed.
AU_ATTR_VALUE VARCHAR (254)   The value of the attribute of the configuration object for which the access failed. This field is filled only if the field AU_ACTION_TYPE contains the value AccessFailed.

You can use database views to retrieve information about each of the FTM SWIFT entities. For more information, see Database audit views.