Skip to content

Instantly share code, notes, and snippets.

@DataSic
Created June 3, 2018 14:39
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Embed
What would you like to do?
Modify Set-AzureRmSqlDatabaseAuditing
$AuditActionGroup = @("SUCCESSFUL_DATABASE_AUTHENTICATION_GROUP",
"FAILED_DATABASE_AUTHENTICATION_GROUP",
"BATCH_COMPLETED_GROUP",
"BACKUP_RESTORE_GROUP",
"DATABASE_OPERATION_GROUP",
"USER_CHANGE_PASSWORD_GROUP")
$setAzureRmSqlDatabaseAuditingSplat = @{
ResourceGroupName = "ResourceGroupName"
ServerName = "ServerName"
DatabaseName = "DatabaseName"
StorageAccountName = "StorageAccountName"
State = "Enabled"
AuditActionGroup = $AuditActionGroup
}
Set-AzureRmSqlDatabaseAuditing @setAzureRmSqlDatabaseAuditingSplat
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment