Splunk Search

How can I write a search to find lost connections with hosts?

mpace
New Member

Greetings,

I am using a syslog setup for my data source. I am trying to create a way to search for lost connection by comparing last event received to the time now. I have events that come in about every 1-2 secs, I need a way where I can run a real-time search for any time an event is greater than, Ex: 10 secs, and notify me when that happens. I am stuck on the syntax portion of writing this expression. I have tried

host="ip" compare=latest=-10s < timenow=now()

but I am pretty sure I have the syntax wrong.

Thanks
Mac

0 Karma

somesoni2
Revered Legend

Try something like this

index=yourindex sourcetype=yoursource host="ip" | where (_time-now())>10 
0 Karma

mpace
New Member

Do I need to index=main sourcetype=generic_single_line host="ip" | where (_time-time()) > 10. Is the integer <10> in the units of seconds or milliseconds, or do I need to specify the integer as units of seconds <10s>. As of right now I do not receive results by changing time to 1 or .1

thanks

0 Karma

somesoni2
Revered Legend

The _time and now() give time in epoch format (which is no of seconds after jan 01 1970. THere difference will be in seconds. ALso, the function to get current time is now() and not time().

0 Karma

mpace
New Member

I am still getting no results even when I unplug the device for test.

0 Karma
Get Updates on the Splunk Community!

Enterprise Security Content Update (ESCU) | New Releases

In December, the Splunk Threat Research Team had 1 release of new security content via the Enterprise Security ...

Why am I not seeing the finding in Splunk Enterprise Security Analyst Queue?

(This is the first of a series of 2 blogs). Splunk Enterprise Security is a fantastic tool that offers robust ...

Index This | What are the 12 Days of Splunk-mas?

December 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...