Show related UDP on Interface Details page

jajao555

We're trying to find a way to display custom poller charts for an individual interface within that interface's details page and only shows that interface's stats.

We have Ciena devices and have a poller setup to poll all interface light levels. So far we've only been able to display them all in one chart I'm guessing because they're in a table?

This gets unwieldy on devices that have 48 ports and it would be nice to show thresholds as well but there are different optics with different thresholds so it wouldn't make sense all in a single graph.

The end goal was to be able to see an individual interface's Rx/Tx light levels and maybe add warning/critical high/low light levels which could also be polled OIDs for whatever type optic is being used.

The above was setup using the custom object resource chart and I had tried making pollers for each individual port rather than the whole table but that makes it the template for all interface details pages. 

Here's the poller setup that polls the table.

I also tried setting this up through perfstack but ran into an issue where we can't do a transform to divide it by 10000 to get a more readable dbm value.

Is there type of chart that can be added where this could be done? We have this same sort of scenario with a couple other interface stats we'd like to track.

jajao555

I ended up figuring out how to do this with swql.

Example for anyone else that might have trouble. Not sure if its the best way but I ended up naming poller in such a way to be able to group them and use the InterfaceID variable so it just displays the related stats for that interface on it's page

SELECT
    DateTime, 
    CPON.NodeID, 
    CPON.CustomPollerAssignmentID, 
    CPON.ID, 
    CASE WHEN CPON.CustomPollerName = 'wwpLeosPortXcvrRxDbmPower_LightLevels' THEN 'Ciena Rx dBm'
        WHEN CPON.CustomPollerName = 'wwpLeosPortXcvrTxDbmPower_LightLevels' THEN 'Ciena Tx dBm'
        WHEN CPON.CustomPollerName = 'cienaCesPortXcvrRxPower_LightLevels' THEN 'Ciena Rx mW'
        WHEN CPON.CustomPollerName = 'cienaCesPortXcvrTxOutputPower_LightLevels' THEN 'Ciena Tx mW'
        WHEN CPON.CustomPollerName = 'jnxDomCurrentRxLaserPower_LightLevels' THEN 'Juniper Rx dBm'
        WHEN CPON.CustomPollerName = 'jnxDomCurrentTxLaserOutputPower_LightLevels' THEN 'Juniper Tx dBm'
        END AS CustomPollerName,
    CASE WHEN CPON.CustomPollerName = 'wwpLeosPortXcvrRxDbmPower_LightLevels' THEN (CPST.RawStatus/10000)
         WHEN CPON.CustomPollerName = 'wwpLeosPortXcvrTxDbmPower_LightLevels' THEN (CPST.RawStatus/10000)
         WHEN CPON.CustomPollerName = 'cienaCesPortXcvrRxPower_LightLevels' THEN CPST.RawStatus
         WHEN CPON.CustomPollerName = 'cienaCesPortXcvrTxOutputPower_LightLevels' THEN CPST.RawStatus
         WHEN CPON.CustomPollerName = 'jnxDomCurrentRxLaserPower_LightLevels' THEN (CPST.RawStatus/100)
         WHEN CPON.CustomPollerName = 'jnxDomCurrentTxLaserOutputPower_LightLevels' THEN (CPST.RawStatus/100)
         END AS RawStatus,
    CPST.RowID,
    CPON.AssignmentName,
    I.Alias,
    I.InterfaceID
FROM Orion.NPM.CustomPollerAssignmentOnNode CPON

JOIN Orion.NPM.CustomPollerStatistics CPST
    ON CPST.CustomPollerAssignmentID = CPON.CustomPollerAssignmentID

JOIN Orion.NPM.Interfaces I 
   ON I.NodeID = CPON.NodeID AND CASE WHEN I.Index LIKE '1000%' THEN SUBSTRING(TOSTRING(I.Index),5,1) 
                                        WHEN I.Index LIKE '100%' THEN SUBSTRING(TOSTRING(I.Index),4,2) ELSE I.Index END = CPST.RowID

WHERE CPON.CustomPollerName LIKE '%_LightLevels%'
  AND DateTime >= AddDay( -8, GETDATE())
  AND I.InterfaceID=${InterfaceID}