Splunk Search

Search String for Connection hangs

jsproesser
New Member

I have been toying around with the task of identifying servers on our network with abnormal connection times . We have a set threshold for normal connection times in our environment. However, I want to get ahead and create an alert based off this report that I will transition to a dashboard.

The issue I am having is that I am relatively new to Splunk and still finding my groove in detailed searches. I thought about using eval combined with timestart and timeendpos.

|eval Connection=timestart-timeend....

My question to you all is , how far off am I ? Am I putting too much effort into skinning this cat? Does anyone have any recommendations?

Thanks in advance !

Tags (2)
0 Karma

niketn
Legend

@jsproesser how many indexers have you got?

Also what is your current SPL? Have you used Job Inspector to see which are the expensive commands in your search?

In order for the community to assist you better please provide more details including SPL and data sample. You should mock/anonymize any sensitive information before posting the same.

____________________________________________
| makeresults | eval message= "Happy Splunking!!!"
0 Karma

jsproesser
New Member

niketnilay ,

Below is my rather pedestrian SPL . I have not checked the job inspector. I'm just trying to see if I can further improve my search .

index=os sourcetype=linux_secure host=* success

|eval Difference=timeendpos-timestartpos
| stats count by host,Difference

| sort -Difference

0 Karma

jsproesser
New Member

My issue is that my result are only returning events where the timeendpos is greater than 16

Event

11/2/19
11:57:47.000 PM
Nov 2 23:57:47 (SERVER NAME) debug httpd[12456]: pam_bigip_authz: pam_sm_acct_mgmt returning status SUCCESS
eventtype = nix-all-logs eventtype = nix_security os unix host = (HOST) source = /var/log/secure sourcetype = linux_secure timeendpos = 16 timestartpos = 0

0 Karma

arjunpkishore5
Motivator

Could you post some sample data and the expected output please. It will be easier for us to analyze 🙂

0 Karma

jsproesser
New Member

arjun,

I have posted an event example below.

My expected output is a list of servers which are experiencing slow connections that exceed our threshold within my organization.

0 Karma
Get Updates on the Splunk Community!

Stay Connected: Your Guide to July and August Tech Talks, Office Hours, and Webinars!

Dive into our sizzling summer lineup for July and August Community Office Hours and Tech Talks. Scroll down to ...

Edge Processor Scaling, Energy & Manufacturing Use Cases, and More New Articles on ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

Get More Out of Your Security Practice With a SIEM

Get More Out of Your Security Practice With a SIEMWednesday, July 31, 2024  |  11AM PT / 2PM ETREGISTER ...