Print Page - Database - where threshold is error?

Title: Database - where threshold is error?
Post by: TICK_TEL on March 06, 2019, 01:06:26 PM

Hi all.

I was looking for the threshold column in the database (OK or an Error). I know the table 'thresoholds' exists in the NetXMS database but I'm not sure if this is what I need?
(https://i.imgur.com/Xhlh24r.png)

I can see the column current_state is in there which I what I presume either means Ok when 0 and error when 1.

Can someone confirm for me please?

Title: Re: Database - where threshold is error?
Post by: TICK_TEL on March 06, 2019, 01:40:02 PM

So looks like I'm right. The current_state changes to 1 when the threshold in fire_value is hit or less than.

Any ideas how I can join from the Threshold table to Nodes?

Title: Re: Database - where threshold is error?
Post by: Victor Kirhenshtein on March 20, 2019, 08:06:35 PM

Hi,

Threshold table has reference to DCI table (items) via item_id column which in turn has reference to owning node (via node_id column).

Best regards,
Victor

NetXMS Support Forum

English Support => General Support => Topic started by: TICK_TEL on March 06, 2019, 01:06:26 PM