Two tables with same field name issue.
PowerShell will automatically rename the second name with suffix number.
In SolarWinds Add-on for Splunk, two tables with same field name will got response status=400
Resolved by change one of the same field name to different name.
SELECT CN.NodeID, CN.SysName, N.IPAddress, N.SysName as Node_SysName FROM Cirrus.Nodes AS CN LEFT JOIN Orion.Nodes AS N ON CN.CoreNodeID = N.NodeID
@johnhsu Please rewrite your solution into a question and then post and accept the answer. This will help future readers with similar problem find your resolution.
What @richgalloway said, @johnhsu!