Network Topology Data

raiden100

Hello,

We are trying to get a SQL query to pull all the information that build the network topology diagrams in SolarWinds.

The goal is to have similar display in Power BI. is there a SQL query you that I can use to start building in Power BI? 

TerryHarding

Something like this, maybe:

SELECT
sn1.Caption AS SourceNodeName,
si1.InterfaceName AS SourceInterfaceName,
sn2.Caption AS MappedNodeName,
si2.InterfaceName AS MappedInterfaceName,
tc.Layer_Type
FROM
[dbo].[TopologyData] td
LEFT JOIN [dbo].[Nodes] sn1 ON td.SourceNodeID = sn1.NodeID
LEFT JOIN [dbo].[Interfaces] si1 ON td.SourceInterfaceID = si1.InterfaceID
LEFT JOIN [dbo].[Nodes] sn2 ON td.MappedNodeID = sn2.NodeID
LEFT JOIN [dbo].[Interfaces] si2 ON td.MappedInterfaceID = si2.InterfaceID
LEFT JOIN [dbo].[TopologyConnections] tc ON td.DiscoveryProfileID = tc.DiscoveryProfileID