Monitor Interface activity on a node

dhodgson

I'm trying to create a Modern Dashboard widget that will give a snapshot of activity over the VLANS of a specific node. This is a Juniper device so the VLANS are .irb interfaces. I've been messing around with SWQL queries trying to stumble my way into the answer but I think this is a bit beyond me. Please share advice on how to approach this query. Below I have included the output I am aiming to get. I would also appreciate feedback on whether there is a better way to approach this problem.

GOAL OUTPUT:

VLAN     BPS

1             0

200         1000

250         100000

...            ...

Current Query:

SELECT TOP 10 n.InterfaceAlias,n.Bps
FROM Orion.NPM.Interfaces n
WHERE (
(n.Node LIKE 'CN')
AND
(InterfaceAlias LIKE '.irb%'))

dhodgson

NEW QUERY:

SELECT n.NodeID,n.InterfaceCaption,n.Bps
FROM Orion.NPM.Interfaces n

WHERE (NodeID = 262 AND InterfaceCaption LIKE 'irb%')

This gives me that table but now I'm realizing I don't know how to make it look nice. It seems like this is kind of turning into a diary of me troubleshooting this query so we'll see what I can figure out for making it readable. Right now this spits out the exact table I wanted to make but its way too big. I'm trying to work out a graphical way to represent this info because, as is, it's the worst widget I've put together.