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

Once it is configured, you can even select which tables are to be included within the advanced auditing reports:

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.