Check out these universal device pollers in the content exchange.

You should be to build what you need.

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

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

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.

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

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!

How to get a report stating what are the reports having PoE features ??/