Database activity monitoring (DAM) : Viewing audit records (activity auditing results)
 
Viewing audit records (activity auditing results)
The Activity Auditing page displays a list of audit records with their details. The audit records FortiDB generates when it is monitoring the database is determined by the activity auditing option you specify: Log All, or the policies selected on the Audit Policy Groups tab.
To enable activity auditing, you configure FortiDB to monitor the target database using the TCP/IP sniffer. For more information, see “Configuring monitoring using the TCP/IP sniffer (all database types)”.
Table 1: Audit record list columns
Columns
Descriptions
ID
Audit ID. This number is set sequentially.
Type
indicates that the audit is generated by Log All option enabled for target monitoring
indicates that the audit is generated by Table Policy
indicates that the audit is generated by Table and Column Policy
indicates that the audit is generated by Session Policy
indicates that the audit is generated by User Policy
indicates that the audit is generated by Database Policy
indicates that the audit is generated by Privilege Policy
indicates that the audit is generated by Metadata Policy
Timestamp
Audit timestamp
Target
Target database name.
Source Hostname/IP
Hostname and IP address of source client.
Action
Action of database activity
DB User
Database user of action.
SQL Text
SQL Text.
See also
Filtering and searching the audit record list
Viewing audit record details