How to stop alerts in Activity Log related to db delete

Seyed Amir Iranmanesh (HCL TECHNOLOGIESCORPORATE) 1

We initiated a 'delete' action on one of our Azure SQL db which we do not have privilege to do so. There are alerts which have been generated since then causing to pause our Azure email notifications. Is there any way to cancel the 'delete' action to stop these alerts?

Oury Ba-MSFT 19,801 Reputation points Microsoft Employee

2022-03-29T21:16:41.867+00:00

Hi @Seyed Amir Iranmanesh (HCL TECHNOLOGIESCORPORATE) Thank you for posting your question on Microsoft Q&A and for using Azure services.

My understanding is that you are trying to delete alerts that are generating a pause on your Azure email notifications. Please let me know if my understanding is not correct.
Could you also try the below code using Azure CLI?

az monitor activity-log alert delete [--ids]
[--name]
[--resource-group]

Azure monitor activity log alert

Please do let us know if that works

Regards,
Oury
Oury Ba-MSFT 19,801 Reputation points Microsoft Employee

2022-03-30T17:19:25.297+00:00

@Seyed Amir Iranmanesh (HCL TECHNOLOGIESCORPORATE) Please let us know if this was helpful.

Regards,
Oury

1 answer

Alberto Morillo 34,146 MVP

Please try to set the action to disable:

Set-AzureRmSqlDatabaseAuditing `
 -State Disabled `
 -ResourceGroupName "resourcegroupname" `
 -ServerName "ssqlinstancename" `  #ssqlinstancename.database.windows.net
 -StorageAccountName "strageaccountname" `
 -DatabaseName "dbname" `
 -AuditActionGroup 'SCHEMA_OBJECT_CHANGE_GROUP' `
 -RetentionInDays 8 `
 -AuditAction "DELETE ON schema::dbo BY [public]"

Share via

How to stop alerts in Activity Log related to db delete

1 answer

Your answer