forked from zampat/icinga2-monitoring-templates
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy path2021b-s2f_win_mssql-server.sql
17 lines (13 loc) · 1.52 KB
/
2021b-s2f_win_mssql-server.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
--
-- Relations Service Template - Director Field
-- For default deployment
--
# Services for Windwows SQL Server
# generic_MSSQL
INSERT IGNORE icinga_service_field (service_id, datafield_id, is_required) VALUES ((select id from icinga_service where object_name = "generic_MSSQL"),(select id from director_datafield where varname = "mssql_health_hostname"),"n");
INSERT IGNORE icinga_service_field (service_id, datafield_id, is_required) VALUES ((select id from icinga_service where object_name = "generic_MSSQL"),(select id from director_datafield where varname = "mssql_health_mode"),"y");
INSERT IGNORE icinga_service_field (service_id, datafield_id, is_required) VALUES ((select id from icinga_service where object_name = "generic_MSSQL"),(select id from director_datafield where varname = "mssql_health_password"),"y");
INSERT IGNORE icinga_service_field (service_id, datafield_id, is_required) VALUES ((select id from icinga_service where object_name = "generic_MSSQL"),(select id from director_datafield where varname = "mssql_health_username"),"y");
# MSSQL_Connections
INSERT IGNORE icinga_service_field (service_id, datafield_id, is_required) VALUES ((select id from icinga_service where object_name = "MSSQL_Connections"),(select id from director_datafield where varname = "mssql_health_critical"),"y");
INSERT IGNORE icinga_service_field (service_id, datafield_id, is_required) VALUES ((select id from icinga_service where object_name = "MSSQL_Connections"),(select id from director_datafield where varname = "mssql_health_warning"),"y");