Dashboard using NPM overview page as template

escaloni

Hello,

I've been tasked with creating a dashboard for our Leadership that shows node status at a glance.  I've worked on my own and created some simple dashboards with tabs but I'm a Network Engineer so SWQL /Database stuff doesn't come naturally.  

That being said, I see the NPM overview page has a simple table with Node name followed by green icon status for all the interfaces in a single row.  That's something I'd really like to replicate, and I can get Nodes and interfaces using a SWQL query but I can't seem to get the interfaces in a single row.  Is there someone out there that can point me to how that can be achieved?

bobmarley

This will get you started. Use Custom Query widget and this SWQL 

SELECT top 100
    n.Caption AS [Node Name],
    n.DetailsURL AS [_LinkFor_Node Name],
    '/Orion/images/StatusIcons/Small-' + n.StatusLED AS [_IconFor_Node Name],

    i.InterfaceName AS [Interface Name],
    i.DetailsURL AS [_LinkFor_Interface Name],
    '/Orion/images/StatusIcons/Small-' + i.StatusLED AS [_IconFor_Interface Name]

FROM
    Orion.Nodes n
JOIN
    Orion.NPM.Interfaces i ON n.NodeID = i.NodeID
ORDER BY
    n.Caption, i.InterfaceName