alert_rule_resources

Creates, updates, deletes, gets or lists an alert_rule_resources resource.

Overview

Name	alert_rule_resources
Type	Resource
Id	azure.db_watcher.alert_rule_resources

Fields

The following fields are returned by SELECT queries:

get

Azure operation completed successfully.

Name	Datatype	Description
properties	object	The resource-specific properties for this resource.

list_by_parent

Azure operation completed successfully.

Name	Datatype	Description
properties	object	The resource-specific properties for this resource.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	subscriptionId, resourceGroupName, watcherName, alertRuleResourceName		Get a AlertRuleResource
list_by_parent	select	subscriptionId, resourceGroupName, watcherName		List AlertRuleResource resources by Watcher
create_or_update	insert	subscriptionId, resourceGroupName, watcherName, alertRuleResourceName		Create a AlertRuleResource
delete	delete	subscriptionId, resourceGroupName, watcherName, alertRuleResourceName		Delete a AlertRuleResource

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
alertRuleResourceName	string	The alert rule proxy resource name.
resourceGroupName	string	The name of the resource group. The name is case insensitive.
subscriptionId	string (uuid)	The ID of the target subscription. The value must be an UUID.
watcherName	string	The database watcher name.

SELECT examples

get

Get a AlertRuleResource

SELECT
properties
FROM azure.db_watcher.alert_rule_resources
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND watcherName = '{{ watcherName }}' -- required
AND alertRuleResourceName = '{{ alertRuleResourceName }}' -- required
;

list_by_parent

List AlertRuleResource resources by Watcher

SELECT
properties
FROM azure.db_watcher.alert_rule_resources
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND watcherName = '{{ watcherName }}' -- required
;

INSERT examples

create_or_update

Create a AlertRuleResource

INSERT INTO azure.db_watcher.alert_rule_resources (
data__properties,
subscriptionId,
resourceGroupName,
watcherName,
alertRuleResourceName
)
SELECT 
'{{ properties }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ watcherName }}',
'{{ alertRuleResourceName }}'
RETURNING
properties
;

Manifest

# Description fields are for documentation purposes
- name: alert_rule_resources
  props:
    - name: subscriptionId
      value: string (uuid)
      description: Required parameter for the alert_rule_resources resource.
    - name: resourceGroupName
      value: string
      description: Required parameter for the alert_rule_resources resource.
    - name: watcherName
      value: string
      description: Required parameter for the alert_rule_resources resource.
    - name: alertRuleResourceName
      value: string
      description: Required parameter for the alert_rule_resources resource.
    - name: properties
      value: object
      description: |
        The resource-specific properties for this resource.

DELETE examples

delete

Delete a AlertRuleResource

DELETE FROM azure.db_watcher.alert_rule_resources
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND watcherName = '{{ watcherName }}' --required
AND alertRuleResourceName = '{{ alertRuleResourceName }}' --required
;