alerts

Creates, updates, deletes, gets or lists a alerts resource.

Overview

Name	alerts
Type	Resource
Id	azure.authorization.alerts

Fields

vw_alerts

Name	Datatype	Description
id	text	The alert ID.
name	text	The alert name.
alertId	text	field from the properties object
alert_configuration	text	field from the properties object
alert_definition	text	field from the properties object
alert_incidents	text	field from the properties object
incident_count	text	field from the properties object
is_active	text	field from the properties object
last_modified_date_time	text	field from the properties object
last_scanned_date_time	text	field from the properties object
scope	text	field from the properties object
type	text	The alert type.

alerts

Name	Datatype	Description
id	string	The alert ID.
name	string	The alert name.
properties	object	Alert properties.
type	string	The alert type.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	alertId, scope	Get the specified alert.
list_for_scope	SELECT	scope	Gets alerts for a resource scope.
update	UPDATE	alertId, scope	Update an alert.
refresh	EXEC	alertId, scope	Refresh an alert.
refresh_all	EXEC	scope	Refresh all alerts for a resource scope.

SELECT examples

Gets alerts for a resource scope.

vw_alerts

SELECT
id,
name,
alertId,
alert_configuration,
alert_definition,
alert_incidents,
incident_count,
is_active,
last_modified_date_time,
last_scanned_date_time,
scope,
type
FROM azure.authorization.vw_alerts
WHERE scope = '{{ scope }}';

alerts

SELECT
id,
name,
properties,
type
FROM azure.authorization.alerts
WHERE scope = '{{ scope }}';

UPDATE example

Updates a alerts resource.

/*+ update */
UPDATE azure.authorization.alerts
SET 
properties = '{{ properties }}'
WHERE 
alertId = '{{ alertId }}'
AND scope = '{{ scope }}';