I'm relatively new to Orion and starting to get to grips with modern dashboards. Therefore I still don't know about many of the database fields, what they're called and how to use them.
What I'm trying to do is come up with a graph/proportional widget which shows the top 10 most utilised network interfaces.
I've got two problems.
Firstly, I can find the in and outpercentutil but not one for both. That's not totally a biggie, I can make do with two charts if I have to. (and I'm assuming that utilisation is already taking into account the maximum throughput of each interface, which is what I want... 9Gbs of a 10Gbs interface is still as important to me as is 90Gbs of a 100Gbs interface, if you know what I mean.)
Secondly, I can't get a reliable name from the interface tables. The names I'm getting back are the names of the interfaces and take no account of the node name, so all the "Ethernet0/0/0" interfaces end up getting merged into one.
This is the custom SWQL I'm currently using...
SELECT TOP 10 n.DisplayName,n.outPercentUtil
FROM Orion.NPM.Interfaces n order by n.outPercentUtil desc
Any suggestions please?
