Skip to main content

%SYS.Monitor.SensorReading

SQL Table Name: %SYS_Monitor.SensorReading

Persistent class for SystemSensor readings. Only used when Debug is enabled.

Property Inventory

Method Inventory

Properties

property Item as %String (MAXLEN = 250);
Sensor item
Property methods: ItemDisplayToLogical(), ItemGet(), ItemGetStored(), ItemIsValid(), ItemLogicalToDisplay(), ItemLogicalToOdbc(), ItemNormalize(), ItemSet()
property Reading as %String;
Reading
Property methods: ReadingDisplayToLogical(), ReadingGet(), ReadingGetStored(), ReadingIsValid(), ReadingLogicalToDisplay(), ReadingLogicalToOdbc(), ReadingNormalize(), ReadingSet()
property SampleTime as %String [ Required ];
Date/Time of sample
Property methods: SampleTimeDisplayToLogical(), SampleTimeGet(), SampleTimeGetStored(), SampleTimeIsValid(), SampleTimeLogicalToDisplay(), SampleTimeLogicalToOdbc(), SampleTimeNormalize(), SampleTimeSet()
property Sensor as %String (MAXLEN = 250) [ Required ];
Name of sensor
Property methods: SensorDisplayToLogical(), SensorGet(), SensorGetStored(), SensorIsValid(), SensorLogicalToDisplay(), SensorLogicalToOdbc(), SensorNormalize(), SensorSet()

Methods

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

Queries

query SensorReadings(BeginTime As %String, EndTime As %String)
SQL Query:
SELECT * FROM SensorReading WHERE SampleTime BETWEEN :BeginTime AND :EndTime
Return the sensor data for a given time range
query SensorReadingsBySensor(BeginTime As %String, EndTime As %String, Sensor As %String)
SQL Query:
SELECT * FROM SensorReading WHERE SampleTime BETWEEN :BeginTime AND :EndTime 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.SensorReading)

^ISC.Monitor.SensorReadingD(ID)
=
%%CLASSNAME
Sensor
Item
Rulecode
Severity
Values
Readings
Mean
Sigma
AlertTime
Value
PrevState
State
AlertTime
FirstAlertTime
Msg

Storage Model: CacheStorage (%SYS.Monitor.SensorReading)

^ISC.Monitor.SensorReadingD(ID,"1")
=
Reading
SampleTime
Notification
FeedbackOpens in a new tab