Close Window

How to:
Edit Alarms from ICW and Database
Skill required to complete this article: Software ~ ICW 2 and level is Novice.

There are two way to edits alarms and change their information as shown in the Alarms Viewer on ICW.

First, find the Alarm ID for the alarm/device you would like to make changes on. This will make the search for the alarm much easier. You can find the alarm ID on Alarm Viewer screen on ICW. It should be in the left most column as shown below

 

Go to "Alarm Editor" window (note, this may not always available on ICW window, you may need to add it from project views).

Find the alarm ID from the list. On the right window, it will display information such as Description, Severity, etc. You can edit the information here and save them. Note that changes here will update the same alarm ID in the database "AlarmList" table.

 

 

If you want to make changes directly from Database, follow the steps below.

On SQL server, connect to Microsoft SQL Server Management Studio. Go to "ICWProject" database, expand "Tables" folder, and find AlarmList table.

 

You can use your own query script or right click and "Select Top 1000 Rows" and filter from there. Below I am using the latter option and filtering with alarm ID

 

 

 

To update the row, you will need to run a new query. Use the example below

 

In this example I am changing the severity of the alarm to status "2". Make sure the identifier (AlarmID in this case) is unique to the row, or else it will update all rows that have the same value.

 

You can do one or the other. Updating from ICW (which is the easier, faster, and safer method) will update the database, and vice versa. Once updated, the new alarm information should come up on Alarm viewer if the alarm is triggered.

 Related Articles
No Related Articles Available.
 Article Info
 Article ID:  KB-12676
 Published on  11/14/2024
 Last Modified on  11/14/2024
 Last Modified by  Aziz Altamimi
 Original URL:  https://dashboard.intelligrated.com//Knowledgebase/Article.aspx?article=51694501-c35a-4c22-a2f6-7fd88d1681f8
Close Window