SQL Server - How to remove stuck alarms

• Related Articles

• 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 - 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 - Testing database connections

  One of the past challenges with troubleshooting SQL database connections has been with having a tool to connect to the SQL database - determining if the port is available on the target server and the service is running. Starting in Windows 10, this ...

• SQL Server - Changing Database Location / Server

  When changing database location / server you will need to update the following files and tables. In the Opendata file structure: database.properties - contains database connection info - Located: C:\Program ...

• 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 ...