sys.pdw_health_alerts (Transact-SQL)

Applies to: Analytics Platform System (PDW)

This view stores properties for the different alerts that can occur on the system. This table is a catalog table for alerts.

Column Name	Data Type	Description	Range
alert_id	int	Unique identifier of the alert. Key for this view.	NOT NULL
component_id	int	ID of the component this alert applies to. The component is a general component identifier, such as "Power Supply," and is not specific to an installation. See sys.pdw_health_components (Transact-SQL).	NOT NULL
alert_name	nvarchar(255)	Name of the alert.	NOT NULL
state	nvarchar(32)	State of the alert.	NOT NULL Possible values: 'Operational' 'NonOperational' 'Degraded' 'Failed'
severity	nvarchar(32)	Severity of the alert.	NOT NULL Possible values: 'Informational' 'Warning' 'Error'
type	nvarchar(32)	Type of alert.	NOT NULL Possible values: StatusChange - The device status has changed. Threshold - A value has exceeded the threshold value.
description	nvarchar(4000)	Description of the alert.	NOT NULL
condition	nvarchar(255)	Used when type = Threshold. Defines how the alert threshold is calculated.	NULL
status	nvarchar(32)	Alert status	NULL
condition_value	bit	Indicates whether the alert is allowed to occur during system operation.	NULL Possible values 0 - Alert is not generated. 1 - Alert is generated.

See Also