Which database table holds virtual "alert" device data?
Posted: Friday 03 February 2017 2:33
I wanted to clear out some values on a virtual "alert" sensor but I'm unable to find the table which contains the values.
I've looked in Meter, SharedDevices, DeviceStatus, MultiMeter, ToonDevices, Notifications, UserVariables, WOLNodes, Hardware... but no sign of my alert sensor's data. Anyone know where to look?
Code: Select all
sqlite> .tables
BackupLog LightingLog SceneTimers
Cameras Meter Scenes
CamerasActiveDevices Meter_Calendar SetpointTimers
CustomImages MobileDevices SharedDevices
DeviceStatus MultiMeter Temperature
DeviceToPlansMap MultiMeter_Calendar Temperature_Calendar
EnoceanSensors MySensors Timers
EventActions MySensorsChilds ToonDevices
EventMaster MySensorsVars UV
EventRules Notifications UV_Calendar
Fan Percentage UserSessions
Fan_Calendar Percentage_Calendar UserVariables
FibaroLink Plans Users
Floorplans Preferences WOLNodes
GooglePubSubLink Rain Wind
Hardware Rain_Calendar Wind_Calendar
HttpLink SceneDevices ZWaveNodes
LightSubDevices SceneLog