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.

 

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>

17 − fourteen =

Facebook

Unable to display Facebook posts.
Show error

Error: (#10) This endpoint requires the 'manage_pages' permission or the 'Page Public Content Access' feature. Refer to https://developers.facebook.com/docs/apps/review/login-permissions#manage-pages and https://developers.facebook.com/docs/apps/review/feature#reference-PAGES_ACCESS for details.
Type: OAuthException
Code: 10
Please refer to our Error Message Reference.