Table of Contents

Class AzureSynapseAnalyticsSchema.HealthAlert

Namespace
LinqToDB.Tools.DataProvider.SqlServer.Schemas
Assembly
linq2db.Tools.dll

sys.pdw_health_alerts (Transact-SQL)

Applies to: √ Analytics Platform System (PDW)

Stores properties for the different alerts that can occur on the system; this is a catalog table for alerts.


See sys.pdw_health_alerts.

[Table(Schema = "sys", Name = "pdw_health_alerts", IsView = true)]
public class AzureSynapseAnalyticsSchema.HealthAlert
Inheritance
AzureSynapseAnalyticsSchema.HealthAlert
Extension Methods

Properties

AlertID

Unique identifier of the alert.

Key for this view.
Range: NOT NULL

[Column("alert_id")]
[NotNull]
public int AlertID { get; set; }

Property Value

int

AlertName

Name of the alert.
Range: NOT NULL

[Column("alert_name")]
[NotNull]
public string AlertName { get; set; }

Property Value

string

ComponentID

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).
Range: NOT NULL

[Column("component_id")]
[NotNull]
public int ComponentID { get; set; }

Property Value

int

Condition

Used when type = Threshold. Defines how the alert threshold is calculated.
Range: NULL

[Column("condition")]
[NotNull]
public string Condition { get; set; }

Property Value

string

ConditionValue

Indicates whether the alert is allowed to occur during system operation.
Range: NULL

Possible values

0 - alert is not generated.

1 - alert is generated.

[Column("condition_value")]
[NotNull]
public bool ConditionValue { get; set; }

Property Value

bool

Description

Description of the alert.
Range: NOT NULL

[Column("description")]
[NotNull]
public string Description { get; set; }

Property Value

string

Severity

Severity of the alert.
Range: NOT NULL

Possible values:

'Informational'

'Warning'

'Error'

[Column("severity")]
[NotNull]
public string Severity { get; set; }

Property Value

string

State

State of the alert.
Range: NOT NULL

Possible values:

'Operational'

'NonOperational'

'Degraded'

'Failed'

[Column("state")]
[NotNull]
public string State { get; set; }

Property Value

string

Status

Alert status
Range: NULL

[Column("status")]
[NotNull]
public string Status { get; set; }

Property Value

string

TypeColumn

Type of alert.
Range: NOT NULL

Possible values:

StatusChange - The device status has changed.

Threshold - A value has exceeded the threshold value.

[Column("type")]
[NotNull]
public string TypeColumn { get; set; }

Property Value

string