Hi,
Anyone with experience in SQL queries and combining custom MIB
pollers to create a combined GUI view or report?
A solution for following
issue would bring benefits to lots of people I think...
We want to add a Node detail listing the Spanning Tree Port Status of all
important Interfaces of a Switch.
In NPM this only can be achieved with
Custom MIB Pollers, since there is no "out of the box" solution.
Unfortunately SNMP Queries for StpPortState list based on an unique Index
number and so the output is not human readable:
Again, the left column is not directly related to the IfMIB IfIndex
value...
So what we would have to do here is:
1. Query the dot1dStpPortState
Table – it delivers the STP State per port but with an at this point unknown ID
as key value!
2. Query the dot1dBasePortIfIndex Table which then links
between IfIndex and StpPortIndex
3. Query the IfMIBs translation Table for
IfIndex to IfDescription
4. Combine IfDescription with corresponding
StpPortState and list in output
As far as I understand NPM, this combination of pollers can only be done via
custom SQL queries and combine values via customized reports which are then
added as a resource onto the Node detail View, right?
Is there a tough guy accepting this challenge?
I already opened a support
ticket - unfortunately the outcome was "We are not doing DBA support and do not
have the knowledge to create such queries"...
Thanks for any help on this!
Cheers
p.s.: Monitoring Spanning Tree is essential for enterprise LAN
networks,
unfortunately this is not implemented in Solarwinds products as out
of the box solution.
There are several threads here and most without propper
solution.
