Database - where threshold is error?

Started by TICK_TEL, March 06, 2019, 01:06:26 PM

Previous topic - Next topic

TICK_TEL

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?


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?

TICK_TEL

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?

Victor Kirhenshtein

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