Can you get counter data directly from the database???

Question

I have created a custom mib poller. It polls a node (computer) for its disk i/o. This value is simply a counter that increments. SolarWinds can then graph this data by taking interval averages, i.e. [ value(now) minus value(one minute ago) ]. My question is this:

Orion NPM can graph this data but where can I find the averages in the SQL database? I can find the absolute counter value in the CustomPollerScratchStatistics table but I can't find the averages anywhere. Are these averages ONLY caclulated by NPM and are not actually stored anywhere?

Thanks

jackie

SteveSW · Answer

CustomPollerStatistics will be populated IF the custom poller is set up as a historical poller. The CustomPollerStatistics view contains the delta in the Total column and the averages in the AvgRate column. These are calculated when written to the DB.

As Mark said the latest information is stored in the CustomPollerStatus table. The Total field contains the delta and the Rate field contains the average.

mark_wiggans · Answer

The averages are calculated and stored in the database. We do not keep the raw counter values.The most recent value will be in CustomPollerStatus.

The tables are:

CustomPollerStatistics_Detail
CustomPollerStatistics_Hourly
CustomPollerStatistics_Daily