Splunk Search

How can we set time filter on click from table view?

Nisarg
New Member

Is there a way we can pass epoch time from click of the table cell and set it to time filter of Splunk?

Tags (1)
0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi Nisarg,
as @niketnilay said the answer is yes.
with a click on a row of a table you can pass the timestamp of the row

<drilldown>
     <link target="_blank">/app/imy_app/drilldown_dashboard?TimeStamp=$row.-time$&token1=$row.field1$</link>
</drilldown>

If instead you want to pass the same time borders of your main search, you can use something like this (if your time picker token is callet "Time"):

<drilldown>
     <link target="_blank">/app/imy_app/drilldown_dashboard?TimeFrom=$Time.earliest$&TimeTo=$Time.latest$&token1=$row.field1$</link>
</drilldown>

for more details see https://docs.splunk.com/Documentation/Splunk/7.3.1/Viz/DrilldownIntro and the Splunk Dashboard Examples App ( https://splunkbase.splunk.com/app/1603/ ).

Bye.
Giuseppe

0 Karma

niketn
Legend

@Nisarg the answer to your question would be yes that may be possible.

However, for the community to assist you better you would need to add more details to your question like, what is the field name/value for table cell which has the time? What is the SPL that produces the table? Do you have span per row in your table (for example if you use timechart command)? Once you get the drilldown value for epoch time, are you planning to pass the earliest and latest token to your existing time picker input? Is the table dependent on the same time picker as well?

____________________________________________
| makeresults | eval message= "Happy Splunking!!!"
0 Karma
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.

Can’t make it to .conf25? Join us online!

Get Updates on the Splunk Community!

Leveraging Automated Threat Analysis Across the Splunk Ecosystem

Are you leveraging automation to its fullest potential in your threat detection strategy?Our upcoming Security ...

Can’t Make It to Boston? Stream .conf25 and Learn with Haya Husain

Boston may be buzzing this September with Splunk University and .conf25, but you don’t have to pack a bag to ...

Splunk Lantern’s Guide to The Most Popular .conf25 Sessions

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...