Modified: trunk/opsview-core/t/var/configs/dbic_trace
===================================================================
--- trunk/opsview-core/t/var/configs/dbic_trace 2013-02-28 16:36:46 UTC (rev 11624)
+++ trunk/opsview-core/t/var/configs/dbic_trace 2013-02-28 16:44:49 UTC (rev 11625)
@@ -2,22 +2,22 @@
SELECT me.id, me.name, me.host, me.role, me.activated, me.passive, me.uncommitted FROM opsview.monitoringservers me:
SELECT me.id, me.default_statusmap_layout, me.default_statuswrl_layout, me.refresh_rate, me.log_notifications, me.log_service_retries, me.log_host_retries, me.log_event_handlers, me.log_initial_states, me.log_external_commands, me.log_passive_checks, me.daemon_dumps_core, me.date_format, me.audit_log_retention, me.host_info_url, me.hostgroup_info_url, me.service_info_url, me.opsview_server_name, me.soft_state_dependencies, me.show_timeline, me.smart_hosttemplate_removal, me.rancid_email_notification, me.send_anon_data, me.uuid, me.netdisco_url, me.updates_includemajor, me.set_downtime_on_host_delete FROM opsview.systempreferences me WHERE ( me.id = ? ): '1'
SELECT me.id, me.name, me.host, me.role, me.activated, me.passive, me.uncommitted FROM opsview.monitoringservers me:
-SELECT me.id, me.name, me.ip, me.alias, me.notification_interval, me.hostgroup, me.check_period, me.check_interval, me.retry_check_interval, me.check_attempts, me.icon, me.enable_snmp, me.snmp_community, me.notification_options, me.notification_period, me.check_command, me.http_admin_url, me.http_admin_port, me.monitored_by, me.uncommitted, me.other_addresses, me.snmp_version, me.snmp_port, me.snmpv3_username, me.snmpv3_authprotocol, me.snmpv3_authpassword, me.snmpv3_privprotocol, me.snmpv3_privpassword, me.snmptrap_tracing, me.use_rancid, me.rancid_vendor, me.rancid_username, me.rancid_password, me.rancid_connection_type, me.rancid_autoenable, me.use_nmis, me.nmis_node_type, me.flap_detection_enabled, me.use_mrtg, me.tidy_ifdescr_level, me.snmp_max_msg_size, me.snmp_extended_throughput_data FROM opsview.hosts me WHERE ( me.id = ? ) ORDER BY name ASC: '1'
+SELECT me.id, me.name, me.ip, me.alias, me.notification_interval, me.hostgroup, me.check_period, me.check_interval, me.retry_check_interval, me.check_attempts, me.icon, me.enable_snmp, me.snmp_community, me.notification_options, me.notification_period, me.check_command, me.http_admin_url, me.http_admin_port, me.monitored_by, me.uncommitted, me.other_addresses, me.snmp_version, me.snmp_port, me.snmpv3_username, me.snmpv3_authprotocol, me.snmpv3_authpassword, me.snmpv3_privprotocol, me.snmpv3_privpassword, me.snmptrap_tracing, me.use_rancid, me.rancid_vendor, me.rancid_username, me.rancid_password, me.rancid_connection_type, me.rancid_autoenable, me.use_nmis, me.nmis_node_type, me.flap_detection_enabled, me.use_mrtg, me.tidy_ifdescr_level, me.snmp_max_msg_size, me.snmp_extended_throughput_data, me.event_handler FROM opsview.hosts me WHERE ( me.id = ? ) ORDER BY name ASC: '1'
SELECT me.id, me.monitoringcluster, me.host, me.activated, me.passive, me.uncommitted FROM opsview.monitoringclusternodes me WHERE ( me.monitoringcluster = ? ): '2'
-SELECT me.id, me.name, me.ip, me.alias, me.notification_interval, me.hostgroup, me.check_period, me.check_interval, me.retry_check_interval, me.check_attempts, me.icon, me.enable_snmp, me.snmp_community, me.notification_options, me.notification_period, me.check_command, me.http_admin_url, me.http_admin_port, me.monitored_by, me.uncommitted, me.other_addresses, me.snmp_version, me.snmp_port, me.snmpv3_username, me.snmpv3_authprotocol, me.snmpv3_authpassword, me.snmpv3_privprotocol, me.snmpv3_privpassword, me.snmptrap_tracing, me.use_rancid, me.rancid_vendor, me.rancid_username, me.rancid_password, me.rancid_connection_type, me.rancid_autoenable, me.use_nmis, me.nmis_node_type, me.flap_detection_enabled, me.use_mrtg, me.tidy_ifdescr_level, me.snmp_max_msg_size, me.snmp_extended_throughput_data FROM opsview.hosts me WHERE ( me.id = ? ) ORDER BY name ASC: '5'
+SELECT me.id, me.name, me.ip, me.alias, me.notification_interval, me.hostgroup, me.check_period, me.check_interval, me.retry_check_interval, me.check_attempts, me.icon, me.enable_snmp, me.snmp_community, me.notification_options, me.notification_period, me.check_command, me.http_admin_url, me.http_admin_port, me.monitored_by, me.uncommitted, me.other_addresses, me.snmp_version, me.snmp_port, me.snmpv3_username, me.snmpv3_authprotocol, me.snmpv3_authpassword, me.snmpv3_privprotocol, me.snmpv3_privpassword, me.snmptrap_tracing, me.use_rancid, me.rancid_vendor, me.rancid_username, me.rancid_password, me.rancid_connection_type, me.rancid_autoenable, me.use_nmis, me.nmis_node_type, me.flap_detection_enabled, me.use_mrtg, me.tidy_ifdescr_level, me.snmp_max_msg_size, me.snmp_extended_throughput_data, me.event_handler FROM opsview.hosts me WHERE ( me.id = ? ) ORDER BY name ASC: '5'
SELECT me.id, me.monitoringcluster, me.host, me.activated, me.passive, me.uncommitted FROM opsview.monitoringclusternodes me WHERE ( me.monitoringcluster = ? ): '3'
-SELECT me.id, me.name, me.ip, me.alias, me.notification_interval, me.hostgroup, me.check_period, me.check_interval, me.retry_check_interval, me.check_attempts, me.icon, me.enable_snmp, me.snmp_community, me.notification_options, me.notification_period, me.check_command, me.http_admin_url, me.http_admin_port, me.monitored_by, me.uncommitted, me.other_addresses, me.snmp_version, me.snmp_port, me.snmpv3_username, me.snmpv3_authprotocol, me.snmpv3_authpassword, me.snmpv3_privprotocol, me.snmpv3_privpassword, me.snmptrap_tracing, me.use_rancid, me.rancid_vendor, me.rancid_username, me.rancid_password, me.rancid_connection_type, me.rancid_autoenable, me.use_nmis, me.nmis_node_type, me.flap_detection_enabled, me.use_mrtg, me.tidy_ifdescr_level, me.snmp_max_msg_size, me.snmp_extended_throughput_data FROM opsview.hosts me WHERE ( me.id = ? ) ORDER BY name ASC: '19'
-SELECT me.id, me.name, me.ip, me.alias, me.notification_interval, me.hostgroup, me.check_period, me.check_interval, me.retry_check_interval, me.check_attempts, me.icon, me.enable_snmp, me.snmp_community, me.notification_options, me.notification_period, me.check_command, me.http_admin_url, me.http_admin_port, me.monitored_by, me.uncommitted, me.other_addresses, me.snmp_version, me.snmp_port, me.snmpv3_username, me.snmpv3_authprotocol, me.snmpv3_authpassword, me.snmpv3_privprotocol, me.snmpv3_privpassword, me.snmptrap_tracing, me.use_rancid, me.rancid_vendor, me.rancid_username, me.rancid_password, me.rancid_connection_type, me.rancid_autoenable, me.use_nmis, me.nmis_node_type, me.flap_detection_enabled, me.use_mrtg, me.tidy_ifdescr_level, me.snmp_max_msg_size, me.snmp_extended_throughput_data FROM opsview.hosts me WHERE ( me.id = ? ) ORDER BY name ASC: '20'
-SELECT me.id, me.name, me.ip, me.alias, me.notification_interval, me.hostgroup, me.check_period, me.check_interval, me.retry_check_interval, me.check_attempts, me.icon, me.enable_snmp, me.snmp_community, me.notification_options, me.notification_period, me.check_command, me.http_admin_url, me.http_admin_port, me.monitored_by, me.uncommitted, me.other_addresses, me.snmp_version, me.snmp_port, me.snmpv3_username, me.snmpv3_authprotocol, me.snmpv3_authpassword, me.snmpv3_privprotocol, me.snmpv3_privpassword, me.snmptrap_tracing, me.use_rancid, me.rancid_vendor, me.rancid_username, me.rancid_password, me.rancid_connection_type, me.rancid_autoenable, me.use_nmis, me.nmis_node_type, me.flap_detection_enabled, me.use_mrtg, me.tidy_ifdescr_level, me.snmp_max_msg_size, me.snmp_extended_throughput_data FROM opsview.hosts me WHERE ( me.id = ? ) ORDER BY name ASC: '21'
+SELECT me.id, me.name, me.ip, me.alias, me.notification_interval, me.hostgroup, me.check_period, me.check_interval, me.retry_check_interval, me.check_attempts, me.icon, me.enable_snmp, me.snmp_community, me.notification_options, me.notification_period, me.check_command, me.http_admin_url, me.http_admin_port, me.monitored_by, me.uncommitted, me.other_addresses, me.snmp_version, me.snmp_port, me.snmpv3_username, me.snmpv3_authprotocol, me.snmpv3_authpassword, me.snmpv3_privprotocol, me.snmpv3_privpassword, me.snmptrap_tracing, me.use_rancid, me.rancid_vendor, me.rancid_username, me.rancid_password, me.rancid_connection_type, me.rancid_autoenable, me.use_nmis, me.nmis_node_type, me.flap_detection_enabled, me.use_mrtg, me.tidy_ifdescr_level, me.snmp_max_msg_size, me.snmp_extended_throughput_data, me.event_handler FROM opsview.hosts me WHERE ( me.id = ? ) ORDER BY name ASC: '19'
+SELECT me.id, me.name, me.ip, me.alias, me.notification_interval, me.hostgroup, me.check_period, me.check_interval, me.retry_check_interval, me.check_attempts, me.icon, me.enable_snmp, me.snmp_community, me.notification_options, me.notification_period, me.check_command, me.http_admin_url, me.http_admin_port, me.monitored_by, me.uncommitted, me.other_addresses, me.snmp_version, me.snmp_port, me.snmpv3_username, me.snmpv3_authprotocol, me.snmpv3_authpassword, me.snmpv3_privprotocol, me.snmpv3_privpassword, me.snmptrap_tracing, me.use_rancid, me.rancid_vendor, me.rancid_username, me.rancid_password, me.rancid_connection_type, me.rancid_autoenable, me.use_nmis, me.nmis_node_type, me.flap_detection_enabled, me.use_mrtg, me.tidy_ifdescr_level, me.snmp_max_msg_size, me.snmp_extended_throughput_data, me.event_handler FROM opsview.hosts me WHERE ( me.id = ? ) ORDER BY name ASC: '20'
+SELECT me.id, me.name, me.ip, me.alias, me.notification_interval, me.hostgroup, me.check_period, me.check_interval, me.retry_check_interval, me.check_attempts, me.icon, me.enable_snmp, me.snmp_community, me.notification_options, me.notification_period, me.check_command, me.http_admin_url, me.http_admin_port, me.monitored_by, me.uncommitted, me.other_addresses, me.snmp_version, me.snmp_port, me.snmpv3_username, me.snmpv3_authprotocol, me.snmpv3_authpassword, me.snmpv3_privprotocol, me.snmpv3_privpassword, me.snmptrap_tracing, me.use_rancid, me.rancid_vendor, me.rancid_username, me.rancid_password, me.rancid_connection_type, me.rancid_autoenable, me.use_nmis, me.nmis_node_type, me.flap_detection_enabled, me.use_mrtg, me.tidy_ifdescr_level, me.snmp_max_msg_size, me.snmp_extended_throughput_data, me.event_handler FROM opsview.hosts me WHERE ( me.id = ? ) ORDER BY name ASC: '21'
SELECT me.id, me.monitoringcluster, me.host, me.activated, me.passive, me.uncommitted FROM opsview.monitoringclusternodes me WHERE ( me.monitoringcluster = ? ): '4'
-SELECT me.id, me.name, me.ip, me.alias, me.notification_interval, me.hostgroup, me.check_period, me.check_interval, me.retry_check_interval, me.check_attempts, me.icon, me.enable_snmp, me.snmp_community, me.notification_options, me.notification_period, me.check_command, me.http_admin_url, me.http_admin_port, me.monitored_by, me.uncommitted, me.other_addresses, me.snmp_version, me.snmp_port, me.snmpv3_username, me.snmpv3_authprotocol, me.snmpv3_authpassword, me.snmpv3_privprotocol, me.snmpv3_privpassword, me.snmptrap_tracing, me.use_rancid, me.rancid_vendor, me.rancid_username, me.rancid_password, me.rancid_connection_type, me.rancid_autoenable, me.use_nmis, me.nmis_node_type, me.flap_detection_enabled, me.use_mrtg, me.tidy_ifdescr_level, me.snmp_max_msg_size, me.snmp_extended_throughput_data FROM opsview.hosts me WHERE ( me.id = ? ) ORDER BY name ASC: '23'
+SELECT me.id, me.name, me.ip, me.alias, me.notification_interval, me.hostgroup, me.check_period, me.check_interval, me.retry_check_interval, me.check_attempts, me.icon, me.enable_snmp, me.snmp_community, me.notification_options, me.notification_period, me.check_command, me.http_admin_url, me.http_admin_port, me.monitored_by, me.uncommitted, me.other_addresses, me.snmp_version, me.snmp_port, me.snmpv3_username, me.snmpv3_authprotocol, me.snmpv3_authpassword, me.snmpv3_privprotocol, me.snmpv3_privpassword, me.snmptrap_tracing, me.use_rancid, me.rancid_vendor, me.rancid_username, me.rancid_password, me.rancid_connection_type, me.rancid_autoenable, me.use_nmis, me.nmis_node_type, me.flap_detection_enabled, me.use_mrtg, me.tidy_ifdescr_level, me.snmp_max_msg_size, me.snmp_extended_throughput_data, me.event_handler FROM opsview.hosts me WHERE ( me.id = ? ) ORDER BY name ASC: '23'
SELECT me.id, me.monitoringcluster, me.host, me.activated, me.passive, me.uncommitted FROM opsview.monitoringclusternodes me WHERE ( me.monitoringcluster = ? ): '5'
-SELECT me.id, me.name, me.ip, me.alias, me.notification_interval, me.hostgroup, me.check_period, me.check_interval, me.retry_check_interval, me.check_attempts, me.icon, me.enable_snmp, me.snmp_community, me.notification_options, me.notification_period, me.check_command, me.http_admin_url, me.http_admin_port, me.monitored_by, me.uncommitted, me.other_addresses, me.snmp_version, me.snmp_port, me.snmpv3_username, me.snmpv3_authprotocol, me.snmpv3_authpassword, me.snmpv3_privprotocol, me.snmpv3_privpassword, me.snmptrap_tracing, me.use_rancid, me.rancid_vendor, me.rancid_username, me.rancid_password, me.rancid_connection_type, me.rancid_autoenable, me.use_nmis, me.nmis_node_type, me.flap_detection_enabled, me.use_mrtg, me.tidy_ifdescr_level, me.snmp_max_msg_size, me.snmp_extended_throughput_data FROM opsview.hosts me WHERE ( me.id = ? ) ORDER BY name ASC: '9'
-SELECT me.id, me.name, me.ip, me.alias, me.notification_interval, me.hostgroup, me.check_period, me.check_interval, me.retry_check_interval, me.check_attempts, me.icon, me.enable_snmp, me.snmp_community, me.notification_options, me.notification_period, me.check_command, me.http_admin_url, me.http_admin_port, me.monitored_by, me.uncommitted, me.other_addresses, me.snmp_version, me.snmp_port, me.snmpv3_username, me.snmpv3_authprotocol, me.snmpv3_authpassword, me.snmpv3_privprotocol, me.snmpv3_privpassword, me.snmptrap_tracing, me.use_rancid, me.rancid_vendor, me.rancid_username, me.rancid_password, me.rancid_connection_type, me.rancid_autoenable, me.use_nmis, me.nmis_node_type, me.flap_detection_enabled, me.use_mrtg, me.tidy_ifdescr_level, me.snmp_max_msg_size, me.snmp_extended_throughput_data FROM opsview.hosts me WHERE ( me.monitored_by = ? ) ORDER BY name ASC: '1'
-SELECT me.id, me.name, me.ip, me.alias, me.notification_interval, me.hostgroup, me.check_period, me.check_interval, me.retry_check_interval, me.check_attempts, me.icon, me.enable_snmp, me.snmp_community, me.notification_options, me.notification_period, me.check_command, me.http_admin_url, me.http_admin_port, me.monitored_by, me.uncommitted, me.other_addresses, me.snmp_version, me.snmp_port, me.snmpv3_username, me.snmpv3_authprotocol, me.snmpv3_authpassword, me.snmpv3_privprotocol, me.snmpv3_privpassword, me.snmptrap_tracing, me.use_rancid, me.rancid_vendor, me.rancid_username, me.rancid_password, me.rancid_connection_type, me.rancid_autoenable, me.use_nmis, me.nmis_node_type, me.flap_detection_enabled, me.use_mrtg, me.tidy_ifdescr_level, me.snmp_max_msg_size, me.snmp_extended_throughput_data FROM opsview.hosts me WHERE ( me.monitored_by = ? ) ORDER BY name ASC: '1'
+SELECT me.id, me.name, me.ip, me.alias, me.notification_interval, me.hostgroup, me.check_period, me.check_interval, me.retry_check_interval, me.check_attempts, me.icon, me.enable_snmp, me.snmp_community, me.notification_options, me.notification_period, me.check_command, me.http_admin_url, me.http_admin_port, me.monitored_by, me.uncommitted, me.other_addresses, me.snmp_version, me.snmp_port, me.snmpv3_username, me.snmpv3_authprotocol, me.snmpv3_authpassword, me.snmpv3_privprotocol, me.snmpv3_privpassword, me.snmptrap_tracing, me.use_rancid, me.rancid_vendor, me.rancid_username, me.rancid_password, me.rancid_connection_type, me.rancid_autoenable, me.use_nmis, me.nmis_node_type, me.flap_detection_enabled, me.use_mrtg, me.tidy_ifdescr_level, me.snmp_max_msg_size, me.snmp_extended_throughput_data, me.event_handler FROM opsview.hosts me WHERE ( me.id = ? ) ORDER BY name ASC: '9'
+SELECT me.id, me.name, me.ip, me.alias, me.notification_interval, me.hostgroup, me.check_period, me.check_interval, me.retry_check_interval, me.check_attempts, me.icon, me.enable_snmp, me.snmp_community, me.notification_options, me.notification_period, me.check_command, me.http_admin_url, me.http_admin_port, me.monitored_by, me.uncommitted, me.other_addresses, me.snmp_version, me.snmp_port, me.snmpv3_username, me.snmpv3_authprotocol, me.snmpv3_authpassword, me.snmpv3_privprotocol, me.snmpv3_privpassword, me.snmptrap_tracing, me.use_rancid, me.rancid_vendor, me.rancid_username, me.rancid_password, me.rancid_connection_type, me.rancid_autoenable, me.use_nmis, me.nmis_node_type, me.flap_detection_enabled, me.use_mrtg, me.tidy_ifdescr_level, me.snmp_max_msg_size, me.snmp_extended_throughput_data, me.event_handler FROM opsview.hosts me WHERE ( me.monitored_by = ? ) ORDER BY name ASC: '1'
+SELECT me.id, me.name, me.ip, me.alias, me.notification_interval, me.hostgroup, me.check_period, me.check_interval, me.retry_check_interval, me.check_attempts, me.icon, me.enable_snmp, me.snmp_community, me.notification_options, me.notification_period, me.check_command, me.http_admin_url, me.http_admin_port, me.monitored_by, me.uncommitted, me.other_addresses, me.snmp_version, me.snmp_port, me.snmpv3_username, me.snmpv3_authprotocol, me.snmpv3_authpassword, me.snmpv3_privprotocol, me.snmpv3_privpassword, me.snmptrap_tracing, me.use_rancid, me.rancid_vendor, me.rancid_username, me.rancid_password, me.rancid_connection_type, me.rancid_autoenable, me.use_nmis, me.nmis_node_type, me.flap_detection_enabled, me.use_mrtg, me.tidy_ifdescr_level, me.snmp_max_msg_size, me.snmp_extended_throughput_data, me.event_handler FROM opsview.hosts me WHERE ( me.monitored_by = ? ) ORDER BY name ASC: '1'
SELECT COUNT( * ) FROM opsview.parents me JOIN opsview.hosts hostid ON hostid.id = me.hostid WHERE ( me.parentid = ? ): '11'
SELECT me.id, me.parentid, me.name, me.uncommitted, me.lft, me.rgt, me.matpath, me.matpathid FROM opsview.hostgroups me WHERE ( me.id = ? ) ORDER BY name, id: '4'
-SELECT me.id, me.name, me.ip, me.alias, me.notification_interval, me.hostgroup, me.check_period, me.check_interval, me.retry_check_interval, me.check_attempts, me.icon, me.enable_snmp, me.snmp_community, me.notification_options, me.notification_period, me.check_command, me.http_admin_url, me.http_admin_port, me.monitored_by, me.uncommitted, me.other_addresses, me.snmp_version, me.snmp_port, me.snmpv3_username, me.snmpv3_authprotocol, me.snmpv3_authpassword, me.snmpv3_privprotocol, me.snmpv3_privpassword, me.snmptrap_tracing, me.use_rancid, me.rancid_vendor, me.rancid_username, me.rancid_password, me.rancid_connection_type, me.rancid_autoenable, me.use_nmis, me.nmis_node_type, me.flap_detection_enabled, me.use_mrtg, me.tidy_ifdescr_level, me.snmp_max_msg_size, me.snmp_extended_throughput_data FROM opsview.hosts me WHERE ( me.monitored_by = ? ) ORDER BY name ASC: '1'
+SELECT me.id, me.name, me.ip, me.alias, me.notification_interval, me.hostgroup, me.check_period, me.check_interval, me.retry_check_interval, me.check_attempts, me.icon, me.enable_snmp, me.snmp_community, me.notification_options, me.notification_period, me.check_command, me.http_admin_url, me.http_admin_port, me.monitored_by, me.uncommitted, me.other_addresses, me.snmp_version, me.snmp_port, me.snmpv3_username, me.snmpv3_authprotocol, me.snmpv3_authpassword, me.snmpv3_privprotocol, me.snmpv3_privpassword, me.snmptrap_tracing, me.use_rancid, me.rancid_vendor, me.rancid_username, me.rancid_password, me.rancid_connection_type, me.rancid_autoenable, me.use_nmis, me.nmis_node_type, me.flap_detection_enabled, me.use_mrtg, me.tidy_ifdescr_level, me.snmp_max_msg_size, me.snmp_extended_throughput_data, me.event_handler FROM opsview.hosts me WHERE ( me.monitored_by = ? ) ORDER BY name ASC: '1'
SELECT me.id, me.name, me.description, me.enabled, me.style, me.all_hosts, me.all_servicechecks, me.public, me.show_contextual_menus, me.uncommitted, me.exclude_handled FROM opsview.keywords me ORDER BY name:
SELECT hostid.name FROM opsview.keywordhosts me JOIN opsview.hosts hostid ON hostid.id = me.hostid WHERE ( me.keywordid = ? ) ORDER BY name ASC: '9'
SELECT servicecheckid.name FROM opsview.keywordservicechecks me JOIN opsview.servicechecks servicecheckid ON servicecheckid.id = me.servicecheckid WHERE ( me.keywordid = ? ) ORDER BY name: '9'
@@ -39,6 +39,7 @@
SELECT servicecheckid.name FROM opsview.keywordservicechecks me JOIN opsview.servicechecks servicecheckid ON servicecheckid.id = me.servicecheckid WHERE ( me.keywordid = ? ) ORDER BY name: '5'
SELECT me.name, me.envvars FROM opsview.plugins me LEFT JOIN opsview.servicechecks servicechecks ON servicechecks.plugin = me.name WHERE ( servicechecks.plugin IS NOT NULL ) GROUP BY me.name, me.envvars ORDER BY name ASC:
SELECT me.id, me.event_handler FROM opsview.servicechecks me WHERE ( event_handler != ? ) ORDER BY name: ''
+SELECT me.id, me.event_handler FROM opsview.hosts me WHERE ( event_handler != ? ) ORDER BY name ASC: ''
SELECT me.id, me.name, me.plugin, me.args, me.priority, me.uncommitted, plugin.name, plugin.onserver, plugin.help, plugin.envvars FROM (SELECT me.id, me.name, me.plugin, me.args, me.priority, me.uncommitted FROM opsview.hostcheckcommands me INNER JOIN opsview.hosts hosts ON hosts.check_command = me.id JOIN opsview.plugins plugin ON plugin.name = me.plugin GROUP BY me.id, me.name, me.plugin, me.args, me.priority, me.uncommitted ORDER BY me.id) me INNER JOIN opsview.hosts hosts ON hosts.check_command = me.id JOIN opsview.plugins plugin ON plugin.name = me.plugin GROUP BY me.id, me.name, me.plugin, me.args, me.priority, me.uncommitted, plugin.name, plugin.onserver, plugin.help, plugin.envvars ORDER BY me.id:
SELECT me.id, me.name, me.host, me.role, me.activated, me.passive, me.uncommitted FROM opsview.monitoringservers me WHERE ( me.id = ? ): '1'
SELECT me.id, me.parentid, me.name, me.uncommitted, me.lft, me.rgt, me.matpath, me.matpathid FROM opsview.hostgroups me WHERE ( me.id = ? ) ORDER BY name, id: '4'
@@ -148,18 +149,18 @@
SELECT me.id, me.hostid, me.interfacename, me.active, me.throughput_warning, me.throughput_critical, me.errors_warning, me.errors_critical, me.discards_warning, me.discards_critical, me.shortinterfacename, me.indexid FROM opsview.hostsnmpinterfaces me WHERE ( ( active = ? AND me.hostid = ? ) ) ORDER BY interfacename: '1', '12'
SELECT COUNT( * ) FROM opsview.hostsnmpinterfaces me WHERE ( ( active = ? AND me.hostid = ? ) ): '1', '12'
SELECT me.id, me.name, me.host, me.role, me.activated, me.passive, me.uncommitted FROM opsview.monitoringservers me WHERE ( me.id = ? ): '1'
-SELECT me.id, me.name, me.ip, me.alias, me.notification_interval, me.hostgroup, me.check_period, me.check_interval, me.retry_check_interval, me.check_attempts, me.icon, me.enable_snmp, me.snmp_community, me.notification_options, me.notification_period, me.check_command, me.http_admin_url, me.http_admin_port, me.monitored_by, me.uncommitted, me.other_addresses, me.snmp_version, me.snmp_port, me.snmpv3_username, me.snmpv3_authprotocol, me.snmpv3_authpassword, me.snmpv3_privprotocol, me.snmpv3_privpassword, me.snmptrap_tracing, me.use_rancid, me.rancid_vendor, me.rancid_username, me.rancid_password, me.rancid_connection_type, me.rancid_autoenable, me.use_nmis, me.nmis_node_type, me.flap_detection_enabled, me.use_mrtg, me.tidy_ifdescr_level, me.snmp_max_msg_size, me.snmp_extended_throughput_data FROM opsview.hosts me WHERE ( me.id = ? ) ORDER BY name ASC: '1'
+SELECT me.id, me.name, me.ip, me.alias, me.notification_interval, me.hostgroup, me.check_period, me.check_interval, me.retry_check_interval, me.check_attempts, me.icon, me.enable_snmp, me.snmp_community, me.notification_options, me.notification_period, me.check_command, me.http_admin_url, me.http_admin_port, me.monitored_by, me.uncommitted, me.other_addresses, me.snmp_version, me.snmp_port, me.snmpv3_username, me.snmpv3_authprotocol, me.snmpv3_authpassword, me.snmpv3_privprotocol, me.snmpv3_privpassword, me.snmptrap_tracing, me.use_rancid, me.rancid_vendor, me.rancid_username, me.rancid_password, me.rancid_connection_type, me.rancid_autoenable, me.use_nmis, me.nmis_node_type, me.flap_detection_enabled, me.use_mrtg, me.tidy_ifdescr_level, me.snmp_max_msg_size, me.snmp_extended_throughput_data, me.event_handler FROM opsview.hosts me WHERE ( me.id = ? ) ORDER BY name ASC: '1'
SELECT parents_parentids.hostid, me.id, me.name FROM opsview.hosts me INNER JOIN opsview.parents parents_parentids ON parents_parentids.parentid = me.id ORDER BY name ASC:
SELECT me.id, monitored_by.id, monitored_by.name, monitored_by.host, monitored_by.role, monitored_by.activated, monitored_by.passive, monitored_by.uncommitted FROM opsview.hosts me JOIN opsview.monitoringservers monitored_by ON monitored_by.id = me.monitored_by ORDER BY name ASC:
SELECT me.id, me.monitoringcluster, me.host, me.activated, me.passive, me.uncommitted FROM opsview.monitoringclusternodes me WHERE ( me.monitoringcluster = ? ): '3'
-SELECT me.id, me.name, me.ip, me.alias, me.notification_interval, me.hostgroup, me.check_period, me.check_interval, me.retry_check_interval, me.check_attempts, me.icon, me.enable_snmp, me.snmp_community, me.notification_options, me.notification_period, me.check_command, me.http_admin_url, me.http_admin_port, me.monitored_by, me.uncommitted, me.other_addresses, me.snmp_version, me.snmp_port, me.snmpv3_username, me.snmpv3_authprotocol, me.snmpv3_authpassword, me.snmpv3_privprotocol, me.snmpv3_privpassword, me.snmptrap_tracing, me.use_rancid, me.rancid_vendor, me.rancid_username, me.rancid_password, me.rancid_connection_type, me.rancid_autoenable, me.use_nmis, me.nmis_node_type, me.flap_detection_enabled, me.use_mrtg, me.tidy_ifdescr_level, me.snmp_max_msg_size, me.snmp_extended_throughput_data FROM opsview.hosts me WHERE ( me.id = ? ) ORDER BY name ASC: '19'
-SELECT me.id, me.name, me.ip, me.alias, me.notification_interval, me.hostgroup, me.check_period, me.check_interval, me.retry_check_interval, me.check_attempts, me.icon, me.enable_snmp, me.snmp_community, me.notification_options, me.notification_period, me.check_command, me.http_admin_url, me.http_admin_port, me.monitored_by, me.uncommitted, me.other_addresses, me.snmp_version, me.snmp_port, me.snmpv3_username, me.snmpv3_authprotocol, me.snmpv3_authpassword, me.snmpv3_privprotocol, me.snmpv3_privpassword, me.snmptrap_tracing, me.use_rancid, me.rancid_vendor, me.rancid_username, me.rancid_password, me.rancid_connection_type, me.rancid_autoenable, me.use_nmis, me.nmis_node_type, me.flap_detection_enabled, me.use_mrtg, me.tidy_ifdescr_level, me.snmp_max_msg_size, me.snmp_extended_throughput_data FROM opsview.hosts me WHERE ( me.id = ? ) ORDER BY name ASC: '20'
-SELECT me.id, me.name, me.ip, me.alias, me.notification_interval, me.hostgroup, me.check_period, me.check_interval, me.retry_check_interval, me.check_attempts, me.icon, me.enable_snmp, me.snmp_community, me.notification_options, me.notification_period, me.check_command, me.http_admin_url, me.http_admin_port, me.monitored_by, me.uncommitted, me.other_addresses, me.snmp_version, me.snmp_port, me.snmpv3_username, me.snmpv3_authprotocol, me.snmpv3_authpassword, me.snmpv3_privprotocol, me.snmpv3_privpassword, me.snmptrap_tracing, me.use_rancid, me.rancid_vendor, me.rancid_username, me.rancid_password, me.rancid_connection_type, me.rancid_autoenable, me.use_nmis, me.nmis_node_type, me.flap_detection_enabled, me.use_mrtg, me.tidy_ifdescr_level, me.snmp_max_msg_size, me.snmp_extended_throughput_data FROM opsview.hosts me WHERE ( me.id = ? ) ORDER BY name ASC: '21'
+SELECT me.id, me.name, me.ip, me.alias, me.notification_interval, me.hostgroup, me.check_period, me.check_interval, me.retry_check_interval, me.check_attempts, me.icon, me.enable_snmp, me.snmp_community, me.notification_options, me.notification_period, me.check_command, me.http_admin_url, me.http_admin_port, me.monitored_by, me.uncommitted, me.other_addresses, me.snmp_version, me.snmp_port, me.snmpv3_username, me.snmpv3_authprotocol, me.snmpv3_authpassword, me.snmpv3_privprotocol, me.snmpv3_privpassword, me.snmptrap_tracing, me.use_rancid, me.rancid_vendor, me.rancid_username, me.rancid_password, me.rancid_connection_type, me.rancid_autoenable, me.use_nmis, me.nmis_node_type, me.flap_detection_enabled, me.use_mrtg, me.tidy_ifdescr_level, me.snmp_max_msg_size, me.snmp_extended_throughput_data, me.event_handler FROM opsview.hosts me WHERE ( me.id = ? ) ORDER BY name ASC: '19'
+SELECT me.id, me.name, me.ip, me.alias, me.notification_interval, me.hostgroup, me.check_period, me.check_interval, me.retry_check_interval, me.check_attempts, me.icon, me.enable_snmp, me.snmp_community, me.notification_options, me.notification_period, me.check_command, me.http_admin_url, me.http_admin_port, me.monitored_by, me.uncommitted, me.other_addresses, me.snmp_version, me.snmp_port, me.snmpv3_username, me.snmpv3_authprotocol, me.snmpv3_authpassword, me.snmpv3_privprotocol, me.snmpv3_privpassword, me.snmptrap_tracing, me.use_rancid, me.rancid_vendor, me.rancid_username, me.rancid_password, me.rancid_connection_type, me.rancid_autoenable, me.use_nmis, me.nmis_node_type, me.flap_detection_enabled, me.use_mrtg, me.tidy_ifdescr_level, me.snmp_max_msg_size, me.snmp_extended_throughput_data, me.event_handler FROM opsview.hosts me WHERE ( me.id = ? ) ORDER BY name ASC: '20'
+SELECT me.id, me.name, me.ip, me.alias, me.notification_interval, me.hostgroup, me.check_period, me.check_interval, me.retry_check_interval, me.check_attempts, me.icon, me.enable_snmp, me.snmp_community, me.notification_options, me.notification_period, me.check_command, me.http_admin_url, me.http_admin_port, me.monitored_by, me.uncommitted, me.other_addresses, me.snmp_version, me.snmp_port, me.snmpv3_username, me.snmpv3_authprotocol, me.snmpv3_authpassword, me.snmpv3_privprotocol, me.snmpv3_privpassword, me.snmptrap_tracing, me.use_rancid, me.rancid_vendor, me.rancid_username, me.rancid_password, me.rancid_connection_type, me.rancid_autoenable, me.use_nmis, me.nmis_node_type, me.flap_detection_enabled, me.use_mrtg, me.tidy_ifdescr_level, me.snmp_max_msg_size, me.snmp_extended_throughput_data, me.event_handler FROM opsview.hosts me WHERE ( me.id = ? ) ORDER BY name ASC: '21'
SELECT me.id, me.monitoringcluster, me.host, me.activated, me.passive, me.uncommitted FROM opsview.monitoringclusternodes me WHERE ( me.monitoringcluster = ? ): '2'
-SELECT me.id, me.name, me.ip, me.alias, me.notification_interval, me.hostgroup, me.check_period, me.check_interval, me.retry_check_interval, me.check_attempts, me.icon, me.enable_snmp, me.snmp_community, me.notification_options, me.notification_period, me.check_command, me.http_admin_url, me.http_admin_port, me.monitored_by, me.uncommitted, me.other_addresses, me.snmp_version, me.snmp_port, me.snmpv3_username, me.snmpv3_authprotocol, me.snmpv3_authpassword, me.snmpv3_privprotocol, me.snmpv3_privpassword, me.snmptrap_tracing, me.use_rancid, me.rancid_vendor, me.rancid_username, me.rancid_password, me.rancid_connection_type, me.rancid_autoenable, me.use_nmis, me.nmis_node_type, me.flap_detection_enabled, me.use_mrtg, me.tidy_ifdescr_level, me.snmp_max_msg_size, me.snmp_extended_throughput_data FROM opsview.hosts me WHERE ( me.id = ? ) ORDER BY name ASC: '5'
-SELECT me.id, me.name, me.ip, me.alias, me.notification_interval, me.hostgroup, me.check_period, me.check_interval, me.retry_check_interval, me.check_attempts, me.icon, me.enable_snmp, me.snmp_community, me.notification_options, me.notification_period, me.check_command, me.http_admin_url, me.http_admin_port, me.monitored_by, me.uncommitted, me.other_addresses, me.snmp_version, me.snmp_port, me.snmpv3_username, me.snmpv3_authprotocol, me.snmpv3_authpassword, me.snmpv3_privprotocol, me.snmpv3_privpassword, me.snmptrap_tracing, me.use_rancid, me.rancid_vendor, me.rancid_username, me.rancid_password, me.rancid_connection_type, me.rancid_autoenable, me.use_nmis, me.nmis_node_type, me.flap_detection_enabled, me.use_mrtg, me.tidy_ifdescr_level, me.snmp_max_msg_size, me.snmp_extended_throughput_data FROM opsview.hosts me WHERE ( me.id = ? ) ORDER BY name ASC: '1'
+SELECT me.id, me.name, me.ip, me.alias, me.notification_interval, me.hostgroup, me.check_period, me.check_interval, me.retry_check_interval, me.check_attempts, me.icon, me.enable_snmp, me.snmp_community, me.notification_options, me.notification_period, me.check_command, me.http_admin_url, me.http_admin_port, me.monitored_by, me.uncommitted, me.other_addresses, me.snmp_version, me.snmp_port, me.snmpv3_username, me.snmpv3_authprotocol, me.snmpv3_authpassword, me.snmpv3_privprotocol, me.snmpv3_privpassword, me.snmptrap_tracing, me.use_rancid, me.rancid_vendor, me.rancid_username, me.rancid_password, me.rancid_connection_type, me.rancid_autoenable, me.use_nmis, me.nmis_node_type, me.flap_detection_enabled, me.use_mrtg, me.tidy_ifdescr_level, me.snmp_max_msg_size, me.snmp_extended_throughput_data, me.event_handler FROM opsview.hosts me WHERE ( me.id = ? ) ORDER BY name ASC: '5'
+SELECT me.id, me.name, me.ip, me.alias, me.notification_interval, me.hostgroup, me.check_period, me.check_interval, me.retry_check_interval, me.check_attempts, me.icon, me.enable_snmp, me.snmp_community, me.notification_options, me.notification_period, me.check_command, me.http_admin_url, me.http_admin_port, me.monitored_by, me.uncommitted, me.other_addresses, me.snmp_version, me.snmp_port, me.snmpv3_username, me.snmpv3_authprotocol, me.snmpv3_authpassword, me.snmpv3_privprotocol, me.snmpv3_privpassword, me.snmptrap_tracing, me.use_rancid, me.rancid_vendor, me.rancid_username, me.rancid_password, me.rancid_connection_type, me.rancid_autoenable, me.use_nmis, me.nmis_node_type, me.flap_detection_enabled, me.use_mrtg, me.tidy_ifdescr_level, me.snmp_max_msg_size, me.snmp_extended_throughput_data, me.event_handler FROM opsview.hosts me WHERE ( me.id = ? ) ORDER BY name ASC: '1'
SELECT me.id, me.monitoringcluster, me.host, me.activated, me.passive, me.uncommitted FROM opsview.monitoringclusternodes me WHERE ( me.monitoringcluster = ? ): '4'
-SELECT me.id, me.name, me.ip, me.alias, me.notification_interval, me.hostgroup, me.check_period, me.check_interval, me.retry_check_interval, me.check_attempts, me.icon, me.enable_snmp, me.snmp_community, me.notification_options, me.notification_period, me.check_command, me.http_admin_url, me.http_admin_port, me.monitored_by, me.uncommitted, me.other_addresses, me.snmp_version, me.snmp_port, me.snmpv3_username, me.snmpv3_authprotocol, me.snmpv3_authpassword, me.snmpv3_privprotocol, me.snmpv3_privpassword, me.snmptrap_tracing, me.use_rancid, me.rancid_vendor, me.rancid_username, me.rancid_password, me.rancid_connection_type, me.rancid_autoenable, me.use_nmis, me.nmis_node_type, me.flap_detection_enabled, me.use_mrtg, me.tidy_ifdescr_level, me.snmp_max_msg_size, me.snmp_extended_throughput_data FROM opsview.hosts me WHERE ( me.id = ? ) ORDER BY name ASC: '23'
+SELECT me.id, me.name, me.ip, me.alias, me.notification_interval, me.hostgroup, me.check_period, me.check_interval, me.retry_check_interval, me.check_attempts, me.icon, me.enable_snmp, me.snmp_community, me.notification_options, me.notification_period, me.check_command, me.http_admin_url, me.http_admin_port, me.monitored_by, me.uncommitted, me.other_addresses, me.snmp_version, me.snmp_port, me.snmpv3_username, me.snmpv3_authprotocol, me.snmpv3_authpassword, me.snmpv3_privprotocol, me.snmpv3_privpassword, me.snmptrap_tracing, me.use_rancid, me.rancid_vendor, me.rancid_username, me.rancid_password, me.rancid_connection_type, me.rancid_autoenable, me.use_nmis, me.nmis_node_type, me.flap_detection_enabled, me.use_mrtg, me.tidy_ifdescr_level, me.snmp_max_msg_size, me.snmp_extended_throughput_data, me.event_handler FROM opsview.hosts me WHERE ( me.id = ? ) ORDER BY name ASC: '23'
SELECT me.name, me.filename FROM opsview.icons me WHERE ( me.name = ? ): 'SYMBOL - Environment Monitor'
SELECT me.id, me.name, me.alias, me.sunday, me.monday, me.tuesday, me.wednesday, me.thursday, me.friday, me.saturday, me.uncommitted FROM opsview.timeperiods me WHERE ( me.id = ? ) ORDER BY name: '1'
SELECT me.id, me.name, me.plugin, me.args, me.priority, me.uncommitted FROM opsview.hostcheckcommands me WHERE ( me.id = ? ) ORDER BY priority, name: '1'
@@ -406,8 +407,8 @@
SELECT me.notificationmethodid, me.name, me.value FROM opsview.notificationmethod_variables me WHERE ( me.notificationmethodid = ? ) ORDER BY name: '1'
SELECT me.notificationmethodid, me.name, me.value FROM opsview.notificationmethod_variables me WHERE ( me.notificationmethodid = ? ) ORDER BY name: '4'
SELECT COUNT( * ) FROM opsview.hosts me WHERE ( ( enable_snmp = ? AND use_nmis = ? ) ): '1', '1'
-SELECT me.id, me.name, me.ip, me.alias, me.notification_interval, me.hostgroup, me.check_period, me.check_interval, me.retry_check_interval, me.check_attempts, me.icon, me.enable_snmp, me.snmp_community, me.notification_options, me.notification_period, me.check_command, me.http_admin_url, me.http_admin_port, me.monitored_by, me.uncommitted, me.other_addresses, me.snmp_version, me.snmp_port, me.snmpv3_username, me.snmpv3_authprotocol, me.snmpv3_authpassword, me.snmpv3_privprotocol, me.snmpv3_privpassword, me.snmptrap_tracing, me.use_rancid, me.rancid_vendor, me.rancid_username, me.rancid_password, me.rancid_connection_type, me.rancid_autoenable, me.use_nmis, me.nmis_node_type, me.flap_detection_enabled, me.use_mrtg, me.tidy_ifdescr_level, me.snmp_max_msg_size, me.snmp_extended_throughput_data FROM opsview.hosts me WHERE ( me.id = ? ) ORDER BY name ASC: '1'
-SELECT me.id, me.name, me.ip, me.alias, me.notification_interval, me.hostgroup, me.check_period, me.check_interval, me.retry_check_interval, me.check_attempts, me.icon, me.enable_snmp, me.snmp_community, me.notification_options, me.notification_period, me.check_command, me.http_admin_url, me.http_admin_port, me.monitored_by, me.uncommitted, me.other_addresses, me.snmp_version, me.snmp_port, me.snmpv3_username, me.snmpv3_authprotocol, me.snmpv3_authpassword, me.snmpv3_privprotocol, me.snmpv3_privpassword, me.snmptrap_tracing, me.use_rancid, me.rancid_vendor, me.rancid_username, me.rancid_password, me.rancid_connection_type, me.rancid_autoenable, me.use_nmis, me.nmis_node_type, me.flap_detection_enabled, me.use_mrtg, me.tidy_ifdescr_level, me.snmp_max_msg_size, me.snmp_extended_throughput_data FROM opsview.hosts me WHERE ( me.monitored_by = ? ) ORDER BY name ASC: '1'
+SELECT me.id, me.name, me.ip, me.alias, me.notification_interval, me.hostgroup, me.check_period, me.check_interval, me.retry_check_interval, me.check_attempts, me.icon, me.enable_snmp, me.snmp_community, me.notification_options, me.notification_period, me.check_command, me.http_admin_url, me.http_admin_port, me.monitored_by, me.uncommitted, me.other_addresses, me.snmp_version, me.snmp_port, me.snmpv3_username, me.snmpv3_authprotocol, me.snmpv3_authpassword, me.snmpv3_privprotocol, me.snmpv3_privpassword, me.snmptrap_tracing, me.use_rancid, me.rancid_vendor, me.rancid_username, me.rancid_password, me.rancid_connection_type, me.rancid_autoenable, me.use_nmis, me.nmis_node_type, me.flap_detection_enabled, me.use_mrtg, me.tidy_ifdescr_level, me.snmp_max_msg_size, me.snmp_extended_throughput_data, me.event_handler FROM opsview.hosts me WHERE ( me.id = ? ) ORDER BY name ASC: '1'
+SELECT me.id, me.name, me.ip, me.alias, me.notification_interval, me.hostgroup, me.check_period, me.check_interval, me.retry_check_interval, me.check_attempts, me.icon, me.enable_snmp, me.snmp_community, me.notification_options, me.notification_period, me.check_command, me.http_admin_url, me.http_admin_port, me.monitored_by, me.uncommitted, me.other_addresses, me.snmp_version, me.snmp_port, me.snmpv3_username, me.snmpv3_authprotocol, me.snmpv3_authpassword, me.snmpv3_privprotocol, me.snmpv3_privpassword, me.snmptrap_tracing, me.use_rancid, me.rancid_vendor, me.rancid_username, me.rancid_password, me.rancid_connection_type, me.rancid_autoenable, me.use_nmis, me.nmis_node_type, me.flap_detection_enabled, me.use_mrtg, me.tidy_ifdescr_level, me.snmp_max_msg_size, me.snmp_extended_throughput_data, me.event_handler FROM opsview.hosts me WHERE ( me.monitored_by = ? ) ORDER BY name ASC: '1'
SELECT me.id, me.hostid, me.interfacename, me.active, me.throughput_warning, me.throughput_critical, me.errors_warning, me.errors_critical, me.discards_warning, me.discards_critical, me.shortinterfacename, me.indexid FROM opsview.hostsnmpinterfaces me WHERE ( ( active = ? AND me.hostid = ? ) ) ORDER BY interfacename: '1', '11'
SELECT me.id, me.hostid, me.interfacename, me.active, me.throughput_warning, me.throughput_critical, me.errors_warning, me.errors_critical, me.discards_warning, me.discards_critical, me.shortinterfacename, me.indexid FROM opsview.hostsnmpinterfaces me WHERE ( ( interfacename = ? AND me.hostid = ? ) ) ORDER BY interfacename: '', '11'
SELECT me.id, me.hostid, me.interfacename, me.active, me.throughput_warning, me.throughput_critical, me.errors_warning, me.errors_critical, me.discards_warning, me.discards_critical, me.shortinterfacename, me.indexid FROM opsview.hostsnmpinterfaces me WHERE ( ( active = ? AND me.hostid = ? ) ) ORDER BY interfacename: '1', '3'
