What's the best way to copy/create the 'Top 10 Interfaces by Traffic' resource for a widget in a Modern NOC view dashboard?

Question

There are several out of the box views/dashboards, specifically from the 'Top 10' view, that I would like to pull into a modern dashboard for our NOC. Has anyone created a SWQL that displays the same data and format of 'Top 10 Interfaces by Traffic', for example, for use in a Modern Dash widget? I can get close to it with the GQB but I'd love a direct conversion. 
 Thanks in advance!

marlief22 · Answer

Hi there, 
 I have managed to make something like this that will hopefully set you on the right path: 
 
 The SWQL query can be found here: 
 SELECT TOP 10 if.Node.Caption as [Node], if.Caption as [Interface], if.InPercentUtil as [Receive], if.OutPercentUtil as [Send], if.PercentUtil
FROM Orion.NPM.Interfaces if 
order by if.PercentUtil desc 
 Then you can adjust the widget to be ordered by PercentUtil, but don't show that column. 
 If this helps answer your question please mark my answer as confirmed to help other users, thank you! 
 Marlie Fancourt | SolarWinds Pre-Sales Manager 
 Prosperon Networks | SolarWinds Partner since 2006