Database - where threshold is error?

[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]

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