SQL Server - Mass Disabling of Remote Comm. Error / Comm. Error

SQL Server - Mass Disabling of Remote Comm. Error / Comm. Error

Sometimes a customer will want to disable all Remote Communication Errors (RCE) and Communication Errors (CE) on the system for a period of time.  You can do this through the UI on the Administration tab > Devices tab > Alarm and Notification Configuration > Disable By Alarm , but that method is slow since you can only do one device at a time.

To do this for the whole system at once, run the following script in SQL Management Studio to set the RCE and CE for all devices to disabled.

--update eg.point set [IS_COLLECTING]=0 where CODE in('REMOTE_COMM_ERROR', 'COMMUNICATIONS_ERROR')

 

Once the script completes you can run the following to verify it worked.  The following script will show how many devices have RCE and CE enabled.

select COUNT(*) from eg.point where [IS_COLLECTING]=1 and 
CODE in('REMOTE_COMM_ERROR', 'COMMUNICATIONS_ERROR') 

    • Related Articles

    • SQL Server - Fixing Remote Edit Button

      If the Remote Edit button sends you to an error page or the wrong Device Gateway here is how to fix it. Run the following query to generate a complete picture of the tables used to generate the remote edit URLs. select d.name,d.device_id, ...

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