All Apps and Add-ons

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

johnhsu
Observer

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

0 Karma

richgalloway
SplunkTrust
SplunkTrust

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

---
If this reply helps you, Karma would be appreciated.

woodcock
Esteemed Legend

What @richgalloway said, @johnhsu!

0 Karma
Get Updates on the Splunk Community!

Demo Day: Strengthen Your SOC with Splunk Enterprise Security 8.1

Today’s threat landscape is more complex than ever. Security operation centers (SOCs) are overwhelmed with ...

Dashboards: Hiding charts while search is being executed and other uses for tokens

There are a couple of features of SimpleXML / Classic dashboards that can be used to enhance the user ...

Splunk Observability Cloud's AI Assistant in Action Series: Explaining Metrics and ...

This is the fourth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how ...