All Apps and Add-ons

splunk connect DB join tables

indeed_2000
Motivator

I have 2 table that need to join them in splunk connect db in (sql_explorer)
1- table1 (sysindexes)
2- table2 (systables)
3- common column (tableid)

I try to write join query with (tableid) column but it give me below error

here is my query:
SELECT tabid, tabid
FROM sysindexes, systables
RIGHT JOIN sysindexes.tabid ON systables.tabid;

here is the error:
java.sql.SQLSyntaxErrorException: A syntax error has occurred.
No results found.

0 Karma
Get Updates on the Splunk Community!

Building Reliable Asset and Identity Frameworks in Splunk ES

 Accurate asset and identity resolution is the backbone of security operations. Without it, alerts are ...

Cloud Monitoring Console - Unlocking Greater Visibility in SVC Usage Reporting

For Splunk Cloud customers, understanding and optimizing Splunk Virtual Compute (SVC) usage and resource ...

Automatic Discovery Part 3: Practical Use Cases

If you’ve enabled Automatic Discovery in your install of the Splunk Distribution of the OpenTelemetry ...