I'm trying to join a few tables from a sql database. (Works fine in SQL)
The tables are: Interfaces, InterfaceTraffic, and Nodes
"Nodes" are the devices, there are multiple "Interfaces" on a "Node". "InterfaceTraffic" has the stats on the "Interfaces". I want to join the stats to the "Interfaces", then join the "Interfaces" to the "Nodes".
If I run the query on either table separately without a join, I get results. If I try to join the tables, I get a "Column Name Conflicted" error: java.lang.IllegalStateException: Column name conflicted, please set shortnames option to false and retry
I don't understand how there can be a conflict. I've been digging through the documentation, and I don't see what I'm missing.
It seems like it is some kind of simple Splunk syntax that I am missing.
Thanks for any help!!
SELECT Interfaces.NodeID,
Interfaces.InterfaceID,
Interfaces.InterfaceName,
Interfaces.InterfaceIndex,
Interfaces.InterfaceType,
Interfaces.InterfaceTypeDescription,
Interfaces.InterfaceSpeed,
Interfaces.InterfaceMTU,
Interfaces.PhysicalAddress,
Interfaces.FullName,
Interfaces.Status,
Interfaces.Outbps,
Interfaces.Inbps,
Interfaces.OutPercentUtil,
Interfaces.InPercentUtil,
Interfaces.InDiscardsThisHour,
Interfaces.InDiscardsToday,
Interfaces.InErrorsThisHour,
Interfaces.InErrorsToday,
Interfaces.OutDiscardsThisHour,
Interfaces.OutDiscardsToday,
Interfaces.OutErrorsThisHour,
Interfaces.OutErrorsToday,
Interfaces.MaxInBpsToday,
Interfaces.MaxInBpsTime,
Interfaces.MaxOutBpsToday,
Interfaces.MaxOutBpsTime,
Interfaces.LastSync,
InterfaceTraffic.NodeID,
InterfaceTraffic.InterfaceID,
InterfaceTraffic.DateTime,
InterfaceTraffic.In_Averagebps,
InterfaceTraffic.In_Minbps,
InterfaceTraffic.In_Maxbps,
InterfaceTraffic.In_TotalBytes,
InterfaceTraffic.In_TotalPkts,
InterfaceTraffic.Out_Averagebps,
InterfaceTraffic.Out_Minbps,
InterfaceTraffic.Out_Maxbps,
InterfaceTraffic.Out_TotalBytes,
InterfaceTraffic.Out_TotalPkts,
Nodes.NodeID,
Nodes.IP_Address,
Nodes.Community,
Nodes.SysName,
Nodes.Location,
Nodes.StatusDescription,
Nodes.Status,
Nodes.LastBoot,
Nodes.SystemUpTime,
Nodes.ResponseTime,
Nodes.PercentLoss,
Nodes.AvgResponseTime,
Nodes.MinResponseTime,
Nodes.MaxResponseTime,
Nodes.LastSync,
Nodes.City,
Nodes.Business_Unit,
Nodes.Site_Name
FROM "SolarWindsOrion"."dbo"."Interfaces"
JOIN "SolarWindsOrion"."dbo"."InterfaceTraffic"
ON InterfaceTraffic.InterfaceID = Interfaces.InterfaceID
JOIN "SolarWindsOrion"."dbo"."Nodes"
ON Nodes.NodeID = Interfaces.NodeID
... View more