Hi,
I am using join in a splunk dashboard with two indexes with time as parameter, but i am not getting the correct results. Without the join, it is working fine.
The date column is st_date and I have used this column in the token also, but I am still getting the wrong output. Please suggest if I missed anything.
My search:
index=a| JOIN type=inner aid[ SEARCH index=b] |table st_date,aid,location
My Xml:
test Clone
<input type="time" token="st_date" searchWhenChanged="true">
<default>
<earliest>0</earliest>
<latest></latest>
</default>
</input>
<panel>
<table>
<search>
<query>index=a| JOIN type=inner aid[ SEARCH index=b] |table st_date,aid,LOCATION</query>
<earliest>$st_date.earliest$</earliest>
<latest>$st_date.latest$</latest>
</search>
<option name="wrap">undefined</option>
<option name="rowNumbers">undefined</option>
<option name="drilldown">row</option>
<option name="dataOverlayMode">none</option>
<option name="count">10</option>
</table>
</panel>
Index a
sno st_date aid
1 01/01/2014 10
2 01/01/2015 5
Index a
sno aid LOCATION
1 10 us
2 5 UK
If i select date (startdate & enddate) as '01/01/2014 ' & '02/01/2014 '
Expected result
sno LOCATION aid
1 us 10
but i am getting result as
sno LOCATION aid
1 us 10
2 UK 5
Please suggest how to get the Expected result and how to use date parameter as the where condition in splunk search/dashboard with join.
... View more