Export/Read last SNMP values from specific devices

breakerofchains

I have a need to export the last read SNMP values from 22 busway power meters and get them into Excel so I can perform the necessary conversions and analysis.  My current process is to bring the node up in SolarWinds and then use the MIB Browser to grab each of the 81 values I need one at a time.  Obviously this is painful to do even once and totally not something I wish to keep repeating.

In the node view, we do not have each of these 81 data points defined since that would be difficult to read given that the 'poller' line always displays so we would wind up with 162 lines and every other line would be the value I want.  We could configure it to read all 81 values though if that is the only solution possible to my problem.

I guess the ideal solution would dump all 81 values (last value retrieved from device) from each of the 22 devices into a .csv file that I could then import into Excel.  Date/Time the value was retrieved would be good as would the node name.

Any thoughts on how I can achieve this?

ScottPowell

Have you tried adding all the SNMP OIDs in the Universal Device Poller? Orion can then poll them and store the data for you at intervals of your choice. Plus, once they are all in there on one node, you can apply them to all the power meters. You can even do conversions on the data.

What I do not know how to do is export them en masse. It is ease to export one OID from one device, but other then writing a SQl query, I'm not sure how do it easily.