Modified: trunk/opsview-core/t/var/configs/Master Monitoring Server/contacts.cfg
===================================================================
--- trunk/opsview-core/t/var/configs/Master Monitoring Server/contacts.cfg 2013-04-25 11:06:19 UTC (rev 12183)
+++ trunk/opsview-core/t/var/configs/Master Monitoring Server/contacts.cfg 2013-04-25 12:22:06 UTC (rev 12184)
@@ -26,7 +26,8 @@
use global-contact
service_notification_period 24x7
host_notification_period 24x7
- notification_level 1
+ notification_level_start 1
+ notification_level_stop 0
contactgroups hostgroup2_servicegroup1,hostgroup4_servicegroup1,hostgroup4_servicegroup2,hostgroup5_servicegroup1,k7_allhosts,k8_allservicechecks
host_notification_options n
service_notification_options n
@@ -56,7 +57,8 @@
use global-contact
service_notification_period 24x7
host_notification_period 24x7
- notification_level 1
+ notification_level_start 1
+ notification_level_stop 0
contactgroups hostgroup2_servicegroup1,hostgroup4_servicegroup1,hostgroup4_servicegroup2,hostgroup5_servicegroup1
_RSS_COLLAPSED 1
_RSS_MAXIMUM_AGE 1440
@@ -74,7 +76,8 @@
use global-contact
service_notification_period 24x7
host_notification_period 24x7
- notification_level 1
+ notification_level_start 1
+ notification_level_stop 0
contactgroups hostgroup4_servicegroup1
host_notification_options n
service_notification_options n
@@ -87,7 +90,8 @@
use global-contact
service_notification_period 24x7
host_notification_period 24x7
- notification_level 1
+ notification_level_start 1
+ notification_level_stop 0
contactgroups hostgroup2_servicegroup1,hostgroup4_servicegroup1,hostgroup4_servicegroup2,hostgroup5_servicegroup1
host_notification_options n
service_notification_options n
@@ -117,7 +121,8 @@
use global-contact
service_notification_period 24x7
host_notification_period 24x7
- notification_level 1
+ notification_level_start 1
+ notification_level_stop 0
contactgroups hostgroup2_servicegroup1,hostgroup4_servicegroup1,hostgroup4_servicegroup2,hostgroup5_servicegroup1
email t...@dummy.com
pager 1234
@@ -146,7 +151,8 @@
use global-contact
service_notification_period nonworkhours
host_notification_period nonworkhours
- notification_level 1
+ notification_level_start 1
+ notification_level_stop 0
contactgroups hostgroup5_servicegroup1
host_notification_options n
service_notification_options n
@@ -159,7 +165,8 @@
use global-contact
service_notification_period 24x7
host_notification_period 24x7
- notification_level 1
+ notification_level_start 1
+ notification_level_stop 0
contactgroups hostgroup5_servicegroup1
_RSS_COLLAPSED 1
_RSS_MAXIMUM_AGE 1440
@@ -186,7 +193,8 @@
use global-contact
service_notification_period 24x7
host_notification_period 24x7
- notification_level 1
+ notification_level_start 1
+ notification_level_stop 0
contactgroups hostgroup2_servicegroup1,hostgroup4_servicegroup1,hostgroup4_servicegroup2,hostgroup5_servicegroup1
_RSS_COLLAPSED 1
_RSS_MAXIMUM_AGE 1440
@@ -213,7 +221,8 @@
use global-contact
service_notification_period 24x7
host_notification_period 24x7
- notification_level 1
+ notification_level_start 1
+ notification_level_stop 0
contactgroups hostgroup2_servicegroup1,hostgroup4_servicegroup1,hostgroup4_servicegroup2,hostgroup5_servicegroup1
_RSS_COLLAPSED 1
_RSS_MAXIMUM_AGE 1440
@@ -240,7 +249,8 @@
use global-contact
service_notification_period nonworkhours
host_notification_period nonworkhours
- notification_level 1
+ notification_level_start 1
+ notification_level_stop 0
contactgroups k2_cisco
pager 000
host_notification_commands notify-by-aql
@@ -257,7 +267,8 @@
use global-contact
service_notification_period 24x7
host_notification_period 24x7
- notification_level 1
+ notification_level_start 1
+ notification_level_stop 0
contactgroups k2_cisco
_RSS_COLLAPSED 1
_RSS_MAXIMUM_AGE 1440
@@ -285,7 +296,8 @@
use global-contact
service_notification_period 24x7
host_notification_period 24x7
- notification_level 1
+ notification_level_start 1
+ notification_level_stop 0
contactgroups k2_cisco
can_submit_commands 0
}
@@ -306,7 +318,8 @@
use global-contact
service_notification_period 24x7
host_notification_period 24x7
- notification_level 1
+ notification_level_start 1
+ notification_level_stop 0
contactgroups hostgroup4_servicegroup1,hostgroup5_servicegroup1
pager 010101
_RSS_COLLAPSED 0
@@ -335,7 +348,8 @@
use global-contact
service_notification_period 24x7
host_notification_period 24x7
- notification_level 1
+ notification_level_start 1
+ notification_level_stop 0
contactgroups hostgroup4_servicegroup1,hostgroup5_servicegroup1
can_submit_commands 0
}
Modified: trunk/opsview-core/t/var/configs/Master Monitoring Server/objects.cache
===================================================================
--- trunk/opsview-core/t/var/configs/Master Monitoring Server/objects.cache 2013-04-25 11:06:19 UTC (rev 12183)
+++ trunk/opsview-core/t/var/configs/Master Monitoring Server/objects.cache 2013-04-25 12:22:06 UTC (rev 12184)
@@ -688,7 +688,8 @@
host_notifications_enabled 1
service_notifications_enabled 1
can_submit_commands 1
- notification_level 1
+ notification_level_start 1
+ notification_level_stop 0
retain_status_information 1
retain_nonstatus_information 1
}
@@ -707,7 +708,8 @@
host_notifications_enabled 1
service_notifications_enabled 1
can_submit_commands 1
- notification_level 1
+ notification_level_start 1
+ notification_level_stop 0
retain_status_information 1
retain_nonstatus_information 1
}
@@ -726,7 +728,8 @@
host_notifications_enabled 1
service_notifications_enabled 1
can_submit_commands 0
- notification_level 1
+ notification_level_start 1
+ notification_level_stop 0
retain_status_information 1
retain_nonstatus_information 1
}
@@ -745,7 +748,8 @@
host_notifications_enabled 1
service_notifications_enabled 1
can_submit_commands 1
- notification_level 1
+ notification_level_start 1
+ notification_level_stop 0
retain_status_information 1
retain_nonstatus_information 1
}
@@ -764,7 +768,8 @@
host_notifications_enabled 1
service_notifications_enabled 1
can_submit_commands 1
- notification_level 1
+ notification_level_start 1
+ notification_level_stop 0
retain_status_information 1
retain_nonstatus_information 1
_RSS_COLLAPSED 1
@@ -786,7 +791,8 @@
host_notifications_enabled 1
service_notifications_enabled 1
can_submit_commands 1
- notification_level 1
+ notification_level_start 1
+ notification_level_stop 0
retain_status_information 1
retain_nonstatus_information 1
}
@@ -805,7 +811,8 @@
host_notifications_enabled 1
service_notifications_enabled 1
can_submit_commands 1
- notification_level 1
+ notification_level_start 1
+ notification_level_stop 0
retain_status_information 1
retain_nonstatus_information 1
}
@@ -824,7 +831,8 @@
host_notifications_enabled 1
service_notifications_enabled 1
can_submit_commands 1
- notification_level 1
+ notification_level_start 1
+ notification_level_stop 0
retain_status_information 1
retain_nonstatus_information 1
}
@@ -843,7 +851,8 @@
host_notifications_enabled 1
service_notifications_enabled 1
can_submit_commands 0
- notification_level 1
+ notification_level_start 1
+ notification_level_stop 0
retain_status_information 1
retain_nonstatus_information 1
}
@@ -863,7 +872,8 @@
host_notifications_enabled 1
service_notifications_enabled 1
can_submit_commands 0
- notification_level 1
+ notification_level_start 1
+ notification_level_stop 0
retain_status_information 1
retain_nonstatus_information 1
_RSS_COLLAPSED 1
@@ -885,7 +895,8 @@
host_notifications_enabled 1
service_notifications_enabled 1
can_submit_commands 1
- notification_level 1
+ notification_level_start 1
+ notification_level_stop 0
retain_status_information 1
retain_nonstatus_information 1
}
@@ -904,7 +915,8 @@
host_notifications_enabled 1
service_notifications_enabled 1
can_submit_commands 1
- notification_level 1
+ notification_level_start 1
+ notification_level_stop 0
retain_status_information 1
retain_nonstatus_information 1
}
@@ -923,7 +935,8 @@
host_notifications_enabled 1
service_notifications_enabled 1
can_submit_commands 1
- notification_level 1
+ notification_level_start 1
+ notification_level_stop 0
retain_status_information 1
retain_nonstatus_information 1
_RSS_COLLAPSED 1
@@ -945,7 +958,8 @@
host_notifications_enabled 1
service_notifications_enabled 1
can_submit_commands 0
- notification_level 1
+ notification_level_start 1
+ notification_level_stop 0
retain_status_information 1
retain_nonstatus_information 1
}
@@ -964,7 +978,8 @@
host_notifications_enabled 1
service_notifications_enabled 1
can_submit_commands 0
- notification_level 1
+ notification_level_start 1
+ notification_level_stop 0
retain_status_information 1
retain_nonstatus_information 1
_RSS_COLLAPSED 1
@@ -986,7 +1001,8 @@
host_notifications_enabled 1
service_notifications_enabled 1
can_submit_commands 1
- notification_level 1
+ notification_level_start 1
+ notification_level_stop 0
retain_status_information 1
retain_nonstatus_information 1
}
@@ -1005,7 +1021,8 @@
host_notifications_enabled 1
service_notifications_enabled 1
can_submit_commands 1
- notification_level 1
+ notification_level_start 1
+ notification_level_stop 0
retain_status_information 1
retain_nonstatus_information 1
_RSS_COLLAPSED 1
@@ -1027,7 +1044,8 @@
host_notifications_enabled 1
service_notifications_enabled 1
can_submit_commands 0
- notification_level 1
+ notification_level_start 1
+ notification_level_stop 0
retain_status_information 1
retain_nonstatus_information 1
}
@@ -1047,7 +1065,8 @@
host_notifications_enabled 1
service_notifications_enabled 1
can_submit_commands 0
- notification_level 1
+ notification_level_start 1
+ notification_level_stop 0
retain_status_information 1
retain_nonstatus_information 1
}
@@ -1066,7 +1085,8 @@
host_notifications_enabled 1
service_notifications_enabled 1
can_submit_commands 0
- notification_level 1
+ notification_level_start 1
+ notification_level_stop 0
retain_status_information 1
retain_nonstatus_information 1
_RSS_COLLAPSED 1
@@ -1088,7 +1108,8 @@
host_notifications_enabled 1
service_notifications_enabled 1
can_submit_commands 0
- notification_level 1
+ notification_level_start 1
+ notification_level_stop 0
retain_status_information 1
retain_nonstatus_information 1
}
@@ -1107,7 +1128,8 @@
host_notifications_enabled 1
service_notifications_enabled 1
can_submit_commands 0
- notification_level 1
+ notification_level_start 1
+ notification_level_stop 0
retain_status_information 1
retain_nonstatus_information 1
}
@@ -1126,7 +1148,8 @@
host_notifications_enabled 1
service_notifications_enabled 1
can_submit_commands 0
- notification_level 1
+ notification_level_start 1
+ notification_level_stop 0
retain_status_information 1
retain_nonstatus_information 1
}
@@ -1146,7 +1169,8 @@
host_notifications_enabled 1
service_notifications_enabled 1
can_submit_commands 0
- notification_level 1
+ notification_level_start 1
+ notification_level_stop 0
retain_status_information 1
retain_nonstatus_information 1
_RSS_COLLAPSED 0
@@ -1168,7 +1192,8 @@
host_notifications_enabled 1
service_notifications_enabled 1
can_submit_commands 0
- notification_level 1
+ notification_level_start 1
+ notification_level_stop 0
retain_status_information 1
retain_nonstatus_information 1
}
@@ -1187,7 +1212,8 @@
host_notifications_enabled 1
service_notifications_enabled 1
can_submit_commands 0
- notification_level 1
+ notification_level_start 1
+ notification_level_stop 0
retain_status_information 1
retain_nonstatus_information 1
}
Modified: trunk/opsview-core/t/var/configs/dbic_trace
===================================================================
--- trunk/opsview-core/t/var/configs/dbic_trace 2013-04-25 11:06:19 UTC (rev 12183)
+++ trunk/opsview-core/t/var/configs/dbic_trace 2013-04-25 12:22:06 UTC (rev 12184)
@@ -210,8 +210,8 @@
SELECT me.id FROM opsview.servicegroups me ORDER BY name:
SELECT me.id FROM opsview.hostgroups me WHERE ( rgt = lft+1 ) ORDER BY name, id:
SELECT keywordid.id, keywordid.name FROM opsview.role_access_keywords me JOIN opsview.keywords keywordid ON keywordid.id = me.keywordid WHERE ( me.roleid = ? ) ORDER BY name: '10'
-SELECT me.id, me.name, me.contactid, me.host_notification_options, me.service_notification_options, me.notification_period, me.all_hostgroups, me.all_servicegroups, me.all_keywords, me.notification_level, me.priority, me.uncommitted FROM opsview.notificationprofiles me WHERE ( me.contactid = ? ) ORDER BY priority, id: '1'
-SELECT sharednotificationprofileid.id, sharednotificationprofileid.name, sharednotificationprofileid.host_notification_options, sharednotificationprofileid.service_notification_options, sharednotificationprofileid.notification_period, sharednotificationprofileid.all_hostgroups, sharednotificationprofileid.all_servicegroups, sharednotificationprofileid.all_keywords, sharednotificationprofileid.notification_level, sharednotificationprofileid.role, sharednotificationprofileid.uncommitted FROM opsview.contact_sharednotificationprofile me JOIN opsview.sharednotificationprofiles sharednotificationprofileid ON sharednotificationprofileid.id = me.sharednotificationprofileid WHERE ( me.contactid = ? ) ORDER BY name: '1'
+SELECT me.id, me.name, me.contactid, me.host_notification_options, me.service_notification_options, me.notification_period, me.all_hostgroups, me.all_servicegroups, me.all_keywords, me.notification_level, me.priority, me.uncommitted, me.notification_level_stop FROM opsview.notificationprofiles me WHERE ( me.contactid = ? ) ORDER BY priority, id: '1'
+SELECT sharednotificationprofileid.id, sharednotificationprofileid.name, sharednotificationprofileid.host_notification_options, sharednotificationprofileid.service_notification_options, sharednotificationprofileid.notification_period, sharednotificationprofileid.all_hostgroups, sharednotificationprofileid.all_servicegroups, sharednotificationprofileid.all_keywords, sharednotificationprofileid.notification_level, sharednotificationprofileid.role, sharednotificationprofileid.uncommitted, sharednotificationprofileid.notification_level_stop FROM opsview.contact_sharednotificationprofile me JOIN opsview.sharednotificationprofiles sharednotificationprofileid ON sharednotificationprofileid.id = me.sharednotificationprofileid WHERE ( me.contactid = ? ) ORDER BY name: '1'
SELECT me.id, me.name, me.description, me.priority, me.all_hostgroups, me.all_servicegroups, me.all_keywords, me.uncommitted FROM opsview.roles me WHERE ( me.id = ? ): '10'
SELECT me.id FROM opsview.hostgroups me WHERE ( rgt = lft+1 ) ORDER BY name, id:
SELECT me.id FROM opsview.servicegroups me ORDER BY name:
@@ -224,8 +224,8 @@
SELECT me.id FROM opsview.servicegroups me ORDER BY name:
SELECT me.id FROM opsview.hostgroups me WHERE ( rgt = lft+1 ) ORDER BY name, id:
SELECT keywordid.id, keywordid.name FROM opsview.role_access_keywords me JOIN opsview.keywords keywordid ON keywordid.id = me.keywordid WHERE ( me.roleid = ? ) ORDER BY name: '16'
-SELECT me.id, me.name, me.contactid, me.host_notification_options, me.service_notification_options, me.notification_period, me.all_hostgroups, me.all_servicegroups, me.all_keywords, me.notification_level, me.priority, me.uncommitted FROM opsview.notificationprofiles me WHERE ( me.contactid = ? ) ORDER BY priority, id: '12'
-SELECT sharednotificationprofileid.id, sharednotificationprofileid.name, sharednotificationprofileid.host_notification_options, sharednotificationprofileid.service_notification_options, sharednotificationprofileid.notification_period, sharednotificationprofileid.all_hostgroups, sharednotificationprofileid.all_servicegroups, sharednotificationprofileid.all_keywords, sharednotificationprofileid.notification_level, sharednotificationprofileid.role, sharednotificationprofileid.uncommitted FROM opsview.contact_sharednotificationprofile me JOIN opsview.sharednotificationprofiles sharednotificationprofileid ON sharednotificationprofileid.id = me.sharednotificationprofileid WHERE ( me.contactid = ? ) ORDER BY name: '12'
+SELECT me.id, me.name, me.contactid, me.host_notification_options, me.service_notification_options, me.notification_period, me.all_hostgroups, me.all_servicegroups, me.all_keywords, me.notification_level, me.priority, me.uncommitted, me.notification_level_stop FROM opsview.notificationprofiles me WHERE ( me.contactid = ? ) ORDER BY priority, id: '12'
+SELECT sharednotificationprofileid.id, sharednotificationprofileid.name, sharednotificationprofileid.host_notification_options, sharednotificationprofileid.service_notification_options, sharednotificationprofileid.notification_period, sharednotificationprofileid.all_hostgroups, sharednotificationprofileid.all_servicegroups, sharednotificationprofileid.all_keywords, sharednotificationprofileid.notification_level, sharednotificationprofileid.role, sharednotificationprofileid.uncommitted, sharednotificationprofileid.notification_level_stop FROM opsview.contact_sharednotificationprofile me JOIN opsview.sharednotificationprofiles sharednotificationprofileid ON sharednotificationprofileid.id = me.sharednotificationprofileid WHERE ( me.contactid = ? ) ORDER BY name: '12'
SELECT me.id, me.name, me.description, me.priority, me.all_hostgroups, me.all_servicegroups, me.all_keywords, me.uncommitted FROM opsview.roles me WHERE ( me.id = ? ): '17'
SELECT me.id, me.name FROM opsview.access me LEFT JOIN opsview.roles_access roles_accesses ON roles_accesses.accessid = me.id WHERE ( ( roles_accesses.roleid = ? OR roles_accesses.roleid = ? ) ) ORDER BY name ASC: '17', '2'
SELECT me.id, me.name, me.description, me.priority, me.all_hostgroups, me.all_servicegroups, me.all_keywords, me.uncommitted FROM opsview.roles me WHERE ( me.id = ? ): '21'
@@ -235,8 +235,8 @@
SELECT me.id FROM opsview.servicegroups me ORDER BY name:
SELECT me.id FROM opsview.hostgroups me WHERE ( rgt = lft+1 ) ORDER BY name, id:
SELECT keywordid.id, keywordid.name FROM opsview.role_access_keywords me JOIN opsview.keywords keywordid ON keywordid.id = me.keywordid WHERE ( me.roleid = ? ) ORDER BY name: '12'
-SELECT me.id, me.name, me.contactid, me.host_notification_options, me.service_notification_options, me.notification_period, me.all_hostgroups, me.all_servicegroups, me.all_keywords, me.notification_level, me.priority, me.uncommitted FROM opsview.notificationprofiles me WHERE ( me.contactid = ? ) ORDER BY priority, id: '2'
-SELECT sharednotificationprofileid.id, sharednotificationprofileid.name, sharednotificationprofileid.host_notification_options, sharednotificationprofileid.service_notification_options, sharednotificationprofileid.notification_period, sharednotificationprofileid.all_hostgroups, sharednotificationprofileid.all_servicegroups, sharednotificationprofileid.all_keywords, sharednotificationprofileid.notification_level, sharednotificationprofileid.role, sharednotificationprofileid.uncommitted FROM opsview.contact_sharednotificationprofile me JOIN opsview.sharednotificationprofiles sharednotificationprofileid ON sharednotificationprofileid.id = me.sharednotificationprofileid WHERE ( me.contactid = ? ) ORDER BY name: '2'
+SELECT me.id, me.name, me.contactid, me.host_notification_options, me.service_notification_options, me.notification_period, me.all_hostgroups, me.all_servicegroups, me.all_keywords, me.notification_level, me.priority, me.uncommitted, me.notification_level_stop FROM opsview.notificationprofiles me WHERE ( me.contactid = ? ) ORDER BY priority, id: '2'
+SELECT sharednotificationprofileid.id, sharednotificationprofileid.name, sharednotificationprofileid.host_notification_options, sharednotificationprofileid.service_notification_options, sharednotificationprofileid.notification_period, sharednotificationprofileid.all_hostgroups, sharednotificationprofileid.all_servicegroups, sharednotificationprofileid.all_keywords, sharednotificationprofileid.notification_level, sharednotificationprofileid.role, sharednotificationprofileid.uncommitted, sharednotificationprofileid.notification_level_stop FROM opsview.contact_sharednotificationprofile me JOIN opsview.sharednotificationprofiles sharednotificationprofileid ON sharednotificationprofileid.id = me.sharednotificationprofileid WHERE ( me.contactid = ? ) ORDER BY name: '2'
SELECT me.id, me.fullname, me.name, me.realm, me.encrypted_password, me.language, me.description, me.role, me.show_welcome_page, me.uncommitted FROM opsview.contacts me WHERE ( me.id = ? ) ORDER BY name: '2'
SELECT me.id, me.name, me.description, me.priority, me.all_hostgroups, me.all_servicegroups, me.all_keywords, me.uncommitted FROM opsview.roles me WHERE ( me.id = ? ): '12'
SELECT me.id FROM opsview.hostgroups me WHERE ( rgt = lft+1 ) ORDER BY name, id:
@@ -263,15 +263,15 @@
SELECT me.id FROM opsview.servicegroups me ORDER BY name:
SELECT me.id FROM opsview.hostgroups me WHERE ( rgt = lft+1 ) ORDER BY name, id:
SELECT keywordid.id, keywordid.name FROM opsview.role_access_keywords me JOIN opsview.keywords keywordid ON keywordid.id = me.keywordid WHERE ( me.roleid = ? ) ORDER BY name: '12'
-SELECT me.id, me.name, me.contactid, me.host_notification_options, me.service_notification_options, me.notification_period, me.all_hostgroups, me.all_servicegroups, me.all_keywords, me.notification_level, me.priority, me.uncommitted FROM opsview.notificationprofiles me WHERE ( me.contactid = ? ) ORDER BY priority, id: '5'
-SELECT sharednotificationprofileid.id, sharednotificationprofileid.name, sharednotificationprofileid.host_notification_options, sharednotificationprofileid.service_notification_options, sharednotificationprofileid.notification_period, sharednotificationprofileid.all_hostgroups, sharednotificationprofileid.all_servicegroups, sharednotificationprofileid.all_keywords, sharednotificationprofileid.notification_level, sharednotificationprofileid.role, sharednotificationprofileid.uncommitted FROM opsview.contact_sharednotificationprofile me JOIN opsview.sharednotificationprofiles sharednotificationprofileid ON sharednotificationprofileid.id = me.sharednotificationprofileid WHERE ( me.contactid = ? ) ORDER BY name: '5'
+SELECT me.id, me.name, me.contactid, me.host_notification_options, me.service_notification_options, me.notification_period, me.all_hostgroups, me.all_servicegroups, me.all_keywords, me.notification_level, me.priority, me.uncommitted, me.notification_level_stop FROM opsview.notificationprofiles me WHERE ( me.contactid = ? ) ORDER BY priority, id: '5'
+SELECT sharednotificationprofileid.id, sharednotificationprofileid.name, sharednotificationprofileid.host_notification_options, sharednotificationprofileid.service_notification_options, sharednotificationprofileid.notification_period, sharednotificationprofileid.all_hostgroups, sharednotificationprofileid.all_servicegroups, sharednotificationprofileid.all_keywords, sharednotificationprofileid.notification_level, sharednotificationprofileid.role, sharednotificationprofileid.uncommitted, sharednotificationprofileid.notification_level_stop FROM opsview.contact_sharednotificationprofile me JOIN opsview.sharednotificationprofiles sharednotificationprofileid ON sharednotificationprofileid.id = me.sharednotificationprofileid WHERE ( me.contactid = ? ) ORDER BY name: '5'
SELECT me.id, me.name, me.description, me.priority, me.all_hostgroups, me.all_servicegroups, me.all_keywords, me.uncommitted FROM opsview.roles me WHERE ( me.id = ? ): '13'
SELECT me.id, me.name FROM opsview.access me LEFT JOIN opsview.roles_access roles_accesses ON roles_accesses.accessid = me.id WHERE ( ( roles_accesses.roleid = ? OR roles_accesses.roleid = ? ) ) ORDER BY name ASC: '13', '2'
SELECT me.id FROM opsview.servicegroups me ORDER BY name:
SELECT me.id FROM opsview.hostgroups me WHERE ( rgt = lft+1 ) ORDER BY name, id:
SELECT keywordid.id, keywordid.name FROM opsview.role_access_keywords me JOIN opsview.keywords keywordid ON keywordid.id = me.keywordid WHERE ( me.roleid = ? ) ORDER BY name: '13'
-SELECT me.id, me.name, me.contactid, me.host_notification_options, me.service_notification_options, me.notification_period, me.all_hostgroups, me.all_servicegroups, me.all_keywords, me.notification_level, me.priority, me.uncommitted FROM opsview.notificationprofiles me WHERE ( me.contactid = ? ) ORDER BY priority, id: '3'
-SELECT sharednotificationprofileid.id, sharednotificationprofileid.name, sharednotificationprofileid.host_notification_options, sharednotificationprofileid.service_notification_options, sharednotificationprofileid.notification_period, sharednotificationprofileid.all_hostgroups, sharednotificationprofileid.all_servicegroups, sharednotificationprofileid.all_keywords, sharednotificationprofileid.notification_level, sharednotificationprofileid.role, sharednotificationprofileid.uncommitted FROM opsview.contact_sharednotificationprofile me JOIN opsview.sharednotificationprofiles sharednotificationprofileid ON sharednotificationprofileid.id = me.sharednotificationprofileid WHERE ( me.contactid = ? ) ORDER BY name: '3'
+SELECT me.id, me.name, me.contactid, me.host_notification_options, me.service_notification_options, me.notification_period, me.all_hostgroups, me.all_servicegroups, me.all_keywords, me.notification_level, me.priority, me.uncommitted, me.notification_level_stop FROM opsview.notificationprofiles me WHERE ( me.contactid = ? ) ORDER BY priority, id: '3'
+SELECT sharednotificationprofileid.id, sharednotificationprofileid.name, sharednotificationprofileid.host_notification_options, sharednotificationprofileid.service_notification_options, sharednotificationprofileid.notification_period, sharednotificationprofileid.all_hostgroups, sharednotificationprofileid.all_servicegroups, sharednotificationprofileid.all_keywords, sharednotificationprofileid.notification_level, sharednotificationprofileid.role, sharednotificationprofileid.uncommitted, sharednotificationprofileid.notification_level_stop FROM opsview.contact_sharednotificationprofile me JOIN opsview.sharednotificationprofiles sharednotificationprofileid ON sharednotificationprofileid.id = me.sharednotificationprofileid WHERE ( me.contactid = ? ) ORDER BY name: '3'
SELECT me.id, me.fullname, me.name, me.realm, me.encrypted_password, me.language, me.description, me.role, me.show_welcome_page, me.uncommitted FROM opsview.contacts me WHERE ( me.id = ? ) ORDER BY name: '3'
SELECT me.id, me.name, me.description, me.priority, me.all_hostgroups, me.all_servicegroups, me.all_keywords, me.uncommitted FROM opsview.roles me WHERE ( me.id = ? ): '13'
SELECT me.id FROM opsview.hostgroups me WHERE ( rgt = lft+1 ) ORDER BY name, id:
@@ -285,8 +285,8 @@
SELECT me.id FROM opsview.servicegroups me ORDER BY name:
SELECT hostgroupid.id FROM opsview.role_access_hostgroups me JOIN opsview.hostgroups hostgroupid ON hostgroupid.id = me.hostgroupid WHERE ( me.roleid = ? ) ORDER BY name, id: '18'
SELECT keywordid.id, keywordid.name FROM opsview.role_access_keywords me JOIN opsview.keywords keywordid ON keywordid.id = me.keywordid WHERE ( me.roleid = ? ) ORDER BY name: '18'
-SELECT me.id, me.name, me.contactid, me.host_notification_options, me.service_notification_options, me.notification_period, me.all_hostgroups, me.all_servicegroups, me.all_keywords, me.notification_level, me.priority, me.uncommitted FROM opsview.notificationprofiles me WHERE ( me.contactid = ? ) ORDER BY priority, id: '4'
-SELECT sharednotificationprofileid.id, sharednotificationprofileid.name, sharednotificationprofileid.host_notification_options, sharednotificationprofileid.service_notification_options, sharednotificationprofileid.notification_period, sharednotificationprofileid.all_hostgroups, sharednotificationprofileid.all_servicegroups, sharednotificationprofileid.all_keywords, sharednotificationprofileid.notification_level, sharednotificationprofileid.role, sharednotificationprofileid.uncommitted FROM opsview.contact_sharednotificationprofile me JOIN opsview.sharednotificationprofiles sharednotificationprofileid ON sharednotificationprofileid.id = me.sharednotificationprofileid WHERE ( me.contactid = ? ) ORDER BY name: '4'
+SELECT me.id, me.name, me.contactid, me.host_notification_options, me.service_notification_options, me.notification_period, me.all_hostgroups, me.all_servicegroups, me.all_keywords, me.notification_level, me.priority, me.uncommitted, me.notification_level_stop FROM opsview.notificationprofiles me WHERE ( me.contactid = ? ) ORDER BY priority, id: '4'
+SELECT sharednotificationprofileid.id, sharednotificationprofileid.name, sharednotificationprofileid.host_notification_options, sharednotificationprofileid.service_notification_options, sharednotificationprofileid.notification_period, sharednotificationprofileid.all_hostgroups, sharednotificationprofileid.all_servicegroups, sharednotificationprofileid.all_keywords, sharednotificationprofileid.notification_level, sharednotificationprofileid.role, sharednotificationprofileid.uncommitted, sharednotificationprofileid.notification_level_stop FROM opsview.contact_sharednotificationprofile me JOIN opsview.sharednotificationprofiles sharednotificationprofileid ON sharednotificationprofileid.id = me.sharednotificationprofileid WHERE ( me.contactid = ? ) ORDER BY name: '4'
SELECT hostgroup.id FROM opsview.notificationprofile_hostgroups me JOIN opsview.hostgroups hostgroup ON hostgroup.id = me.hostgroupid WHERE ( me.notificationprofileid = ? ) ORDER BY name, id: '12'
SELECT servicegroup.id FROM opsview.notificationprofile_servicegroups me JOIN opsview.servicegroups servicegroup ON servicegroup.id = me.servicegroupid WHERE ( me.notificationprofileid = ? ) ORDER BY name: '12'
SELECT keyword.id, keyword.name FROM opsview.notificationprofile_keywords me JOIN opsview.keywords keyword ON keyword.id = me.keywordid WHERE ( me.notificationprofileid = ? ) ORDER BY name: '12'
@@ -306,8 +306,8 @@
SELECT me.id FROM opsview.servicegroups me ORDER BY name:
SELECT me.id FROM opsview.hostgroups me WHERE ( rgt = lft+1 ) ORDER BY name, id:
SELECT keywordid.id, keywordid.name FROM opsview.role_access_keywords me JOIN opsview.keywords keywordid ON keywordid.id = me.keywordid WHERE ( me.roleid = ? ) ORDER BY name: '13'
-SELECT me.id, me.name, me.contactid, me.host_notification_options, me.service_notification_options, me.notification_period, me.all_hostgroups, me.all_servicegroups, me.all_keywords, me.notification_level, me.priority, me.uncommitted FROM opsview.notificationprofiles me WHERE ( me.contactid = ? ) ORDER BY priority, id: '7'
-SELECT sharednotificationprofileid.id, sharednotificationprofileid.name, sharednotificationprofileid.host_notification_options, sharednotificationprofileid.service_notification_options, sharednotificationprofileid.notification_period, sharednotificationprofileid.all_hostgroups, sharednotificationprofileid.all_servicegroups, sharednotificationprofileid.all_keywords, sharednotificationprofileid.notification_level, sharednotificationprofileid.role, sharednotificationprofileid.uncommitted FROM opsview.contact_sharednotificationprofile me JOIN opsview.sharednotificationprofiles sharednotificationprofileid ON sharednotificationprofileid.id = me.sharednotificationprofileid WHERE ( me.contactid = ? ) ORDER BY name: '7'
+SELECT me.id, me.name, me.contactid, me.host_notification_options, me.service_notification_options, me.notification_period, me.all_hostgroups, me.all_servicegroups, me.all_keywords, me.notification_level, me.priority, me.uncommitted, me.notification_level_stop FROM opsview.notificationprofiles me WHERE ( me.contactid = ? ) ORDER BY priority, id: '7'
+SELECT sharednotificationprofileid.id, sharednotificationprofileid.name, sharednotificationprofileid.host_notification_options, sharednotificationprofileid.service_notification_options, sharednotificationprofileid.notification_period, sharednotificationprofileid.all_hostgroups, sharednotificationprofileid.all_servicegroups, sharednotificationprofileid.all_keywords, sharednotificationprofileid.notification_level, sharednotificationprofileid.role, sharednotificationprofileid.uncommitted, sharednotificationprofileid.notification_level_stop FROM opsview.contact_sharednotificationprofile me JOIN opsview.sharednotificationprofiles sharednotificationprofileid ON sharednotificationprofileid.id = me.sharednotificationprofileid WHERE ( me.contactid = ? ) ORDER BY name: '7'
SELECT me.id, me.fullname, me.name, me.realm, me.encrypted_password, me.language, me.description, me.role, me.show_welcome_page, me.uncommitted FROM opsview.contacts me WHERE ( me.id = ? ) ORDER BY name: '7'
SELECT me.id, me.name, me.description, me.priority, me.all_hostgroups, me.all_servicegroups, me.all_keywords, me.uncommitted FROM opsview.roles me WHERE ( me.id = ? ): '13'
SELECT me.id FROM opsview.hostgroups me WHERE ( rgt = lft+1 ) ORDER BY name, id:
@@ -321,8 +321,8 @@
SELECT me.id FROM opsview.servicegroups me ORDER BY name:
SELECT me.id FROM opsview.hostgroups me WHERE ( rgt = lft+1 ) ORDER BY name, id:
SELECT keywordid.id, keywordid.name FROM opsview.role_access_keywords me JOIN opsview.keywords keywordid ON keywordid.id = me.keywordid WHERE ( me.roleid = ? ) ORDER BY name: '11'
-SELECT me.id, me.name, me.contactid, me.host_notification_options, me.service_notification_options, me.notification_period, me.all_hostgroups, me.all_servicegroups, me.all_keywords, me.notification_level, me.priority, me.uncommitted FROM opsview.notificationprofiles me WHERE ( me.contactid = ? ) ORDER BY priority, id: '6'
-SELECT sharednotificationprofileid.id, sharednotificationprofileid.name, sharednotificationprofileid.host_notification_options, sharednotificationprofileid.service_notification_options, sharednotificationprofileid.notification_period, sharednotificationprofileid.all_hostgroups, sharednotificationprofileid.all_servicegroups, sharednotificationprofileid.all_keywords, sharednotificationprofileid.notification_level, sharednotificationprofileid.role, sharednotificationprofileid.uncommitted FROM opsview.contact_sharednotificationprofile me JOIN opsview.sharednotificationprofiles sharednotificationprofileid ON sharednotificationprofileid.id = me.sharednotificationprofileid WHERE ( me.contactid = ? ) ORDER BY name: '6'
+SELECT me.id, me.name, me.contactid, me.host_notification_options, me.service_notification_options, me.notification_period, me.all_hostgroups, me.all_servicegroups, me.all_keywords, me.notification_level, me.priority, me.uncommitted, me.notification_level_stop FROM opsview.notificationprofiles me WHERE ( me.contactid = ? ) ORDER BY priority, id: '6'
+SELECT sharednotificationprofileid.id, sharednotificationprofileid.name, sharednotificationprofileid.host_notification_options, sharednotificationprofileid.service_notification_options, sharednotificationprofileid.notification_period, sharednotificationprofileid.all_hostgroups, sharednotificationprofileid.all_servicegroups, sharednotificationprofileid.all_keywords, sharednotificationprofileid.notification_level, sharednotificationprofileid.role, sharednotificationprofileid.uncommitted, sharednotificationprofileid.notification_level_stop FROM opsview.contact_sharednotificationprofile me JOIN opsview.sharednotificationprofiles sharednotificationprofileid ON sharednotificationprofileid.id = me.sharednotificationprofileid WHERE ( me.contactid = ? ) ORDER BY name: '6'
SELECT me.id, me.fullname, me.name, me.realm, me.encrypted_password, me.language, me.description, me.role, me.show_welcome_page, me.uncommitted FROM opsview.contacts me WHERE ( me.id = ? ) ORDER BY name: '6'
SELECT me.id, me.name, me.description, me.priority, me.all_hostgroups, me.all_servicegroups, me.all_keywords, me.uncommitted FROM opsview.roles me WHERE ( me.id = ? ): '11'
SELECT me.id FROM opsview.hostgroups me WHERE ( rgt = lft+1 ) ORDER BY name, id:
@@ -336,8 +336,8 @@
SELECT servicegroupid.id FROM opsview.role_access_servicegroups me JOIN opsview.servicegroups servicegroupid ON servicegroupid.id = me.servicegroupid WHERE ( me.roleid = ? ) ORDER BY name: '14'
SELECT hostgroupid.id FROM opsview.role_access_hostgroups me JOIN opsview.hostgroups hostgroupid ON hostgroupid.id = me.hostgroupid WHERE ( me.roleid = ? ) ORDER BY name, id: '14'
SELECT keywordid.id, keywordid.name FROM opsview.role_access_keywords me JOIN opsview.keywords keywordid ON keywordid.id = me.keywordid WHERE ( me.roleid = ? ) ORDER BY name: '14'
-SELECT me.id, me.name, me.contactid, me.host_notification_options, me.service_notification_options, me.notification_period, me.all_hostgroups, me.all_servicegroups, me.all_keywords, me.notification_level, me.priority, me.uncommitted FROM opsview.notificationprofiles me WHERE ( me.contactid = ? ) ORDER BY priority, id: '10'
-SELECT sharednotificationprofileid.id, sharednotificationprofileid.name, sharednotificationprofileid.host_notification_options, sharednotificationprofileid.service_notification_options, sharednotificationprofileid.notification_period, sharednotificationprofileid.all_hostgroups, sharednotificationprofileid.all_servicegroups, sharednotificationprofileid.all_keywords, sharednotificationprofileid.notification_level, sharednotificationprofileid.role, sharednotificationprofileid.uncommitted FROM opsview.contact_sharednotificationprofile me JOIN opsview.sharednotificationprofiles sharednotificationprofileid ON sharednotificationprofileid.id = me.sharednotificationprofileid WHERE ( me.contactid = ? ) ORDER BY name: '10'
+SELECT me.id, me.name, me.contactid, me.host_notification_options, me.service_notification_options, me.notification_period, me.all_hostgroups, me.all_servicegroups, me.all_keywords, me.notification_level, me.priority, me.uncommitted, me.notification_level_stop FROM opsview.notificationprofiles me WHERE ( me.contactid = ? ) ORDER BY priority, id: '10'
+SELECT sharednotificationprofileid.id, sharednotificationprofileid.name, sharednotificationprofileid.host_notification_options, sharednotificationprofileid.service_notification_options, sharednotificationprofileid.notification_period, sharednotificationprofileid.all_hostgroups, sharednotificationprofileid.all_servicegroups, sharednotificationprofileid.all_keywords, sharednotificationprofileid.notification_level, sharednotificationprofileid.role, sharednotificationprofileid.uncommitted, sharednotificationprofileid.notification_level_stop FROM opsview.contact_sharednotificationprofile me JOIN opsview.sharednotificationprofiles sharednotificationprofileid ON sharednotificationprofileid.id = me.sharednotificationprofileid WHERE ( me.contactid = ? ) ORDER BY name: '10'
SELECT hostgroup.id FROM opsview.notificationprofile_hostgroups me JOIN opsview.hostgroups hostgroup ON hostgroup.id = me.hostgroupid WHERE ( me.notificationprofileid = ? ) ORDER BY name, id: '13'
SELECT servicegroup.id FROM opsview.notificationprofile_servicegroups me JOIN opsview.servicegroups servicegroup ON servicegroup.id = me.servicegroupid WHERE ( me.notificationprofileid = ? ) ORDER BY name: '13'
SELECT keyword.id, keyword.name FROM opsview.notificationprofile_keywords me JOIN opsview.keywords keyword ON keyword.id = me.keywordid WHERE ( me.notificationprofileid = ? ) ORDER BY name: '13'
@@ -357,8 +357,8 @@
SELECT servicegroupid.id FROM opsview.role_access_servicegroups me JOIN opsview.servicegroups servicegroupid ON servicegroupid.id = me.servicegroupid WHERE ( me.roleid = ? ) ORDER BY name: '15'
SELECT hostgroupid.id FROM opsview.role_access_hostgroups me JOIN opsview.hostgroups hostgroupid ON hostgroupid.id = me.hostgroupid WHERE ( me.roleid = ? ) ORDER BY name, id: '15'
SELECT keywordid.id, keywordid.name FROM opsview.role_access_keywords me JOIN opsview.keywords keywordid ON keywordid.id = me.keywordid WHERE ( me.roleid = ? ) ORDER BY name: '15'
-SELECT me.id, me.name, me.contactid, me.host_notification_options, me.service_notification_options, me.notification_period, me.all_hostgroups, me.all_servicegroups, me.all_keywords, me.notification_level, me.priority, me.uncommitted FROM opsview.notificationprofiles me WHERE ( me.contactid = ? ) ORDER BY priority, id: '11'
-SELECT sharednotificationprofileid.id, sharednotificationprofileid.name, sharednotificationprofileid.host_notification_options, sharednotificationprofileid.service_notification_options, sharednotificationprofileid.notification_period, sharednotificationprofileid.all_hostgroups, sharednotificationprofileid.all_servicegroups, sharednotificationprofileid.all_keywords, sharednotificationprofileid.notification_level, sharednotificationprofileid.role, sharednotificationprofileid.uncommitted FROM opsview.contact_sharednotificationprofile me JOIN opsview.sharednotificationprofiles sharednotificationprofileid ON sharednotificationprofileid.id = me.sharednotificationprofileid WHERE ( me.contactid = ? ) ORDER BY name: '11'
+SELECT me.id, me.name, me.contactid, me.host_notification_options, me.service_notification_options, me.notification_period, me.all_hostgroups, me.all_servicegroups, me.all_keywords, me.notification_level, me.priority, me.uncommitted, me.notification_level_stop FROM opsview.notificationprofiles me WHERE ( me.contactid = ? ) ORDER BY priority, id: '11'
+SELECT sharednotificationprofileid.id, sharednotificationprofileid.name, sharednotificationprofileid.host_notification_options, sharednotificationprofileid.service_notification_options, sharednotificationprofileid.notification_period, sharednotificationprofileid.all_hostgroups, sharednotificationprofileid.all_servicegroups, sharednotificationprofileid.all_keywords, sharednotificationprofileid.notification_level, sharednotificationprofileid.role, sharednotificationprofileid.uncommitted, sharednotificationprofileid.notification_level_stop FROM opsview.contact_sharednotificationprofile me JOIN opsview.sharednotificationprofiles sharednotificationprofileid ON sharednotificationprofileid.id = me.sharednotificationprofileid WHERE ( me.contactid = ? ) ORDER BY name: '11'
SELECT hostgroup.id FROM opsview.notificationprofile_hostgroups me JOIN opsview.hostgroups hostgroup ON hostgroup.id = me.hostgroupid WHERE ( me.notificationprofileid = ? ) ORDER BY name, id: '11'
SELECT servicegroup.id FROM opsview.notificationprofile_servicegroups me JOIN opsview.servicegroups servicegroup ON servicegroup.id = me.servicegroupid WHERE ( me.notificationprofileid = ? ) ORDER BY name: '11'
SELECT keyword.id, keyword.name FROM opsview.notificationprofile_keywords me JOIN opsview.keywords keyword ON keyword.id = me.keywordid WHERE ( me.notificationprofileid = ? ) ORDER BY name: '11'
@@ -368,8 +368,8 @@
SELECT servicegroupid.id FROM opsview.role_access_servicegroups me JOIN opsview.servicegroups servicegroupid ON servicegroupid.id = me.servicegroupid WHERE ( me.roleid = ? ) ORDER BY name: '19'
SELECT hostgroupid.id FROM opsview.role_access_hostgroups me JOIN opsview.hostgroups hostgroupid ON hostgroupid.id = me.hostgroupid WHERE ( me.roleid = ? ) ORDER BY name, id: '19'
SELECT keywordid.id, keywordid.name FROM opsview.role_access_keywords me JOIN opsview.keywords keywordid ON keywordid.id = me.keywordid WHERE ( me.roleid = ? ) ORDER BY name: '19'
-SELECT me.id, me.name, me.contactid, me.host_notification_options, me.service_notification_options, me.notification_period, me.all_hostgroups, me.all_servicegroups, me.all_keywords, me.notification_level, me.priority, me.uncommitted FROM opsview.notificationprofiles me WHERE ( me.contactid = ? ) ORDER BY priority, id: '8'
-SELECT sharednotificationprofileid.id, sharednotificationprofileid.name, sharednotificationprofileid.host_notification_options, sharednotificationprofileid.service_notification_options, sharednotificationprofileid.notification_period, sharednotificationprofileid.all_hostgroups, sharednotificationprofileid.all_servicegroups, sharednotificationprofileid.all_keywords, sharednotificationprofileid.notification_level, sharednotificationprofileid.role, sharednotificationprofileid.uncommitted FROM opsview.contact_sharednotificationprofile me JOIN opsview.sharednotificationprofiles sharednotificationprofileid ON sharednotificationprofileid.id = me.sharednotificationprofileid WHERE ( me.contactid = ? ) ORDER BY name: '8'
+SELECT me.id, me.name, me.contactid, me.host_notification_options, me.service_notification_options, me.notification_period, me.all_hostgroups, me.all_servicegroups, me.all_keywords, me.notification_level, me.priority, me.uncommitted, me.notification_level_stop FROM opsview.notificationprofiles me WHERE ( me.contactid = ? ) ORDER BY priority, id: '8'
+SELECT sharednotificationprofileid.id, sharednotificationprofileid.name, sharednotificationprofileid.host_notification_options, sharednotificationprofileid.service_notification_options, sharednotificationprofileid.notification_period, sharednotificationprofileid.all_hostgroups, sharednotificationprofileid.all_servicegroups, sharednotificationprofileid.all_keywords, sharednotificationprofileid.notification_level, sharednotificationprofileid.role, sharednotificationprofileid.uncommitted, sharednotificationprofileid.notification_level_stop FROM opsview.contact_sharednotificationprofile me JOIN opsview.sharednotificationprofiles sharednotificationprofileid ON sharednotificationprofileid.id = me.sharednotificationprofileid WHERE ( me.contactid = ? ) ORDER BY name: '8'
SELECT hostgroup.id FROM opsview.notificationprofile_hostgroups me JOIN opsview.hostgroups hostgroup ON hostgroup.id = me.hostgroupid WHERE ( me.notificationprofileid = ? ) ORDER BY name, id: '8'
SELECT servicegroup.id FROM opsview.notificationprofile_servicegroups me JOIN opsview.servicegroups servicegroup ON servicegroup.id = me.servicegroupid WHERE ( me.notificationprofileid = ? ) ORDER BY name: '8'
SELECT keyword.id, keyword.name FROM opsview.notificationprofile_keywords me JOIN opsview.keywords keyword ON keyword.id = me.keywordid WHERE ( me.notificationprofileid = ? ) ORDER BY name: '8'
@@ -381,8 +381,8 @@
SELECT servicegroupid.id FROM opsview.role_access_servicegroups me JOIN opsview.servicegroups servicegroupid ON servicegroupid.id = me.servicegroupid WHERE ( me.roleid = ? ) ORDER BY name: '20'
SELECT hostgroupid.id FROM opsview.role_access_hostgroups me JOIN opsview.hostgroups hostgroupid ON hostgroupid.id = me.hostgroupid WHERE ( me.roleid = ? ) ORDER BY name, id: '20'
SELECT keywordid.id, keywordid.name FROM opsview.role_access_keywords me JOIN opsview.keywords keywordid ON keywordid.id = me.keywordid WHERE ( me.roleid = ? ) ORDER BY name: '20'
-SELECT me.id, me.name, me.contactid, me.host_notification_options, me.service_notification_options, me.notification_period, me.all_hostgroups, me.all_servicegroups, me.all_keywords, me.notification_level, me.priority, me.uncommitted FROM opsview.notificationprofiles me WHERE ( me.contactid = ? ) ORDER BY priority, id: '9'
-SELECT sharednotificationprofileid.id, sharednotificationprofileid.name, sharednotificationprofileid.host_notification_options, sharednotificationprofileid.service_notification_options, sharednotificationprofileid.notification_period, sharednotificationprofileid.all_hostgroups, sharednotificationprofileid.all_servicegroups, sharednotificationprofileid.all_keywords, sharednotificationprofileid.notification_level, sharednotificationprofileid.role, sharednotificationprofileid.uncommitted FROM opsview.contact_sharednotificationprofile me JOIN opsview.sharednotificationprofiles sharednotificationprofileid ON sharednotificationprofileid.id = me.sharednotificationprofileid WHERE ( me.contactid = ? ) ORDER BY name: '9'
+SELECT me.id, me.name, me.contactid, me.host_notification_options, me.service_notification_options, me.notification_period, me.all_hostgroups, me.all_servicegroups, me.all_keywords, me.notification_level, me.priority, me.uncommitted, me.notification_level_stop FROM opsview.notificationprofiles me WHERE ( me.contactid = ? ) ORDER BY priority, id: '9'
+SELECT sharednotificationprofileid.id, sharednotificationprofileid.name, sharednotificationprofileid.host_notification_options, sharednotificationprofileid.service_notification_options, sharednotificationprofileid.notification_period, sharednotificationprofileid.all_hostgroups, sharednotificationprofileid.all_servicegroups, sharednotificationprofileid.all_keywords, sharednotificationprofileid.notification_level, sharednotificationprofileid.role, sharednotificationprofileid.uncommitted, sharednotificationprofileid.notification_level_stop FROM opsview.contact_sharednotificationprofile me JOIN opsview.sharednotificationprofiles sharednotificationprofileid ON sharednotificationprofileid.id = me.sharednotificationprofileid WHERE ( me.contactid = ? ) ORDER BY name: '9'
SELECT hostgroup.id FROM opsview.notificationprofile_hostgroups me JOIN opsview.hostgroups hostgroup ON hostgroup.id = me.hostgroupid WHERE ( me.notificationprofileid = ? ) ORDER BY name, id: '9'
SELECT servicegroup.id FROM opsview.notificationprofile_servicegroups me JOIN opsview.servicegroups servicegroup ON servicegroup.id = me.servicegroupid WHERE ( me.notificationprofileid = ? ) ORDER BY name: '9'
SELECT keyword.id, keyword.name FROM opsview.notificationprofile_keywords me JOIN opsview.keywords keyword ON keyword.id = me.keywordid WHERE ( me.notificationprofileid = ? ) ORDER BY name: '9'
