Graphing custom monitors?

I am using NPM 10.2 to track some custom SNMP sensors (CPU Temp) on several systems. This works fine, but NPM will only show me the current value of the sensor. What I would like is thew ability to see a graph of the sensor activity, or barring that, at least be able to view past activity. I've went so far as to run SQL queries against the raw DB, and I think I've located the table the custom poller data is stored in, but the data is tied to the pollers using a poller ID that I'm having difficulty making sense of. If anyone has any suggestions, I would be very appreciative.

Thanks in advance.

Find more posts tagged with

web_console

custom_poller

orion

Database

npm_10

Polling

Accepted answers

JiriPsota

Run SQL to check hisorical data in database

SELECT cp.UniqueName, cpa.AssignmentName, cps.*

FROM CustomPollerStatistics cps JOIN CustomPollerAssignment cpa

ON (cps.CustomPollerAssignmentID=cpa.CustomPollerAssignmentID)JOIN CustomPollers cp

ON (cp.PollerID=cpa.PollerID)

WHERE cp.UniqueName like '%' -- custom poller name

ORDER BY cp.UniqueName, cpa.AssignmentName, cps.DateTime desc -- DateTime is in UTC

All comments

zkahl

Make sure you have the following checked in your Universal device poller (keep historical data). Since the historical data is in the DB, then this may not be the issue. But it doesn't hurt to double check.

Zak Kahl

http://www.loop1systems.com

networkingguru

Thanks. I did have that checked, but while in the universal poller settings, I noticed the display option for chart was unchecked. I checked that, and now it looks like a chart is trying to be shown on the web interface, but it's blank, and says "No data for the selected time period", regardless of what time period I choose.