topic Re: How to get an epoch time for $client_time.latest$ in Splunk Search

How to get an epoch time for $client_time.latest$

trapper_dave — Tue, 16 Feb 2021 19:03:42 GMT

Hi,

I have a dashboard with a dropdown form allowing users to select the time period they wish to analyse.

I am looking to capture the latest time token of the period in epoch format but I am running into issues.

I have found that if the end time is 'now', then I can use time() however this doesn't work for when the end time is in the past (i.e. yesterday, previous week or previous year).

Can anyone assist me in figuring this out?

Many thanks,

Dave

Re: How to get an epoch time for $client_time.latest$

bowesmana — Tue, 16 Feb 2021 21:58:33 GMT

@trapper_dave

The technique is to set up a hidden panel with a search that uses the addinfo command to get the latest time for the search and then use a <done> clause to set tokens based on that epoch.

See the attached dashboard

<form> <label>Time Pickers 2</label> <fieldset submitButton="false"></fieldset> <row> <panel> <input type="time" token="client"> <label>Select Time</label> <default> <earliest>-1d@d</earliest> <latest>@d</latest> </default> </input> <table depends="$show_hidden$"> <title>This simple search - is hidden - but is used to calculate the relative time for the second table</title> <search> <query>| makeresults | addinfo </query> <earliest>$client.earliest$</earliest> <latest>$client.latest$</latest> <done> <set token="search_latest">$result.info_max_time$</set> <eval token="search_latest_fmt">strftime($result.info_max_time$, "%F %T")</eval> </done> </search> </table> <table> <search> <query> | makeresults | eval Selected_Time_Input=$client.latest|s$ | eval Selected_Time_ISO=$search_latest_fmt|s$ | eval Selected_Time_Epoch=$search_latest$ | table Selected_Time_Input Selected_Time_ISO Selected_Time_Epoch </query> </search> </table> </panel> </row> </form>

Hope this helps

Re: How to get an epoch time for $client_time.latest$

trapper_dave — Tue, 23 Feb 2021 09:53:11 GMT

This was perfect, thank you.

Re: How to get an epoch time for $client_time.latest$

bowesmana — Tue, 23 Feb 2021 10:43:13 GMT

@trapper_dave

Glad it helped you. Can you mark the answer as a solution for others.

Cheers