Netwrix Auditor for SQL Server

Comprehensive solution for SQL Server change auditing and reporting

Available Reports

The following predefined reports are available in the Enterprise edition of the product.

Name Description
All SQL Server Changes Shows all changes made to SQL server objects and permissions, including created, modified, and deleted server instances, roles, tables, columns, stored procedures, and all other types of objects. This report can be used for compliance audits to show that all changes are traceable and auditable. Download sample.
All SQL Server Changes by Date Shows all changes made to SQL server objects and permissions, including created, modified, and deleted server instances, roles, tables, columns, stored procedures, and all other types of objects. This report can be used for compliance audits to show that all changes are traceable and auditable.
All SQL Server Changes by Object Type Shows all changes made to SQL server objects and permissions, including created, modified, and deleted server instances, roles, tables, columns, stored procedures, and all other types of objects arranged by date. This report can be used for compliance audits to show that all changes are traceable and auditable.
All SQL Server Changes by Server Shows all changes to SQL server objects grouped by server name. This report must be regularly reviewed to detect unauthorized changes and confirm that expected changed were implemented as planned.
All SQL Server Changes by User Shows all changes to SQL server object grouped by user name who made changes. This report can be used to analyze user activities for specific users.
Removed SQL Server Objects Shows who deleted what SQL server objects and when. This report should be reviewed on a regular basis to make sure no objects are deleted without authorization and perform quick restore from backup if any unwanted changes are detected.
Newly Created SQL Server Objects Shows who show created what SQL server objects and when. This report can be used to analyze usage of SQL server resources and prevent sprawl of unneeded SQL server objects.
Modified SQL Server Objects Shows who modified what SQL server objects and when. This report can be used to analyze changes that can potentially impact applications that rely on SQL databases.
Credential Changes Shows all credential changes made within specified timeframe. This report must be reviewed on a regular basis to unauthorized access attempts.
Application Role Changes Shows all changes in database application roles made within specified timeframe. Changes in roles can impact applications and must be reviewed on a regular basis.
Database Changes Shows all changes in databases and their properties, such newly created and deleted databases, data file locations, and other attributes, excluding changes in the inner objects (such as tables, columns, and stored procedures).
Role Changes Shows all changes in roles, such as creation and deletion of roles, and changes in role properties and memberships. This report must be carefully reviewed on a regular basis, because roles control security access to databases.
Database Schema Changes Shows all changes in database schema, such creation and deletion of schemas, and changes in schema properties (e.g. modification of dbo schema).
Stored Procedure Changes Shows creations, deletions, and modifications of stored procedures. Such changes must be carefully reviewed, because applications rely on stored procedures.
Table Changes Shows creations, deletions, and modifications of tables in databases, and changes in table columns. This report must be carefully reviewed to detect unauthorized changes that can severely impact database applications.
User Changes Shows creations, deletions, and modifications or users in databases. This report must be reviewed on a regular basis because user accounts control access to sensitive data.
View Changes Shows created, deleted, and modified database views. This report must be carefully reviewed to detect unauthorized changes that can severely impact database applications.
View index Changes Shows created, deleted, and modified database views indices. This report must be carefully reviewed to detect unauthorized changes that can severely impact database applications.
Login Changes Shows creation and deletion of database logins, and modification of login attributes. This report must be reviewed on a regular basis because database logins control access to sensitive data.
Server Instance Changes Shows creation and deletion of SQL Server instances, and changes of instance-level properties, such as access permissions. This report must be reviewed on a regular basis to control active SQL Server instances.
Server Role Changes Shows creation and deletion of server roles and changes of role properties and memberships. This report must be reviewed on a regular basis because roles control server-wide access to sensitive data.