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!

App Platform's 2025 Year in Review: A Year of Innovation, Growth, and Community

As we step into 2026, it’s the perfect moment to reflect on what an extraordinary year 2025 was for the Splunk ...

Operationalizing Entity Risk Score with Enterprise Security 8.3+

Overview Enterprise Security 8.3 introduces a powerful new feature called “Entity Risk Scoring” (ERS) for ...

Unlock Database Monitoring with Splunk Observability Cloud

  In today’s fast-paced digital landscape, even minor database slowdowns can disrupt user experiences and ...