SQL Server - Removing a Black Box (Offline) Device from the Dashboard

SQL Server - Removing a Black Box (Offline) Device from the Dashboard

If a device is offline (server can't communicate with it) for more than 15 minutes its icon will turn into a black box with a white question mark inside.  If this device is from a Device Gateway that has been improperly decommissioned you can remove the device from the dashboard in one of two ways.

The recommended method is to go to the Administration > Devices tab and select the device. In the Edit Device window at the lower left, near Reset and Save buttons will be a Delete button.  The Delete button will only appear when the device has been offline for more than 15 minutes. (see image)

  

 If the device is offline as denoted by the Black Box with the question mark and the Delete button does not appear, you can remove the device through the SQL Managment Studio using the following queries.

 

My notes on this procedure are incomplete so it might take some experimenting with the following queries.  I would say the first step is to get the Device ID of the 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.

Put the device_id in behind the = sign and execute.

--select * from eg.prop where device_id= 

This is where my memory and notes fail, but perhaps the queries can help you figure it out.

--select * from eg.prop_val where prop_id= and obj_id=
--select * from eg.prop_val where obj_id=
--delete from eg.prop_val where prop_val_id=
    • Related Articles

    • SQL Server - Removing (1) from Device Names on the Dashboard

      If a duplicate name occurs on one of the Device Gateways the SQL server will add (1) to the end of the name to distinguish it from the original. Once the duplicate naming issue is solved you may want to remove the (1) from the end of the device name. ...
    • SQL Server - Manual Device Deletion

      If you need to remove a device from the dashboard and it is not possible to use the Delete button on the Administration > Devices page, you can do it through SQL Management Studio. Marking a Device as Deleted In Management Studio run the following ...
    • SQL Server - Resetting the Dashboard Admin User Password

      If the Admin user password is changed from default and lost you can reset it through SQL server. Reset Admin password to EE dashboard login 1) Open SQL Management Studio and run the following query. select * from eg.sysuser, 2) Look for the ...
    • SQL Server - Deleting Alarm State to Clear False Alarms from the Dashboard

      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. Removing an alarm state from the DB ...
    • SQL Server - How to remove stuck alarms

      Attached is procedure for removing stuck alarm info from the database manually.