Two tables with same field name, got response status=400. Resolved by change one of the same field name to different name.

[johnhsu]

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.

For example:
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

[richgalloway]

@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.

[woodcock]

What @richgalloway said, @johnhsu!