6 Replies Latest reply: Dec 8, 2014 9:20 AM by kindbro 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

                        • Re: Cisco PoE Monitoring
                          kindbro

                          Can this table be displayed in an email alert? Ive modified my alert to show this, but would be cool if I could include the chart.

                           

                          Snippet from Advanced alert:

                          SWITCH:    1  , 2  ,   3 ,   4  , 5  ,   6

                          WATTS:   ${CustomPollerStatus.RawStatus}

                           

                          From email alert on a switch with 6 stack members:

                          SWITCH:    1  , 2  ,   3 ,   4  , 5  ,   6

                          WATTS:   257, 288, 323, 293, 226, 143

                           

                          Thanks!