Modified: trunk/opsview-core/bin/nagconfgen.pl
===================================================================
--- trunk/opsview-core/bin/nagconfgen.pl 2013-08-13 01:28:25 UTC (rev 13211)
+++ trunk/opsview-core/bin/nagconfgen.pl 2013-08-13 01:49:06 UTC (rev 13212)
@@ -553,7 +553,7 @@
( @{ $parents_lookup->{$hostid} } );
my $host_monitored_by_this_opsview_server =
- ( $monitoringserver == $host->monitored_by );
+ ( $monitoringserver == $host->get_column("monitored_by") );
# Lookup and cache host IP's for checking potential
# MRTG configuration errors
@@ -650,7 +650,7 @@
}
if ( defined $host->check_period ) {
- print OUTFILE ' check_period ' . $host->check_period, $/;
+ print OUTFILE ' check_period ' . $host->check_period->name, $/;
}
print OUTFILE " contact_groups " . join( ",", @cgs ) . "\n" if (@cgs);
@@ -830,17 +830,22 @@
}
my $host_monitored_by_this_opsview_server =
- ( $monitoringserver == $h->monitored_by );
+ ( $monitoringserver == $h->get_column("monitored_by") );
my $array = $h->resolved_servicechecks;
foreach my $sc (@$array) {
next if $sc->{remove_servicecheck};
my $s = $sc->{servicecheck};
+
+ # Use variables to save Class::DBI accessors
+ my $checktype = $s->checktype->id;
+ my $servicename = $s->name;
+
next
- if $s->checktype->id == 3; # Ignore basic snmptrap servicechecks
+ if $checktype == 3; # Ignore basic snmptrap servicechecks
# Ignore SNMP traps as these are no longer available in Core
- if ( $s->checktype->id == 4 ) {
+ if ( $checktype == 4 ) {
next;
}
@@ -848,7 +853,7 @@
# if there are no INTERFACE attributes set. This probably should be some configuration
# on the Interface Poller servicecheck (eg, a tickbox of "Create X services per attribute"
# with default X, but an option of 1). However, we'll just hard code here for now
- if ( $s->name eq "Interface Poller" ) {
+ if ( $servicename eq "Interface Poller" ) {
next if $h->snmpinterfaces( { active => 1 } )->count == 0;
}
@@ -856,14 +861,13 @@
# and the relationship is not present
# We do this early because if this service check is a multiple one but there are no attributes set, then just ignore
my $multiple_services_id =
- ( $s->checktype->id =~ /^(1|2)$/ && $s->attribute )
+ ( $checktype =~ /^(1|2)$/ && $s->attribute )
? $s->attribute
: 0;
my @multiple_service_attributes = ();
if ($multiple_services_id) {
my $multiple_services_attribute_name =
- $schema->resultset("Attributes")->find($multiple_services_id)
- ->name;
+ get_attribute_name($multiple_services_id);
# Ignore these attributes, as not available in Core
if ( $multiple_services_attribute_name eq "SLAVENODE" ) {
@@ -886,14 +890,15 @@
# Add keywords, if appropriate. Deliberately ignore host=* and service=*
if ( my $keywordid_hashref =
$keyword_host_service_lookup->{ $h->name }->{services}
- ->{ $s->name } )
+ ->{$servicename} )
{
foreach my $keyword_id ( keys %$keywordid_hashref ) {
push @contactgroup_keywordids, $keyword_id;
}
}
if ( my $keywordid_hashref =
- $keyword_host_service_lookup->{"*"}->{services}->{ $s->name } )
+ $keyword_host_service_lookup->{"*"}->{services}->{$servicename}
+ )
{
foreach my $keyword_id ( keys %$keywordid_hashref ) {
push @contactgroup_keywordids, $keyword_id;
@@ -925,7 +930,7 @@
if ( !$host_monitored_by_this_opsview_server ) {
$commandalias = "set_to_stale";
}
- elsif ( $s->checktype->id == 1 ) {
+ elsif ( $checktype == 1 ) {
$commandalias = $h->expand_host_macros(
$s->command(
args => $sc->{args},
@@ -939,7 +944,7 @@
$h->substitute_host_attributes($commandalias);
}
}
- elsif ( $s->checktype->id == 4 || $s->checktype->id == 2 ) {
+ elsif ( $checktype == 4 || $checktype == 2 ) {
# You would think that these should only be set if check_freshness==1, but Nagios wants some command alias to
# get set
@@ -957,7 +962,7 @@
);
}
}
- elsif ( $s->checktype->id == 5 ) { # SNMP polling
+ elsif ( $checktype == 5 ) { # SNMP polling
# Ignore these types of checks unless SNMP enabled
next unless $h->enable_snmp;
@@ -1039,14 +1044,13 @@
my $check_interval = $s->check_interval
|| ( 5 * $nagios_interval_convert_from_minutes );
- my $servicename = $s->name;
print OUTFILE "# "
- . $s->name
+ . $servicename
. " service definition for host "
. $h->name . "
define service {
host_name " . $h->name . "
- service_description " . $s->name . "
+ service_description " . $servicename . "
check_command $commandalias
retry_check_interval "
. ( $s->retry_check_interval
@@ -1105,7 +1109,7 @@
# Active checks respect the check_attempts and flap_detection_enabled in the database
# Otherwise, check_attempts should be 1 for passive checks/SNMPtraps
- if ( $s->checktype->id == 1 or $s->checktype->id == 5 ) {
+ if ( $checktype == 1 or $checktype == 5 ) {
print OUTFILE " max_check_attempts "
. ( $s->check_attempts || 3 ) . "\n";
print OUTFILE " flap_detection_enabled "
@@ -1129,8 +1133,8 @@
if (
!(
(
- $s->checktype->id == 1
- or $s->checktype->id == 5
+ $checktype == 1
+ or $checktype == 5
)
&& ($host_monitored_by_this_opsview_server)
)
@@ -1167,7 +1171,7 @@
# Resubmit passive checks for advanced snmptraps + passive checks if renotify is set
# Only apply to slave as master may get extraneous stale results
- if ( ( $s->checktype->id == 4 || $s->checktype->id == 2 )
+ if ( ( $checktype == 4 || $checktype == 2 )
&& $s->check_freshness
&& $host_monitored_by_this_opsview_server
&& $s->freshness_type eq "renotify" )
@@ -1184,7 +1188,7 @@
";
}
- if ( ( $s->checktype->id == 4 || $s->checktype->id == 2 )
+ if ( ( $checktype == 4 || $checktype == 2 )
&& $s->check_freshness
&& $host_monitored_by_this_opsview_server
&& $s->freshness_type eq "set_stale" )
@@ -1226,8 +1230,8 @@
if (
(
- $s->checktype->id == 1
- or $s->checktype->id == 5
+ $checktype == 1
+ or $checktype == 5
)
&& !$host_monitored_by_this_opsview_server
)
@@ -1269,7 +1273,7 @@
if ( !$multiple_services_id ) {
print OUTFILE "}\n\n";
- $host_services_lookup->{ $h->name }->{ $s->name } = 1;
+ $host_services_lookup->{ $h->name }->{$servicename} = 1;
}
else {
my $template_name = "multiple-" . $h->id . "-" . $s->id;
@@ -1284,7 +1288,8 @@
my $subst_command =
$h->substitute_host_attributes( $commandalias,
$overrides );
- my $service_desc = $s->name . ": " . $host_attribute->value;
+ my $service_desc =
+ $servicename . ": " . $host_attribute->value;
if ( length $service_desc > 128 ) {
die(
@@ -1294,7 +1299,7 @@
# Save list of multiple service checks for creating dependencies
push
- @{ $multiple_services_lookup->{ $h->name }->{ $s->name }
+ @{ $multiple_services_lookup->{ $h->name }->{$servicename}
}, $service_desc;
print OUTFILE "define service {
@@ -4579,3 +4584,20 @@
? $notification_interval
: $check_interval;
}
+
+my $attribute_name_cache = {};
+
+sub get_attribute_name {
+ my $aid = $_[0];
+ if ( !$attribute_name_cache->{$aid} ) {
+ $attribute_name_cache->{$aid} =
+ $schema->resultset("Attributes")->find($aid)->name;
+ }
+ return $attribute_name_cache->{$aid};
+}
+
+my $timeperiod_cache = {};
+
+sub get_timeperiod {
+}
+
Property changes on: trunk/opsview-core/bin/nagconfgen.pl
___________________________________________________________________
Added: svn:mergeinfo
+ /branches/DEV-capside/release-3.9.0/opsview-core/bin/nagconfgen.pl:6365-6370
/branches/DEV-extra-notification-data/opsview-core/bin/nagconfgen.pl:6734-6746
/branches/DEV-odw-calculations/opsview-core/bin/nagconfgen.pl:9016-9160
/branches/DEV-restapi-monitoringservers/opsview-core/bin/nagconfgen.pl:9778
/branches/DEV-snmp-multi/opsview-core/bin/nagconfgen.pl:7324-7376
/branches/US187/opsview-core/bin/nagconfgen.pl:9403-9479
/branches/US198b/opsview-core/bin/nagconfgen.pl:8875-8994
/branches/US310/opsview-core/bin/nagconfgen.pl:9851-9873
/branches/US539/opsview-core/bin/nagconfgen.pl:12178-12182
/branches/enterprise/BRAN-3.14/opsview-core/bin/nagconfgen.pl:6874,6882,6956
/branches/enterprise/DEV-professional/opsview-core/bin/nagconfgen.pl:6494-8475,8477-8478,8486,8490,8492,8494,8499-8500,8515,8518-8519,8524,8527-8529,8531-8532,8536,8538,8540-8544,8547-8552,8554,8557,8600-8601,8637,8749,8772,8897,8917,8944-8945,8947,8950-8952,8967,8969,8979,8982,8987,8998,9006,9008,9011,9013,9026,9033-9036,9038,9040,9042,9044,9048,9050-9053,9062,9064-9065,9069,9078,9081,9088,9096,9099-9101,9103,9105,9115,9118,9347,9353-9354,9411,9432,9445,9486,9538-9550,9569-9571,9620,9635,9637-9638,9645-9647,9693,9699,9721,9814,9825,9857,9879,9881,9939,10002,10029,10038-10041,10070,10086,10093,10345,10347,10388,10407,10481,10549,10560-10562,10565,10568,10571,10577,10932,11025,11035,11360-11612,11798-11799,11920,12075-12076,12096,12189,12207,12232,12266,12288,12322,12334,12355,12372,12401-12406,12428,12491,12539-12540,12544,12555,12580,12583,12599,12609,12611,12615,12645,12653,12663,12744
/branches/enterprise/DEV-professional/opsview-core/bin-protected/nagconfgen.pl:13211
/branches/nagvis-iframe/opsview-core/bin/nagconfgen.pl:9764-9786
/branches/opsview2runtime/opsview-core/bin/nagconfgen.pl:10960-11258
/branches/opsview2runtime_xs/opsview-core/bin/nagconfgen.pl:11279-11303
/branches/us168/opsview-core/bin/nagconfgen.pl:8759,8762-8763,8766-8768,8770,8774-8777,8794,8798-8799,8801-8803,8821-8822,8834,8837-8838,8932,8937,8947,8969,8977,8981,9004,9007,9009-9010,9012,9024,9049
/commercial/branches/BRAN-4.2/opsview-core/bin/nagconfgen.pl:10944,11017
/commercial/branches/BRAN-4.3/opsview-core/bin/nagconfgen.pl:12423-12426
/commercial/branches/US306-slaves/opsview-core/bin/nagconfgen.pl:9804-9823
/commercial/branches/US307-network-map/opsview-core/bin/nagconfgen.pl:9685-9837
Modified: trunk/opsview-core/lib/Opsview/Schema/Hosts.pm
===================================================================
--- trunk/opsview-core/lib/Opsview/Schema/Hosts.pm 2013-08-13 01:28:25 UTC (rev 13211)
+++ trunk/opsview-core/lib/Opsview/Schema/Hosts.pm 2013-08-13 01:49:06 UTC (rev 13212)
@@ -1109,6 +1109,9 @@
$overrides );
}
+# Cache: speeds up lookup
+my $interface_attributes_cached;
+
# Use this at nagconfgen because you may want to read in dynamic host attributes
sub host_attributes_for_name {
my ( $self, $host_attr_name, $exclude_clustered_slaves ) = @_;
@@ -1178,9 +1181,10 @@
if ( $self->enable_snmp ) {
- my $interface_attributes =
- $self->result_source->schema->resultset("Attributes")
- ->find( { name => "INTERFACE" } );
+ my $interface_attributes = $interface_attributes_cached
+ || ( $interface_attributes_cached =
+ $self->result_source->schema->resultset("Attributes")
+ ->find( { name => "INTERFACE" } ) );
my $default_thresholds =
$self->snmpinterfaces( { interfacename => "" } )->first;
@@ -1301,7 +1305,10 @@
else {
@results = $self->hostattributes(
{ "attribute.name" => $host_attr_name },
- { join => "attribute" }
+ {
+ prefetch => "attribute",
+ join => "attribute",
+ }
);
}
return @results;
Modified: trunk/opsview-core/t/var/configs/dbic_trace
===================================================================
--- trunk/opsview-core/t/var/configs/dbic_trace 2013-08-13 01:28:25 UTC (rev 13211)
+++ trunk/opsview-core/t/var/configs/dbic_trace 2013-08-13 01:49:06 UTC (rev 13212)
@@ -41,58 +41,40 @@
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'
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.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9, me.internally_generated, me.label1, me.label2, me.label3, me.label4, me.label5, me.label6, me.label7, me.label8, me.label9, me.uncommitted FROM opsview.attributes me WHERE ( me.id = ? ) ORDER BY internally_generated, name: '2'
SELECT COUNT( * ) FROM opsview.hostsnmpinterfaces me WHERE ( ( active = ? AND me.hostid = ? ) ): '1', '7'
-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'
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.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.host, me.role, me.activated, me.passive, me.uncommitted FROM opsview.monitoringservers me WHERE ( me.id = ? ): '1'
-SELECT me.id, me.name, me.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9, me.internally_generated, me.label1, me.label2, me.label3, me.label4, me.label5, me.label6, me.label7, me.label8, me.label9, me.uncommitted FROM opsview.attributes me WHERE ( me.id = ? ) ORDER BY internally_generated, name: '2'
SELECT me.id, me.name, me.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9, me.internally_generated, me.label1, me.label2, me.label3, me.label4, me.label5, me.label6, me.label7, me.label8, me.label9, me.uncommitted FROM opsview.attributes me WHERE ( me.name = ? ) ORDER BY internally_generated, name: 'INTERFACE'
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', '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.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.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9, me.internally_generated, me.label1, me.label2, me.label3, me.label4, me.label5, me.label6, me.label7, me.label8, me.label9, me.uncommitted FROM opsview.attributes me WHERE ( me.id = ? ) ORDER BY internally_generated, name: '2'
-SELECT me.id, me.name, me.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9, me.internally_generated, me.label1, me.label2, me.label3, me.label4, me.label5, me.label6, me.label7, me.label8, me.label9, me.uncommitted FROM opsview.attributes me WHERE ( me.name = ? ) ORDER BY internally_generated, name: 'INTERFACE'
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', '11'
-SELECT me.id, me.name, me.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9, me.internally_generated, me.label1, me.label2, me.label3, me.label4, me.label5, me.label6, me.label7, me.label8, me.label9, me.uncommitted FROM opsview.attributes me WHERE ( me.id = ? ) ORDER BY internally_generated, name: '2'
-SELECT me.id, me.name, me.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9, me.internally_generated, me.label1, me.label2, me.label3, me.label4, me.label5, me.label6, me.label7, me.label8, me.label9, me.uncommitted FROM opsview.attributes me WHERE ( me.name = ? ) ORDER BY internally_generated, name: 'INTERFACE'
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', '11'
SELECT COUNT( * ) FROM opsview.hostsnmpinterfaces me WHERE ( ( active = ? AND me.hostid = ? ) ): '1', '11'
-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'
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.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'
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.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'
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.host, me.role, me.activated, me.passive, me.uncommitted FROM opsview.monitoringservers me WHERE ( me.id = ? ): '1'
-SELECT me.id, me.name, me.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9, me.internally_generated, me.label1, me.label2, me.label3, me.label4, me.label5, me.label6, me.label7, me.label8, me.label9, me.uncommitted FROM opsview.attributes me WHERE ( me.id = ? ) ORDER BY internally_generated, name: '2'
-SELECT me.id, me.name, me.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9, me.internally_generated, me.label1, me.label2, me.label3, me.label4, me.label5, me.label6, me.label7, me.label8, me.label9, me.uncommitted FROM opsview.attributes me WHERE ( me.name = ? ) ORDER BY internally_generated, name: 'INTERFACE'
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: '', '3'
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'
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.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 COUNT( * ) FROM opsview.hostsnmpinterfaces me WHERE ( ( active = ? AND me.hostid = ? ) ): '1', '3'
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: '2'
-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.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9, me.internally_generated, me.label1, me.label2, me.label3, me.label4, me.label5, me.label6, me.label7, me.label8, me.label9, me.uncommitted FROM opsview.attributes me WHERE ( me.id = ? ) ORDER BY internally_generated, name: '2'
-SELECT me.id, me.name, me.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9, me.internally_generated, me.label1, me.label2, me.label3, me.label4, me.label5, me.label6, me.label7, me.label8, me.label9, me.uncommitted FROM opsview.attributes me WHERE ( me.name = ? ) ORDER BY internally_generated, name: 'INTERFACE'
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: '', '13'
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', '13'
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.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 COUNT( * ) FROM opsview.hostsnmpinterfaces me WHERE ( ( active = ? AND me.hostid = ? ) ): '1', '13'
-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: '2'
SELECT me.host, me.attribute, me.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9, attribute.id, attribute.name, attribute.value, attribute.arg1, attribute.arg2, attribute.arg3, attribute.arg4, attribute.arg5, attribute.arg6, attribute.arg7, attribute.arg8, attribute.arg9, attribute.internally_generated, attribute.label1, attribute.label2, attribute.label3, attribute.label4, attribute.label5, attribute.label6, attribute.label7, attribute.label8, attribute.label9, attribute.uncommitted FROM (SELECT me.host, me.attribute, me.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9 FROM opsview.host_attributes me JOIN opsview.attributes attribute ON attribute.id = me.attribute WHERE ( me.host = ? ) GROUP BY attribute.name, me.value ORDER BY attribute.name, me.value) me JOIN opsview.attributes attribute ON attribute.id = me.attribute WHERE ( me.host = ? ) ORDER BY attribute.name, me.value: '1', '1'
SELECT me.id, me.name, me.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9, me.internally_generated, me.label1, me.label2, me.label3, me.label4, me.label5, me.label6, me.label7, me.label8, me.label9, me.uncommitted FROM opsview.attributes me WHERE ( me.name = ? ) ORDER BY internally_generated, name: 'MYSQL_CREDENTIALS'
@@ -100,51 +82,27 @@
SELECT me.id, me.name, me.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9, me.internally_generated, me.label1, me.label2, me.label3, me.label4, me.label5, me.label6, me.label7, me.label8, me.label9, me.uncommitted FROM opsview.attributes me WHERE ( me.name = ? ) ORDER BY internally_generated, name: 'MYSQL_CREDENTIALS'
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.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9, me.internally_generated, me.label1, me.label2, me.label3, me.label4, me.label5, me.label6, me.label7, me.label8, me.label9, me.uncommitted FROM opsview.attributes me WHERE ( me.id = ? ) ORDER BY internally_generated, name: '6'
-SELECT me.host, me.attribute, me.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9 FROM opsview.host_attributes me JOIN opsview.attributes attribute ON attribute.id = me.attribute WHERE ( ( attribute.name = ? AND me.host = ? ) ) ORDER BY attribute.name, me.value: 'PROCESS', '1'
-SELECT me.id, me.name, me.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9, me.internally_generated, me.label1, me.label2, me.label3, me.label4, me.label5, me.label6, me.label7, me.label8, me.label9, me.uncommitted FROM opsview.attributes me WHERE ( me.id = ? ) ORDER BY internally_generated, name: '6'
-SELECT me.id, me.name, me.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9, me.internally_generated, me.label1, me.label2, me.label3, me.label4, me.label5, me.label6, me.label7, me.label8, me.label9, me.uncommitted FROM opsview.attributes me WHERE ( me.id = ? ) ORDER BY internally_generated, name: '6'
+SELECT me.host, me.attribute, me.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9, attribute.id, attribute.name, attribute.value, attribute.arg1, attribute.arg2, attribute.arg3, attribute.arg4, attribute.arg5, attribute.arg6, attribute.arg7, attribute.arg8, attribute.arg9, attribute.internally_generated, attribute.label1, attribute.label2, attribute.label3, attribute.label4, attribute.label5, attribute.label6, attribute.label7, attribute.label8, attribute.label9, attribute.uncommitted FROM opsview.host_attributes me JOIN opsview.attributes attribute ON attribute.id = me.attribute WHERE ( ( attribute.name = ? AND me.host = ? ) ) ORDER BY attribute.name, me.value: 'PROCESS', '1'
SELECT me.id, me.name, me.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9, me.internally_generated, me.label1, me.label2, me.label3, me.label4, me.label5, me.label6, me.label7, me.label8, me.label9, me.uncommitted FROM opsview.attributes me WHERE ( me.id = ? ) ORDER BY internally_generated, name: '1'
-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.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9, me.internally_generated, me.label1, me.label2, me.label3, me.label4, me.label5, me.label6, me.label7, me.label8, me.label9, me.uncommitted FROM opsview.attributes me WHERE ( me.id = ? ) ORDER BY internally_generated, name: '4'
-SELECT me.host, me.attribute, me.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9 FROM opsview.host_attributes me JOIN opsview.attributes attribute ON attribute.id = me.attribute WHERE ( ( attribute.name = ? AND me.host = ? ) ) ORDER BY attribute.name, me.value: 'DISK', '2'
+SELECT me.host, me.attribute, me.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9, attribute.id, attribute.name, attribute.value, attribute.arg1, attribute.arg2, attribute.arg3, attribute.arg4, attribute.arg5, attribute.arg6, attribute.arg7, attribute.arg8, attribute.arg9, attribute.internally_generated, attribute.label1, attribute.label2, attribute.label3, attribute.label4, attribute.label5, attribute.label6, attribute.label7, attribute.label8, attribute.label9, attribute.uncommitted FROM opsview.host_attributes me JOIN opsview.attributes attribute ON attribute.id = me.attribute WHERE ( ( attribute.name = ? AND me.host = ? ) ) ORDER BY attribute.name, me.value: 'DISK', '2'
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: '2'
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.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9, me.internally_generated, me.label1, me.label2, me.label3, me.label4, me.label5, me.label6, me.label7, me.label8, me.label9, me.uncommitted FROM opsview.attributes me WHERE ( me.id = ? ) ORDER BY internally_generated, name: '4'
-SELECT me.id, me.name, me.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9, me.internally_generated, me.label1, me.label2, me.label3, me.label4, me.label5, me.label6, me.label7, me.label8, me.label9, me.uncommitted FROM opsview.attributes me WHERE ( me.id = ? ) ORDER BY internally_generated, name: '4'
-SELECT me.host, me.attribute, me.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9 FROM opsview.host_attributes me JOIN opsview.attributes attribute ON attribute.id = me.attribute WHERE ( ( attribute.name = ? AND me.host = ? ) ) ORDER BY attribute.name, me.value: 'DISK', '2'
-SELECT me.id, me.name, me.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9, me.internally_generated, me.label1, me.label2, me.label3, me.label4, me.label5, me.label6, me.label7, me.label8, me.label9, me.uncommitted FROM opsview.attributes me WHERE ( me.id = ? ) ORDER BY internally_generated, name: '4'
-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.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9, me.internally_generated, me.label1, me.label2, me.label3, me.label4, me.label5, me.label6, me.label7, me.label8, me.label9, me.uncommitted FROM opsview.attributes me WHERE ( me.id = ? ) ORDER BY internally_generated, name: '4'
-SELECT me.host, me.attribute, me.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9 FROM opsview.host_attributes me JOIN opsview.attributes attribute ON attribute.id = me.attribute WHERE ( ( attribute.name = ? AND me.host = ? ) ) ORDER BY attribute.name, me.value: 'DISK', '18'
+SELECT me.host, me.attribute, me.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9, attribute.id, attribute.name, attribute.value, attribute.arg1, attribute.arg2, attribute.arg3, attribute.arg4, attribute.arg5, attribute.arg6, attribute.arg7, attribute.arg8, attribute.arg9, attribute.internally_generated, attribute.label1, attribute.label2, attribute.label3, attribute.label4, attribute.label5, attribute.label6, attribute.label7, attribute.label8, attribute.label9, attribute.uncommitted FROM opsview.host_attributes me JOIN opsview.attributes attribute ON attribute.id = me.attribute WHERE ( ( attribute.name = ? AND me.host = ? ) ) ORDER BY attribute.name, me.value: 'DISK', '2'
+SELECT me.host, me.attribute, me.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9, attribute.id, attribute.name, attribute.value, attribute.arg1, attribute.arg2, attribute.arg3, attribute.arg4, attribute.arg5, attribute.arg6, attribute.arg7, attribute.arg8, attribute.arg9, attribute.internally_generated, attribute.label1, attribute.label2, attribute.label3, attribute.label4, attribute.label5, attribute.label6, attribute.label7, attribute.label8, attribute.label9, attribute.uncommitted FROM opsview.host_attributes me JOIN opsview.attributes attribute ON attribute.id = me.attribute WHERE ( ( attribute.name = ? AND me.host = ? ) ) ORDER BY attribute.name, me.value: 'DISK', '18'
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: '2'
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.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9, me.internally_generated, me.label1, me.label2, me.label3, me.label4, me.label5, me.label6, me.label7, me.label8, me.label9, me.uncommitted FROM opsview.attributes me WHERE ( me.id = ? ) ORDER BY internally_generated, name: '4'
-SELECT me.id, me.name, me.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9, me.internally_generated, me.label1, me.label2, me.label3, me.label4, me.label5, me.label6, me.label7, me.label8, me.label9, me.uncommitted FROM opsview.attributes me WHERE ( me.id = ? ) ORDER BY internally_generated, name: '4'
-SELECT me.id, me.name, me.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9, me.internally_generated, me.label1, me.label2, me.label3, me.label4, me.label5, me.label6, me.label7, me.label8, me.label9, me.uncommitted FROM opsview.attributes me WHERE ( me.id = ? ) ORDER BY internally_generated, name: '4'
-SELECT me.host, me.attribute, me.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9 FROM opsview.host_attributes me JOIN opsview.attributes attribute ON attribute.id = me.attribute WHERE ( ( attribute.name = ? AND me.host = ? ) ) ORDER BY attribute.name, me.value: 'DISK', '18'
-SELECT me.id, me.name, me.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9, me.internally_generated, me.label1, me.label2, me.label3, me.label4, me.label5, me.label6, me.label7, me.label8, me.label9, me.uncommitted FROM opsview.attributes me WHERE ( me.id = ? ) ORDER BY internally_generated, name: '4'
-SELECT me.id, me.name, me.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9, me.internally_generated, me.label1, me.label2, me.label3, me.label4, me.label5, me.label6, me.label7, me.label8, me.label9, me.uncommitted FROM opsview.attributes me WHERE ( me.id = ? ) ORDER BY internally_generated, name: '4'
-SELECT me.id, me.name, me.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9, me.internally_generated, me.label1, me.label2, me.label3, me.label4, me.label5, me.label6, me.label7, me.label8, me.label9, me.uncommitted FROM opsview.attributes me WHERE ( me.id = ? ) ORDER BY internally_generated, name: '4'
-SELECT me.host, me.attribute, me.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9 FROM opsview.host_attributes me JOIN opsview.attributes attribute ON attribute.id = me.attribute WHERE ( ( attribute.name = ? AND me.host = ? ) ) ORDER BY attribute.name, me.value: 'DISK', '18'
-SELECT me.id, me.name, me.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9, me.internally_generated, me.label1, me.label2, me.label3, me.label4, me.label5, me.label6, me.label7, me.label8, me.label9, me.uncommitted FROM opsview.attributes me WHERE ( me.id = ? ) ORDER BY internally_generated, name: '4'
-SELECT me.id, me.name, me.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9, me.internally_generated, me.label1, me.label2, me.label3, me.label4, me.label5, me.label6, me.label7, me.label8, me.label9, me.uncommitted FROM opsview.attributes me WHERE ( me.id = ? ) ORDER BY internally_generated, name: '4'
-SELECT me.id, me.name, me.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9, me.internally_generated, me.label1, me.label2, me.label3, me.label4, me.label5, me.label6, me.label7, me.label8, me.label9, me.uncommitted FROM opsview.attributes me WHERE ( me.id = ? ) ORDER BY internally_generated, name: '4'
-SELECT me.host, me.attribute, me.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9 FROM opsview.host_attributes me JOIN opsview.attributes attribute ON attribute.id = me.attribute WHERE ( ( attribute.name = ? AND me.host = ? ) ) ORDER BY attribute.name, me.value: 'DISK', '18'
-SELECT me.id, me.name, me.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9, me.internally_generated, me.label1, me.label2, me.label3, me.label4, me.label5, me.label6, me.label7, me.label8, me.label9, me.uncommitted FROM opsview.attributes me WHERE ( me.id = ? ) ORDER BY internally_generated, name: '4'
-SELECT me.id, me.name, me.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9, me.internally_generated, me.label1, me.label2, me.label3, me.label4, me.label5, me.label6, me.label7, me.label8, me.label9, me.uncommitted FROM opsview.attributes me WHERE ( me.id = ? ) ORDER BY internally_generated, name: '4'
-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.host, me.attribute, me.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9, attribute.id, attribute.name, attribute.value, attribute.arg1, attribute.arg2, attribute.arg3, attribute.arg4, attribute.arg5, attribute.arg6, attribute.arg7, attribute.arg8, attribute.arg9, attribute.internally_generated, attribute.label1, attribute.label2, attribute.label3, attribute.label4, attribute.label5, attribute.label6, attribute.label7, attribute.label8, attribute.label9, attribute.uncommitted FROM opsview.host_attributes me JOIN opsview.attributes attribute ON attribute.id = me.attribute WHERE ( ( attribute.name = ? AND me.host = ? ) ) ORDER BY attribute.name, me.value: 'DISK', '18'
+SELECT me.host, me.attribute, me.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9, attribute.id, attribute.name, attribute.value, attribute.arg1, attribute.arg2, attribute.arg3, attribute.arg4, attribute.arg5, attribute.arg6, attribute.arg7, attribute.arg8, attribute.arg9, attribute.internally_generated, attribute.label1, attribute.label2, attribute.label3, attribute.label4, attribute.label5, attribute.label6, attribute.label7, attribute.label8, attribute.label9, attribute.uncommitted FROM opsview.host_attributes me JOIN opsview.attributes attribute ON attribute.id = me.attribute WHERE ( ( attribute.name = ? AND me.host = ? ) ) ORDER BY attribute.name, me.value: 'DISK', '18'
+SELECT me.host, me.attribute, me.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9, attribute.id, attribute.name, attribute.value, attribute.arg1, attribute.arg2, attribute.arg3, attribute.arg4, attribute.arg5, attribute.arg6, attribute.arg7, attribute.arg8, attribute.arg9, attribute.internally_generated, attribute.label1, attribute.label2, attribute.label3, attribute.label4, attribute.label5, attribute.label6, attribute.label7, attribute.label8, attribute.label9, attribute.uncommitted FROM opsview.host_attributes me JOIN opsview.attributes attribute ON attribute.id = me.attribute WHERE ( ( attribute.name = ? AND me.host = ? ) ) ORDER BY attribute.name, me.value: 'DISK', '18'
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: '5'
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.host, me.attribute, me.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9, attribute.id, attribute.name, attribute.value, attribute.arg1, attribute.arg2, attribute.arg3, attribute.arg4, attribute.arg5, attribute.arg6, attribute.arg7, attribute.arg8, attribute.arg9, attribute.internally_generated, attribute.label1, attribute.label2, attribute.label3, attribute.label4, attribute.label5, attribute.label6, attribute.label7, attribute.label8, attribute.label9, attribute.uncommitted FROM (SELECT me.host, me.attribute, me.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9 FROM opsview.host_attributes me JOIN opsview.attributes attribute ON attribute.id = me.attribute WHERE ( me.host = ? ) GROUP BY attribute.name, me.value ORDER BY attribute.name, me.value) me JOIN opsview.attributes attribute ON attribute.id = me.attribute WHERE ( me.host = ? ) ORDER BY attribute.name, me.value: '6', '6'
SELECT me.host, me.attribute, me.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9, attribute.id, attribute.name, attribute.value, attribute.arg1, attribute.arg2, attribute.arg3, attribute.arg4, attribute.arg5, attribute.arg6, attribute.arg7, attribute.arg8, attribute.arg9, attribute.internally_generated, attribute.label1, attribute.label2, attribute.label3, attribute.label4, attribute.label5, attribute.label6, attribute.label7, attribute.label8, attribute.label9, attribute.uncommitted FROM (SELECT me.host, me.attribute, me.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9 FROM opsview.host_attributes me JOIN opsview.attributes attribute ON attribute.id = me.attribute WHERE ( me.host = ? ) GROUP BY attribute.name, me.value ORDER BY attribute.name, me.value) me JOIN opsview.attributes attribute ON attribute.id = me.attribute WHERE ( me.host = ? ) ORDER BY attribute.name, me.value: '6', '6'
SELECT me.id, me.name, me.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9, me.internally_generated, me.label1, me.label2, me.label3, me.label4, me.label5, me.label6, me.label7, me.label8, me.label9, me.uncommitted FROM opsview.attributes me WHERE ( me.name = ? ) ORDER BY internally_generated, name: 'MYSQL_CREDENTIALS'
SELECT me.host, me.attribute, me.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9, attribute.id, attribute.name, attribute.value, attribute.arg1, attribute.arg2, attribute.arg3, attribute.arg4, attribute.arg5, attribute.arg6, attribute.arg7, attribute.arg8, attribute.arg9, attribute.internally_generated, attribute.label1, attribute.label2, attribute.label3, attribute.label4, attribute.label5, attribute.label6, attribute.label7, attribute.label8, attribute.label9, attribute.uncommitted FROM (SELECT me.host, me.attribute, me.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9 FROM opsview.host_attributes me JOIN opsview.attributes attribute ON attribute.id = me.attribute WHERE ( me.host = ? ) GROUP BY attribute.name, me.value ORDER BY attribute.name, me.value) me JOIN opsview.attributes attribute ON attribute.id = me.attribute WHERE ( me.host = ? ) ORDER BY attribute.name, me.value: '6', '6'
-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.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: '5'
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: '3'
-SELECT me.id, me.name, me.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9, me.internally_generated, me.label1, me.label2, me.label3, me.label4, me.label5, me.label6, me.label7, me.label8, me.label9, me.uncommitted FROM opsview.attributes me WHERE ( me.id = ? ) ORDER BY internally_generated, name: '2'
-SELECT me.id, me.name, me.value, me.arg1, me.arg2, me.arg3, me.arg4, me.arg5, me.arg6, me.arg7, me.arg8, me.arg9, me.internally_generated, me.label1, me.label2, me.label3, me.label4, me.label5, me.label6, me.label7, me.label8, me.label9, me.uncommitted FROM opsview.attributes me WHERE ( me.name = ? ) ORDER BY internally_generated, name: 'INTERFACE'
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: '', '12'
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'
