Table of Contents

Search

  1. Preface
  2. Introduction to Dynamic Data Masking Administration
  3. Authentication
  4. Security
  5. Connection Management
  6. JDBC Client Configuration
  7. ODBC Client Configuration
  8. Configuration for MicroStrategy
  9. Access Control
  10. Logs
  11. High Availability
  12. Server Control
  13. Performance Tuning
  14. Troubleshooting
  15. Appendix A: Database Keywords

Administrator Guide

Administrator Guide

Audit

Audit

Generates audit trail reports to help you analyze specific data. The audit trail report shows all changes made by users for selected objects in the specified time frame. The command also verifies that audit trail entries were not altered. You can write the report to the console or to a CSV file.
Use the
audit
command only with files generated by Dynamic Data Masking 9.9.1 or later.
The command uses the following syntax:
server audit [-report <compact | standard>] [-file <file0 file1…> | [-start <yyyy_MM>] [-end <yyyy_MM>]] [-out <console | file.csv>]
Example 1:
server audit -report standard -file 2019_03.at -out D:\Audit\AuditReport.csv
Example 2:
server audit -report compact -start 2019_03 -end 2019_05 -out console
The
audit
command uses the following parameters:
report
Generate an audit trail report. You must specify a report type. Choose from a standard or a compact report. Default is compact.
  • standard
    . Contains the Date, Address, User name, Type, Path, Object name, Operation, Result, Attribute, Old value, New value, and Notes.
  • compact
    . Contains the Date, Address, User name, Type, Path, Object name, Operation, Result, and Notes.
file
Read the specified audit log file or files. Insert a space to separate file names.
start
Date when you want Dynamic Data Masking to start reading audit log files. Dynamic Data Masking reads all audit log files between the start and end dates you specify. If you do not specify a start date, Dynamic Data Masking uses the audit log file for the current date.
end
Date when you want Dynamic Data Masking to stop reading audit log files. Dynamic Data Masking reads all audit log files between the start and end dates you specify. If you do not specify an end date, Dynamic Data Masking uses the audit log file for the current date.
out
Specify how to write the audit report. To write the report to the console, specify
console
. To write the report to a file, specify a path to a CSV file. Default is
console
.
For sample reports, see Audit Trail Reports.

0 COMMENTS

We’d like to hear from you!