Azure alert for a logic app which does not trigger according to the requirement

Question

So basically, we have an Azure subscription, consisting a storage account. On other side we have a logic app which runs every 6 hours a blob is created in the container, which is done by a snowflake script through a pipeline. so our requirement is when a blob is not created on a daily basis we should get an alert on teams, followed this documentation for the alerts on a teams channel.

https://techcommunity.microsoft.com/t5/core-infrastructure-and-security/azure-monitor-alert-notification-via-teams/ba-p/2507676

We have tried few solution but the alerts does not work according to our requirements.

Tried metrics are as follows:

• Actions Skipped
• Actions Succeeded
• Runs Succeeded
• Triggers Skipped
• Triggers Fired
• Triggers Succeeded

Answer 1

Hello @Siddharth ,

Thank you for your post and sharing the information on this scenario. Can you first please confirm if you have successfully configured this logic app and if the alerts are being pushed successfully?

This definitely appears to be a more challenging scenario, after consulting with my colleagues we did come up with the following recommendations for you to test:

1. Enable diagnostic settings on the Logic App sending data to a Log Analytics workspace (Diagnostic settings in Azure Monitor - Azure Monitor | Microsoft Learn).
2. Create a Log Analytics query that checks for successful executions of that Logic App by querying the AzureDiagnostics table (see example query below).
3. Create a Log alert rule that executes that query and then checks the number of table rows returned. If that number is 0, then fire the alert as that would mean that no successful executions of the Logic App occurred (Create Azure Monitor alert rules - Azure Monitor | Microsoft Learn). let workflowName = "LOGICAPPNAMEGOESHERE";
   AzureDiagnostics
   | where TimeGenerated > ago(1d)
   | where ResourceType == "WORKFLOWS/RUNS"
   | where resource_workflowName_s =~ workflowName
   | where status_s == "Succeeded"

Please let us know if this helps and we'll be happy to assist you further.

Thanks!
Carlos V.

----------

Please remember to "Accept Answer" if any answer/reply helped, so that others in the community facing similar issues can easily find the solution.