Splunk Searches | A collection of useful Splunk SPL

Splunk Search for Events with no timezone specified Copy


				| tstats count where index=* date_zone=local by index, sourcetype

0 comments

[0]

Splunk Search for Active correlation searches in Enterprise Security Copy


				| rest splunk_server=local /services/saved/searches | where match('action.correlationsearch.enabled', "1|[Tt]|[Tt][Rr][Uu][Ee]") and match('is_scheduled',"1") and match('disabled',"0") | table title search

0 comments

[0]

Splunk Search for Successful login after 10 failed attempts Copy


				| from datamodel:"Authentication"."Authentication"
| search action=failure OR action=success
| streamstats window=0 current=true reset_after="(action=\"success\")" count as failure_count by user
| where action="success" and failure_count > 10 | stats values(failure_count) as failure_count by user

0 comments

[0]

Splunk Search for All network traffic Copy


				| datamodel Network_Traffic All_Traffic search | dedup All_Traffic.dest | stats count by All_Traffic.src_ip, All_Traffic.dest,All_Traffic.action

0 comments

[1]

[0]