In OCE, I have a different value for bad polls and All errors.
Bad polls --> the number that shows on the graph is themaximum number of bad polls during that period.
There is no query to run to get this.
When we point the mouse pointer to the last bar on bad polls we get a number. This is the number of bad polls in the last poll. This can be queried using the following command
where poll_type IN ('f', 'n', 'i') and rownum = 1 order by poll_end_utc
All Errors --> The all errors count the number of parent elements which have bad polls.
This can be calculated using the following query select count(distinct BP.machine_id || BP.element_id || error_type) as
from NHV_STATS_POLL_ERROR_ELEMENT BP, NH_ELEMENT E
where error_utc >=(nh_utl.dtn(sysdate)-400)
and (BP.machine_id=E.machine_id and BP.element_id=E.element_id );