Skip to main content

I can't see changed values with Database Content A

You have enabled Database Content Audit in Netwrix Auditor and received a report which contains only the number of modified rows without values. There are two possible reasons:

  1. You enabled the triggerless (Do not use triggers) mode. This option does not show before and after values.
  2. You enabled the Use triggers for detailed monitoring mode, but the table that you specified in the Monitoring rules does not contain a primary key. To add a primary key to the table, please run the following SQL command:
ALTER TABLE table_name ADD PRIMARY KEY (primary_key_column_name)

Please note that If you use the ALTER TABLE statement to add a primary key, the primary key column must already have been declared to not contain NULL values (when the table was first created).