Terraform-provider-azurerm: azurerm_sql_server: Audit Configuration

[midacts]

Community Note

• Please vote on this issue by adding a 👍 reaction to the original issue to help the community and maintainers prioritize this request
• Please do not leave "+1" or "me too" comments, they generate extra noise for issue followers and do not help prioritize the request
• If you are interested in working on this issue or have submitted a pull request, please leave a comment

Description

Add SQL Server audit configuration

New or Affected Resource(s)

• azurerm_sql_server
• azurerm_sql_database

[mybayern1974]

https://github.com/Azure/azure-rest-api-specs/issues/7597
https://github.com/hashicorp/terraform/issues/23161

[conork123]

Hi Guys I can see auditing is available in the azurerm_sql_database resource, but not in the azurerm_sql_serrver resource still. Will this be implemented?

Once applied at the server level it's inherited by any future DB's created. While we can enforce auditing through a DB terraform module, it would be nice to just set this once at the SQL server level.

[tomjosekal]

extended_auditing_policy supports only storage based auditing.
What about Log Analytics and Event Hub based auditing?

[hashibot[bot]]

This has been released in version 2.1.0 of the provider. Please see the Terraform documentation on provider versioning or reach out if you need any assistance upgrading. As an example:

provider "azurerm" {
    version = "~> 2.1.0"
}
# ... other configuration ...

[hashibot[bot]]

I'm going to lock this issue because it has been closed for _30 days_ ⏳. This helps our maintainers find and focus on the active issues.

If you feel this issue should be reopened, we encourage creating a new issue linking back to this one for added context. If you feel I made an error 🤖 🙉 , please reach out to my human friends 👉 [email protected]. Thanks!