Build precise queries to find exactly what you need
Press ESC to close
Nagios World Conference 2026: Sept. 14-17 in St. Paul, MN | Learn More
I have replaced this code :
$self->{invalidobjects}->{invalid_ind_partitions} = $self->{handle}->fetchrow_array(q{ SELECT COUNT(DISTINCT STATUS) FROM dba_ind_partitions WHERE status ‘USABLE’ });
by this one :
$self->{invalidobjects}->{invalid_ind_partitions} = $self->{handle}->fetchrow_array(q{ SELECT COUNT(DISTINCT STATUS) FROM dba_ind_partitions WHERE status ‘USABLE’ AND status ‘N/A’ });
because there was notification about invalid partition, but it was subpartition, reported by “N/A”