5 Replies Latest reply: Nov 29, 2012 10:31 AM by PeterLyttle RSS

Cisco PoE Monitoring

PeterLyttle

Hello folks,

 

I'm just wondering if anyone has managed to do a dashboard / alert for when PoE consumption is almost at capacity.

 

I can do a syslog alert but would like something more graphical etc.

 

Does the 10.4 network hardware monitoring help with this?

 

Cheers,

Peter

 
  • Re: Cisco PoE Monitoring
    pyro13g

    Check out these universal device pollers in the content exchange.

     

    Cisco 3750 Stack Power Consumption Per switch

    Monitors total WATTS consumed of a Cisco stackable (3560, 3750,etc) PoE Switch

     

    You should be to build what you need.

    • Re: Cisco PoE Monitoring
      PeterLyttle

      Cheers, I guess this forces me to goto 10.4 to get multiple UnDP per graph rather than 1 for every switch we have

      • Re: Cisco PoE Monitoring
        pyro13g

        Not sure the new charts will help because if you have any switch stacks then you have an entry for each stack member.

         

        POE Consumption Watts

         

        pethMainPseConsumptionPower - LabelpethMainPseConsumptionPower
        Switch 1235
        Switch 2324
        Switch 3245
        Switch 4264

         

        • Re: Cisco PoE Monitoring
          PeterLyttle

          I guess I could write a bit of sql to query the UnDP value... I'll have a think and if I work something out will post back.

          • Re: Cisco PoE Monitoring
            PeterLyttle

            Change %3560% to be the specific model of switch your wanting to report on.

             

            Two UnDP needed for OIDs -

             

            chassisModel - 1.3.6.1.4.1.9.5.1.2.16

            pethMainPseConsumptionPower - 1.3.6.1.2.1.105.1.3.1.1.4

             

            SELECT N.NodeID AS ID,N.Caption AS Switch,CPS.Status AS Watts FROM dbo.CustomPollers AS CP

            JOIN dbo.CustomPollerAssignment AS CPA

            ON CPA.CustomPollerID = CP.CustomPollerID

            JOIN dbo.Nodes AS N

            ON N.NodeID = CPA.NodeID

            JOIN dbo.CustomPollerStatistics AS CPS

            ON CPS.CustomPollerAssignmentID = CPA.CustomPollerAssignmentID

            WHERE CP.UniqueName = 'pethMainPseConsumptionPower' /*Custom Poller for OID 1.3.6.1.2.1.105.1.3.1.1.4*/

            AND CPS.DateTime IN (SELECT MAX(DateTime) FROM dbo.CustomPollerStatistics GROUP BY CustomPollerAssignmentID)

            AND N.NodeID IN (

            SELECT N.NodeID FROM dbo.CustomPollers AS CP

            JOIN dbo.CustomPollerAssignment AS CPA

            ON CPA.CustomPollerID = CP.CustomPollerID

            JOIN dbo.Nodes AS N

            ON N.NodeID = CPA.NodeID

            JOIN dbo.CustomPollerStatistics AS CPS

            ON CPS.CustomPollerAssignmentID = CPA.CustomPollerAssignmentID

            WHERE CP.UniqueName = 'chassisModel' /*Custom Poller for OID 1.3.6.1.4.1.9.5.1.2.16*/

            AND CPS.DateTime IN (SELECT MAX(DateTime) FROM dbo.CustomPollerStatistics GROUP BY CustomPollerAssignmentID)

            AND CPS.Status LIKE '%3560%'

            )

            ORDER BY CPS.Status DESC

             

            Heres the same for a SQL Variable -

             

            SELECT CPS.Status AS Watts FROM dbo.CustomPollers AS CP JOIN dbo.CustomPollerAssignment AS CPA ON CPA.CustomPollerID = CP.CustomPollerID JOIN dbo.Nodes AS N ON N.NodeID = CPA.NodeID JOIN dbo.CustomPollerStatistics AS CPS ON CPS.CustomPollerAssignmentID = CPA.CustomPollerAssignmentID WHERE CP.UniqueName = 'pethMainPseConsumptionPower' /*Custom Poller for OID 1.3.6.1.2.1.105.1.3.1.1.4*/ AND CPS.DateTime IN (SELECT MAX(DateTime) FROM dbo.CustomPollerStatistics GROUP BY CustomPollerAssignmentID) AND N.NodeID IN (SELECT N.NodeID FROM dbo.CustomPollers AS CP JOIN dbo.CustomPollerAssignment AS CPA ON CPA.CustomPollerID = CP.CustomPollerID JOIN dbo.Nodes AS N ON N.NodeID = CPA.NodeID JOIN dbo.CustomPollerStatistics AS CPS ON CPS.CustomPollerAssignmentID = CPA.CustomPollerAssignmentID WHERE CP.UniqueName = 'chassisModel' /*Custom Poller for OID 1.3.6.1.4.1.9.5.1.2.16*/ AND CPS.DateTime IN (SELECT MAX(DateTime) FROM dbo.CustomPollerStatistics GROUP BY CustomPollerAssignmentID) AND CPS.Status LIKE '%3560%') AND N.NodeID = ${Node.NodeID} ORDER BY CPS.Status DESC