NetXMS Support Forum

Please login or register.

Login with username, password and session length

Author Topic: Database - where threshold is error?  (Read 82 times)

TICK_TEL

  • Newbie
  • *
  • Posts: 8
    • View Profile
Database - where threshold is error?
« 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?


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?
Logged

TICK_TEL

  • Newbie
  • *
  • Posts: 8
    • View Profile
Re: Database - where threshold is error?
« Reply #1 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?
Logged

Victor Kirhenshtein

  • Lead Developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 6471
    • View Profile
Re: Database - where threshold is error?
« Reply #2 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
Logged