Article: KB-12676
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.
 Help us improve this article...
What did you think of this article?
poor   excellent
Your Email:
Tell us why you rated the content this way. (optional)
RadEditor - HTML WYSIWYG Editor. MS Word-like content editing experience thanks to a rich set of formatting tools, dropdowns, dialogs, system modules and built-in spell-check.
RadEditor's components - toolbar, content area, modes and modules
   
Toolbar's wrapper 
 
Content area wrapper
RadEditor's bottom area: Design, Html and Preview modes, Statistics module and resize handle.
It contains RadEditor's Modes/views (HTML, Design and Preview), Statistics and Resizer
Editor Mode buttonsStatistics moduleEditor resizer
 
 
RadEditor's Modules - special tools used to provide extra information such as Tag Inspector, Real Time HTML Viewer, Tag Properties and other.
   
 

 Comments...
No user comments available for this article.
Published on 11/14/2024.
Last Modified on 11/14/2024.
Last Modified by Aziz Altamimi.
Article has been viewed 29 times.
Rated out 0 of 10 based on 0 votes.
Print Article Print Article