Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

UnDP PoE Interface Monitoring - Correlating data and interface names

I’m trying to set up interface PoE monitoring on a CISCO switch. I’ve found the data I need in the CISCO-POWER-ETHERNET-EXT-MIB (1.3.6.1.4.1.9.9.402) table. The problem is that the table does not contain the interface names. It does have the OID numbers (ex 1010) that are used in other OID tables for interface information.

I’m trying to use that OID number to correlate data between the two tables and it almost works. For some reason I’m seeing two lines in the table instead of just one. Looking for any help in resolving this issue.

So here is the widget configuration:

And the UnDP Configurations:

<?xml version="1.0" encoding="utf-8"?>
<CustomPollers version="9.0">
<CustomPoller UniqueName="cpeExtPsePortPwrAllocatedint" Description=""This object indicates the amount of power allocated from the
        PSE for the PD."" OID="1.3.6.1.4.1.9.9.402.1.2.1.7" MIB="CISCO-POWER-ETHERNET-EXT-MIB:cpeExtPsePortPwrAllocated" SNMPGetType="GetSubTree" NetObjectPrefix="N" GroupName="Cisco-PoE" PollerType="S" Parser="None" IncludeHistory="True" Unit="" TimeUnitId="0" TimeUnitQuantity="0" DefaultDisplayTimeUnitId="0" Formula="" LabelType="SameTable" LabelDetail="1.3.6.1.4.1.9.9.402.1.2.1.11">
    <Enumerations />
</CustomPoller>

<CustomPoller UniqueName="cpeExtPsePortPwrAvailableInt" Description=""This object indicates the amount of power available for
        the PD to use. This value may differ from the value
        cpeExtPsePortPwrAllocated due to the efficiency issues
        of delivering the power from the PSE to the PD.

        When suffi" OID="1.3.6.1.4.1.9.9.402.1.2.1.8" MIB="CISCO-POWER-ETHERNET-EXT-MIB:cpeExtPsePortPwrAvailable" SNMPGetType="GetSubTree" NetObjectPrefix="N" GroupName="Cisco-PoE" PollerType="S" Parser="None" IncludeHistory="True" Unit="" TimeUnitId="0" TimeUnitQuantity="0" DefaultDisplayTimeUnitId="0" Formula="" LabelType="SameTable" LabelDetail="1.3.6.1.4.1.9.9.402.1.2.1.11">
    <Enumerations />
</CustomPoller>

<CustomPoller UniqueName="cpeExtPsePortPwrMax" Description=""This indicates the maximum amount of power that the PSE will
        make available to the PD connected to this interface."" OID="1.3.6.1.4.1.9.9.402.1.2.1.6" MIB="CISCO-POWER-ETHERNET-EXT-MIB:cpeExtPsePortPwrMax" SNMPGetType="GetSubTree" NetObjectPrefix="N" GroupName="Cisco-PoE" PollerType="S" Parser="None" IncludeHistory="True" Unit="" TimeUnitId="0" TimeUnitQuantity="0" DefaultDisplayTimeUnitId="0" Formula="" LabelType="Interface" LabelDetail="">
    <Enumerations />
</CustomPoller>

<CustomPoller UniqueName="entPhysicalDescr" Description=""A textual description of physical entity. This object
            should contain a string that identifies the manufacturer's
            name for the physical entity and should be set to a
            distinct value for each version or model of the phys" OID="1.3.6.1.2.1.47.1.1.1.1.2" MIB="ENTITY-MIB:entPhysicalDescr" SNMPGetType="GetSubTree" NetObjectPrefix="N" GroupName="Cisco-PoE" PollerType="S" Parser="None" IncludeHistory="True" Unit="" TimeUnitId="0" TimeUnitQuantity="0" DefaultDisplayTimeUnitId="0" Formula="" LabelType="Interface" LabelDetail="">
    <Enumerations />
</CustomPoller>
</CustomPollers>

I also tried creating a modern dashboard but hit a wall because the data I'm pulling back with the UnDP is a table and not a single value, the two are stored differently in the database. Does anyone have SQL to do this?