Practical Database Auditing for Microsoft SQL Server and Azure SQL: Troubleshooting, Regulatory Compliance, and Governance

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2022

J. BushPractical Database Auditing for Microsoft SQL Server and Azure SQLhttps://doi.org/10.1007/978-1-4842-8634-0_12

12. Create Reports from Audit Data

Josephine Bush¹  

(1)

Boulder, CO, USA

 

After centralizing your audit data, you may want to query and report on it. This chapter will show you how you can create and send HTML reports with either SQL Server Agent or PowerShell.

HTML Reports with SQL Server Agent

Since the goal is to email the HTML report with SQL Server Agent , you will need to configure database mail first.

Tip

For more information on setting up database mail, visit https://docs.microsoft.com/en-us/sql/relational-databases/database-mail/configure-database-mail?view=sql-server-ver15 ...