Update-AzScheduledQueryRule throws exception

Racheal 6 Reputation points


I need to disable an alert using Update-AzScheduledQueryRule but it throws AggregateException as below for the alert with query

| where name contains 'health'
| where success == 0 and message != "Passed"


Update-AzScheduledQueryRule : Exception type: Exception, Message: System.Exception: Error in updating Log Alert Rule ---> System.AggregateException: One or more errors occurred. ---> Microsoft.Azure.Management.Monit
or.Models.ErrorContractException: Operation returned an invalid status code 'BadRequest'
at Microsoft.Azure.Management.Monitor.ScheduledQueryRulesOperations.

Azure Monitor
Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
2,858 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. SwathiDhanwada-MSFT 17,881 Reputation points

    @Racheal Welcome to Microsoft Q & A Community Forum. Kindly note that the query of a metric measurement alert rule must include an AggregatedValue column of a numeric type.

    Log alerts that do not meet this condition are failing to be disabled with powershell cmdlet Update-AzScheduledQueryRule. Product Group team has a note of this to provide the error message better.

    0 comments No comments

  2. Saurabh Bhargava 1 Reputation point Microsoft Employee

    In case we dont have these conditions than which command can we use?

    0 comments No comments