Skip to main content

SYS.Monitor.Health.HealthAlert

SQL Table Name: SYS_Monitor_Health.HealthAlert

Storage for Alerts from the Health Monitor.

Property Inventory

Method Inventory

Properties

property AlertDateTime as %String;
Date/Time of Alert
Property methods: AlertDateTimeDisplayToLogical(), AlertDateTimeGet(), AlertDateTimeGetStored(), AlertDateTimeIsValid(), AlertDateTimeLogicalToDisplay(), AlertDateTimeLogicalToOdbc(), AlertDateTimeNormalize(), AlertDateTimeSet()
property Item as %String (MAXLEN = 250);
Sensor item
Property methods: ItemDisplayToLogical(), ItemGet(), ItemGetStored(), ItemIsValid(), ItemLogicalToDisplay(), ItemLogicalToOdbc(), ItemNormalize(), ItemSet()
property Mean as %String;
Sensor mean
Property methods: MeanDisplayToLogical(), MeanGet(), MeanGetStored(), MeanIsValid(), MeanLogicalToDisplay(), MeanLogicalToOdbc(), MeanNormalize(), MeanSet()
property Readings as %List;
Sensor readings for period
Property methods: ReadingsGet(), ReadingsGetStored(), ReadingsIsValid(), ReadingsLogicalToOdbc(), ReadingsOdbcToLogical(), ReadingsSet()
property Rulecode as %Integer [ Required ];
Rule
Property methods: RulecodeDisplayToLogical(), RulecodeGet(), RulecodeGetStored(), RulecodeIsValid(), RulecodeLogicalToDisplay(), RulecodeNormalize(), RulecodeSet()
property Sensor as %String (MAXLEN = 250) [ Required ];
Name of sensor
Property methods: SensorDisplayToLogical(), SensorGet(), SensorGetStored(), SensorIsValid(), SensorLogicalToDisplay(), SensorLogicalToOdbc(), SensorNormalize(), SensorSet()
property Severity as %Integer [ Required ];
Severity
Property methods: SeverityDisplayToLogical(), SeverityGet(), SeverityGetStored(), SeverityIsValid(), SeverityLogicalToDisplay(), SeverityNormalize(), SeveritySet()
property Sigma as %String;
Sensor standard deviation (sigma)
Property methods: SigmaDisplayToLogical(), SigmaGet(), SigmaGetStored(), SigmaIsValid(), SigmaLogicalToDisplay(), SigmaLogicalToOdbc(), SigmaNormalize(), SigmaSet()
property Values as %List [ Required ];
Sensor values for alert
Property methods: ValuesGet(), ValuesGetStored(), ValuesIsValid(), ValuesLogicalToOdbc(), ValuesOdbcToLogical(), ValuesSet()

Methods

classmethod Purge(DateTime As %String) as %Status
Purge old alerts, upt to . Date is in $h format.

Queries

query Alerts(BeginDateTime As %String, EndDateTime As %String)
SQL Query:
SELECT AlertDateTime, Sensor, Severity, Rulecode, %ID FROM HealthAlert WHERE AlertDateTime BETWEEN :BeginDateTime AND :EndDateTime
Return the sensors for a given date
query AlertsBySensor(BeginDateTime As %String, EndDateTime As %String, Sensor As %String)
SQL Query:
SELECT AlertDateTime, Sensor, Severity, Rulecode, %ID FROM HealthAlert WHERE AlertDateTime BETWEEN :BeginDateTime AND :EndDateTime AND Sensor = :Sensor
Return the alert(s) for a given sensor

Indexes

index (IDKEY on ) [IdKey, Type = key];
Index methods: IDKEYCheck(), IDKEYDelete(), IDKEYExists(), IDKEYOpen(), IDKEYSQLCheckUnique(), IDKEYSQLExists(), IDKEYSQLFindPKeyByConstraint(), IDKEYSQLFindRowIDByConstraint()

Inherited Members

Inherited Methods

Storage

Storage Model: CacheStorage (SYS.Monitor.Health.HealthAlert)

^SYS.Monitor.He93E0.HealthAlertD(ID)
=
%%CLASSNAME
Sensor
Item
Rulecode
Severity
Values
Readings
Mean
Sigma
AlertDateTime
FeedbackOpens in a new tab