I am running a sql query which use JOIN 4 tables and returns the results, the query is working as expected in SQL Explorer but when i try to run the same in search it does not generate any events, values get populated n statistics tab though.
SELECT *
FROM table1
INNER JOIN table2
ON table1.DEVICE_ID = table2.ID
LEFT JOIN table3
ON table2.CLIENT_ID = table3.ID
LEFT JOIN table4
ON table3.CLIENTTYPE_ID = table4.ID
WHERE table4.NAME = 'ABC' OR table4.NAME = 'DEF'
I want to use some aggregation function (stats, eval, count) over the rows returned from my SQL query.
... View more