TWTQ: Advanced SQL auditing reports
Here's This Week's Top Question (TWTQ):
Q: What are the advanced reports available for auditing SQL Servers?
A: Log360 allows you to add SQL Server instances with ease using its auto discovery feature, and instantly starts generating a wide variety of reports that help audit your SQL Servers. However, did you know that 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.
Types of reports
Log360 includes the below advanced auditing reports:
- Last Login Time: Track the last login time of your database users.
- Delete Operations: View the various database objects which have been deleted.
- Login Information: Audit the various logins to your database.
- Most Used Tables: Identify which tables are popularly used on your database.
- Table Updates: Get details on the tables which have been updated.
- Index Information: View details about the various indexes created for your database.
- Server Information: View a summary of your server information.
- Waits Information: Get details regarding the various waits which occur during the database operations, such as resource waits, queue waits, and external waits.
- Blocked Processes: Troubleshoot database performance by identifying which processes get blocked.
- Schema Change History: Understand changes to your database structure over time.
- Object Change History: View changes to various database objects over time.
- Connected Applications: Audit the various applications which interface with your database.
- Security Changes: Ensure database security by viewing changes to security settings.
- Permissions Information: View a summary of the various database permissions.
- Last Backup of Database: Track your database backups, and ensure no unauthorized backups take place.
- Last DBCC Activity: Audit database console commands and keep a check on various maintenance and validation operations on your database.
With these reports, database administrators can conduct thorough database audits and ensure complete security.