Which database table holds virtual "alert" device data?

[Lomax]

I wanted to clear out some values on a virtual "alert" sensor but I'm unable to find the table which contains the values.

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

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?

[Lomax]

*bump*

[marcpoppleton]

Hi,

I've just found your thread while looking for the same info. I ended up dumping the database and scout the various tables and it turns out the one you're looking for is LightingLog.