Dashboards & Visualizations

Can you help me pass earliest and latest time tokens to another panel in a dashboard?

Deepz2612
Explorer

Hi,

I have the Begin time and End time as below for an event (which is again extracted using another query)

Begin time : 4:43:55:336 AM
End time : 4:53:00:00 AM

I wanted to pass this earliest and latest time for another panel in the dashboard.

Could you kindly help

0 Karma

Deepz2612
Explorer

I'm sorry..
Begin time and End time will have the date as well. I missed to add it.
Begin time : 04/01/2019 4:43:55:336 AM
End time : 04/01/2019 4:53:00:00 AM

0 Karma

kamlesh_vaghela
SplunkTrust
SplunkTrust

@Deepz2612
You have the Begin time and End time!! But what date you want to consider ?? Current date?

In case of the current date, you can update your another search with below search logic to get Begin_time and End_time.

| makeresults 
| eval date=strftime(now(),"%Y-%m-%d") 
| eval Begin_time=strptime(date." 4:43:55:336 AM","%Y-%m-%d %H:%M:%S:%3Q")
| eval End_time=strptime(date." 4:53:00:00 AM","%Y-%m-%d %H:%M:%S:%3Q")

Here I have used your provided static value as Begin_time and End_time. You can use your filed name also.
In the date field you can mention your required date as well.

[UPDATED]

Consider below search.

| makeresults 
| eval Begin_time=strptime("04/01/2019 4:43:55:336 AM","%d/%m/%Y %H:%M:%S:%3Q")
| eval End_time=strptime("04/01/2019 4:53:00:00 AM","%d/%m/%Y %H:%M:%S:%3Q")

Thanks

0 Karma

kamlesh_vaghela
SplunkTrust
SplunkTrust

@Deepz2612

I have updated my answer. Please check it.

0 Karma

kamlesh_vaghela
SplunkTrust
SplunkTrust

@Deepz2612
You have the Begin time and End time!! But what date you want to consider ?? Current date?

0 Karma
Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...