Author: Paddy Murphy

Threshold alarms allow a user to set a threshold on any Nova variable. If the threshold value is breached a ticket will be automatically generated.

select
	tr.id,
	e.entry_point_id,
	t.discovered_name,
	t.technology,
	e.technology_version,
	e.on_air,
	tr.operator ,
	tr. parameter_key,
	t.alarm_level,
	tr.value,
	tr.breached
from
	orchestrator.threshold_rule tr
join orchestrator.threshold t on
	t.simple_threshold_rule_id = tr.id
join orchestrator.element e on
	e.id = t.element_id;

See table relationship below:

Use entry_point_id to find orchestrator.element ID.

select * from orchestrator.element where entry_point_id = < network element id>;

List all threshold settings for a controller.

select * from orchestrator.threshold where element_id =  <element id>;

List threshold rules

select * from orchestrator.threshold_rule where id <simple_threshold_rule_id>;

To delete a threshold the relevant orchestrator.threshold entry must be removed first because of a foreign key constraint with the .threshold_rule table. The relevant threshold rule can then be deleted.