alerts

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

Overview

Name	alerts
Type	Resource
Id	azure_stack.infrastructure_insights_admin.alerts

Fields

vw_alerts

Name	Datatype	Description
description	text	field from the properties object
alertName	text	field from the properties object
alert_id	text	field from the properties object
alert_properties	text	field from the properties object
closed_by_user_alias	text	field from the properties object
closed_timestamp	text	field from the properties object
created_timestamp	text	field from the properties object
fault_id	text	field from the properties object
fault_type_id	text	field from the properties object
has_valid_remediation_action	text	field from the properties object
impacted_resource_display_name	text	field from the properties object
impacted_resource_id	text	field from the properties object
last_updated_timestamp	text	field from the properties object
location	text	The Azure Region where the resource lives
remediation	text	field from the properties object
resourceGroupName	text	field from the properties object
resource_provider_registration_id	text	field from the properties object
resource_registration_id	text	field from the properties object
severity	text	field from the properties object
state	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	Resource tags.
title	text	field from the properties object

alerts

Name	Datatype	Description
location	string	The Azure Region where the resource lives
properties	object	Contains alert data.
tags	object	Resource tags.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	alertName, location, resourceGroupName, subscriptionId	Returns the requested an alert.
list	SELECT	location, resourceGroupName, subscriptionId	Returns the list of all alerts in a given region.
close	EXEC	alertName, location, resourceGroupName, subscriptionId, user	Closes the given alert.
repair	EXEC	alertName, location, resourceGroupName, subscriptionId	Repairs an alert.

SELECT examples

Returns the list of all alerts in a given region.

vw_alerts

SELECT
description,
alertName,
alert_id,
alert_properties,
closed_by_user_alias,
closed_timestamp,
created_timestamp,
fault_id,
fault_type_id,
has_valid_remediation_action,
impacted_resource_display_name,
impacted_resource_id,
last_updated_timestamp,
location,
remediation,
resourceGroupName,
resource_provider_registration_id,
resource_registration_id,
severity,
state,
subscriptionId,
tags,
title
FROM azure_stack.infrastructure_insights_admin.vw_alerts
WHERE location = '{{ location }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

alerts

SELECT
location,
properties,
tags
FROM azure_stack.infrastructure_insights_admin.alerts
WHERE location = '{{ location }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';