TWTQ: Enabling advanced auditing reports

TWTQ: Enabling advanced auditing reports

Hey everyone!

Here's This Week's Top Question:

Q: How do I enable advanced auditing reports for my SQL Server?

A: Log360 generates a wide variety of reports that help audit your SQL Servers. There is also an additional set of advanced auditing reports you can get, if you choose to enable them. These reports help any database administrator take their auditing game to the next level, by providing granular details regarding your database activity. These reports include details about users' last login times, server information, security changes, and more. The column integrity monitoring report even tracks data modifications and tells you the values before and after the change, allowing you to protect the integrity of critical data.

Enabling advanced auditing
All you have to do to enable advanced auditing is select the advanced auditing checkbox when you add the SQL Server instance. You can also configure it anytime from the Manage Applications page. To configure advanced auditing:
Go to Settings -> Configuration settings -> Manage Application Sources -> SQL Servers
  • Under the Database Auditing tab for the required SQL Server instance, click on Not configured.
  • Click on Enable.
  • Select the Advanced auditing checkbox, and provide the necessary credentials.

Once it is configured, you can even select which tables are to be included within the advanced auditing reports:
  • Under the Database Auditing column, click on Configure for the required SQL Server instance.
  • In the popup window which opens, you can select and enable/disable the tables you need from the list displayed.
Please not that enabling advanced auditing creates an audit policy on your SQL Server. 

Once you've set this up, you can find all the advanced auditing reports under Applications tab > SQL Server Advanced Auditing reports.