Splunk Search

Splunk Time difference search

Sirius27
New Member

I have two results of servers list as per last 30 days and last 12 hrs. I want to compare and find out which servers are not reporting in 12 hrs list. What can be the query for it.
Little new in Splunk.

Labels (1)
0 Karma

Sirius_27
Explorer

Hi,
That worked wonderfully, but I'm not getting what type of output is coming lastreport as  some 10 numbers of digit is coming in it.

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

lastreport will be an epoch time i.e. the number of seconds since the beginning of 1970. Use strftime to format how it is displayed

| fieldformat lastreport=strftime(lastreport,"%Y/%m/%d %H:%M:%S")

 

ITWhisperer
SplunkTrust
SplunkTrust
| stats latest(_time) as lastreport by server
| where now()-lastreport > 12*60*60
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 ...