Occasionally, the alarm status on the dashboard will miss a clear event and it is necessary to delete the alarm state from the database in order to fix the problem.  The following procedure steps through this event.

1) Get the Device ID of the problem device by going to the dashboard and hovering the cursor over the link to the device.  The status bar in the lower left corner of the browser will include the device ID at the end of the URL.

Run the following query in Management Studio or probe against EEDB.  Where it says xxxx place the Device ID of the problem device.

select * from eg.event_state where obj_id=xxxx

2) From the query in step 1 you will get an event_id for that device.  Run the following query substituting the event_id for yyyy.  Occasionally there will be more than one event for a device. This step is done in order to verify you are deleting the correct event.  Check the event description to verify it is the event you want to delete.

select * from eg.event where event_id=yyyy

3) Once the event_id is verified, place the event_id in the following query to delete the alarm state.

delete from eg.event_state where event_id=yyyy

--select * from eg.event_state where obj_id=29826155
--select * from eg.event where event_id=78812605
--delete from eg.event_state where event_id=78812605