Solarwinds moden dashboards

Question

I have 2 questions regarding modern dasboards.

1. Can I use joining entities as a data source via the GUI?

2. Are there any out-of-the-box (OOTB) tables available, similar to those used in regular widgets?

Thanks

stuartd · Answer

Here's the code [below the screenshot] for a widget that shows interfaces that are down where a node is up. The JOINs here were to pull in a specific custom properties and the widget in use looks like this:

SELECT Nodes.NodeID
                             , Nodes.Caption as NodeName
                             , Nodes.GroupStatus
                             , i.InterfaceID
                             , i.Caption
                             , i.Status AS [Interface Status]                 
                             , i.StatusLED
                             , Nodes.IP_Address
                             , Nodes.DNS
                             , Nodes.SysName
                             , C.GUID
                             , i.InterfaceName
                             , i.InterfaceIndex
                             , Nodes.Status as NodeStatus
                             , i.DetailsURL

FROM Orion.NPM.Interfaces AS i
INNER JOIN Orion.Nodes ON i.NodeID = Nodes.NodeID 
INNER JOIN Orion.NodesCustomProperties AS npm ON i.NodeID = npm.NodeID 
LEFT OUTER JOIN Orion.WebCommunityStrings C ON Nodes.Community=C.CommunityString

WHERE  Nodes.Status = '1'  
AND i.Status = '2' 
AND i.AdminStatus = '1'
AND npm.Client = 'XXX'

It's, as you can see, a straightforward JOIN (as I understand SQL at least). If this widget wasn't extcating from

sw44 · Answer

Thanks.

Can you share a screen shot how to use joins\link entities in the UI part of  the modern dashbaord ?

stuartd · Answer

Brain has unfogged - they are called 'navigation properties'. See here  An Adventure Into Modern Dashboarding: Introduction to SWQL Studio  for details if unfamiliar with them, and scroll down to: Leveraging Navigation Properties