topic How do you fetch table data from join table? in Splunk Search

How do you fetch table data from join table?

flzhang132 — Wed, 17 Oct 2018 01:48:13 GMT

There are two tables: "Table A" is a detailed information, and the "Table B" is the primary key.

The two tables are associated with the primary key and only queries the information in the matching A table.

Be similar to sql
seledt T1.id from T1,T2 where T1.id=T2.id

Re: How do you fetch table data from join table?

renjith_nair — Wed, 17 Oct 2018 02:54:25 GMT

@flzhang132 ,

Assuming you have different indexes or source types where you have this data,

"your search to get first dataset" OR "your search to get the second dataset" 
|stats values(project_name) as project_name,values(region) as region,values(fee) as fee,values(dmon) as domon by resourceid

Another option is to use join, which should be avoided if possible due to performance considerations

"your search to get first dataset"
|join resourceid ["your search to get the second dataset"]

Re: How do you fetch table data from join table?

flzhang132 — Wed, 17 Oct 2018 03:38:44 GMT

please ? How can i get data from same table with self join
Be similar to sql
select T2.id
from table T1
,table T2
where T1.id = T2.id

Re: How do you fetch table data from join table?

renjith_nair — Wed, 17 Oct 2018 05:25:36 GMT

@flzhang132 , do you mean to say, you have these events in the same source? just for clarification, why do you need this join when you dont have any interesting field in the other dataset but all the fields are in say table A ? Do you have some sample events (mask any confidential data) to let us know what you have and what's your expected output

Re: How do you fetch table data from join table?

asabatini85 — Wed, 17 Oct 2018 08:58:19 GMT

In that case it's better use the transaction comand for the self join.