SFP Power Level monitoring - Cisco

tallyrich

UPDATE - Working config

Query

SELECT

I.Name AS Port
, ROUND(I.Value, 6) AS Power
, I.StatusDescription AS Status
, N.ParentObjectName AS [Device]
, N.DetailsURL AS [_linkfor_Device]

FROM Orion.HardwareHealth.HardwareItemBase I

INNER JOIN Orion.HardwareHealth.HardwareInfo N ON N.ID=I.HardwareInfoID

Where I.FullyQualifiedName like 'power R%' AND I.StatusDescription <> 'Disabled'

ORDER by FullyQualifiedName ASC

Search

SELECT

I.Name AS Port
, ROUND(I.Value, 6) AS Power
, I.StatusDescription AS Status
, N.ParentObjectName AS [Device]
, N.DetailsURL AS [_linkfor_Device]

FROM Orion.HardwareHealth.HardwareItemBase I

INNER JOIN Orion.HardwareHealth.HardwareInfo N ON N.ID=I.HardwareInfoID

Where I.FullyQualifiedName like 'power R%' AND I.StatusDescription <> 'Disabled'

AND (
I.Name LIKE '%${SEARCH_STRING}%' OR
I.Value LIKE '%${SEARCH_STRING}%' OR
I.FullyQualifiedName LIKE '%${SEARCH_STRING}%' OR
I.StatusDescription LIKE '%${SEARCH_STRING}%' OR
N.ParentObjectName LIKE '%${SEARCH_STRING}%' OR
N.NodeID LIKE '%${SEARCH_STRING}%' OR
I.HardwareInfoID LIKE '%${SEARCH_STRING}%'
)

ORDER by FullyQualifiedName ASC

I've found a way to monitor light levels in our Cisco devices, but the output leaves things to be desired.

Here's the SWQL

SELECT

I.Name
, I.Value
, I.FullyQualifiedName
, I.StatusDescription

FROM Orion.HardwareHealth.HardwareItemBase I

Where I.FullyQualifiedName like 'power R%' AND I.StatusDescription <> 'Disabled'

ORDER by FullyQualifiedNameName ASC

I would appreciate help with:

1. the values show to many decimal places for some devices
2. I would like to tie them back to the Node (it appears in the fully qualified name, but this isn't very "user friendly"
3. It would be nice to have the display name show the actual interface name

stuartd

For points 2 & 3 you need to link to a table that shows the node names, something like Orion.Nodes would do. As I don't see any inherent links in the Orion.HardwareHealth.HardwareItemBase object then you'll need to do a join.

Something like this should work:

SELECT
 N.Caption
,I.Name
,I.Value
,I.FullyQualifiedName
,I.StatusDescription

FROM Orion.HardwareHealth.HardwareItemBase I
JOIN Orion.Nodes AS N ON I.ID = N.NodeID

Where I.FullyQualifiedName like 'power R%' 
AND I.StatusDescription <> 'Disabled'

ORDER by i.FullyQualifiedName ASC

As for point 1 then I've not used it myself but a quick search through THWACK suggests the ROUND function is what you need.