forked from zampat/icinga2-monitoring-templates
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy path5010b-s2f_cisco_snmp_hw.sql
10 lines (9 loc) · 1.18 KB
/
5010b-s2f_cisco_snmp_hw.sql
1
2
3
4
5
6
7
8
9
10
--
-- Relations Service Template - Director Field
-- For default deployment
--
INSERT IGNORE icinga_service_field (service_id, datafield_id, is_required) VALUES ((select id from icinga_service where object_name = "SNMP_Cisco_HW"),(select id from director_datafield where varname = "snmp_community"),'y');
INSERT IGNORE icinga_service_field (service_id, datafield_id, is_required) VALUES ((select id from icinga_service where object_name = "SNMP_Cisco_HW"),(select id from director_datafield where varname = "snmp_check_type"),'y');
INSERT IGNORE icinga_service_field (service_id, datafield_id, is_required) VALUES ((select id from icinga_service where object_name = "SNMP_Cisco_HW"),(select id from director_datafield where varname = "snmp_interface"),'n');
INSERT IGNORE icinga_service_field (service_id, datafield_id, is_required) VALUES ((select id from icinga_service where object_name = "SNMP_Cisco_HW"),(select id from director_datafield where varname = "snmp_critical"),'n');
INSERT IGNORE icinga_service_field (service_id, datafield_id, is_required) VALUES ((select id from icinga_service where object_name = "SNMP_Cisco_HW"),(select id from director_datafield where varname = "snmp_critical"),'n');