Share

Read next article:

"Reduce WUG Database Size"

Read previous article:

"Delete Default Device States"

Change Alert Center Threshold Description

In Default | 0 comments

Threshold description couldn’t be edited from Web Interface but we have to use SQL queries. The operation is divided into 2 parts.

  1. The first: Get information about all configured Alert Center thresholds
  2. The second: Update the required threshold

Get information about all configured threshold
We will use the following query to get the information about all Alert Center thresholds.

SELECT nProActiveAlertID, sAlertName, sAlertDescription FROM ProActiveAlert

Update threshold
We should select the required threshold to update, we will use nProActiveAlertID to filter the results.

UPDATE ProActiveAlert
SET sAlertDescription = 'New_Alert_Description'
WHERE nProActiveAlertID = 10

Notes:

  1. New_Alert_Description should be replaced with the required description of the threshold.
  2. ’10’ is the ID of the value we are going to change.

 

Share on Facebook0Tweet about this on TwitterShare on Google+0Share on LinkedIn0Pin on Pinterest0

Leave a Reply

Allowed Tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

four × three =

Facebook

Unable to display Facebook posts.
Show error

Error: Unsupported get request. Object with ID 'orchtechsoftwarehouse' does not exist, cannot be loaded due to missing permissions, or does not support this operation. Please read the Graph API documentation at https://developers.facebook.com/docs/graph-api
Type: GraphMethodException
Code: 100
Subcode: 33
Please refer to our Error Message Reference.