Splunk Searches | A collection of useful Splunk SPL

Splunk Search for Indexes Created by Users Copy


				index=_internal sourcetype=splunk_python action="handleCreate"
| stats latest(_time) as _time by loginUsername indexName

0 comments

[0]

Splunk Search for Size of KV Store Collections Copy


				 | rest splunk_server=local /servicesNS/nobody/-/storage/collections/config | fields title eai:acl.owner eai:acl.app | where !match(title,"\.mlmodel") | rename eai:acl.* as * | map [ | inputlookup $title$ | foreach * [ | eval b_<<FIELD>>=len(<<FIELD>>) + 1 ] | addtotals b_* fieldname=b | stats sum(eval(b/1024/1024)) as mb | eval name="$title$", owner="$owner$", app="$app$" ] maxsearches=1000

0 comments

[0]

Splunk Search for Universal Forwarders with Expired Certificates Copy


				index=_internal sourcetype=splunkd (alert_description="'certificate expired'" component=SSLCommon) OR (component=TcpInputProc AND "certificate verify failed")

0 comments

[0]

Splunk Search for Check for Hosts Hitting Max File Descriptor (max_fd) Limit Copy


				index=_internal sourcetype=splunkd "TailReader - File descriptor cache is full" "trimming" | stats count by host

0 comments

[0]

Splunk Search for Sourcetypes that are Being Truncated Copy


				index=_internal sourcetype=splunkd "truncating line" 
| rex field=_raw "line length\s+>=\s+(?<length>\d+)" 
| search length=* 
| stats max(length) as length, count by data_sourcetype

0 comments

[0]

Splunk Search for Ingested Comments Copy


				 [ | tstats count where punct=#* by index, sourcetype | fields - count | format ] _raw=#*

0 comments

[0]

Splunk Search for Volume of Ingested Comments Copy


				[ | tstats count where punct=#* by index, sourcetype | fields - count | format ] _raw=#* 
| eval gb=len(_raw)/pow(1024,3)
| timechart span=1d sum(gb)

0 comments

[0]

Splunk Search for License Usage by Sourcetype Copy


				index=_internal source=*license_usage.log type="Usage" 
 | eval indexname = if(len(idx)=0 OR isnull(idx),"(UNKNOWN)",idx)
```| search st=<insert sourcetype here>```
| timechart span=1d sum(eval(b/pow(1024,3))) by st

0 comments

[0]

Splunk Search for Queued Searches Copy


				index=_internal sourcetype=splunkd group=search_concurrency name=search_queue_metrics | timechart avg(current_queue_size)

0 comments

[0]

Splunk Search for Splunk User Creations, Modifications, Deletions Copy


				 index=_audit action=edit_user operation=create
 |rename object as user
 |eval timestamp=strptime(timestamp, "%m-%d-%Y %H:%M:%S.%3N") 
 |convert timeformat="%d/%b/%Y" ctime(timestamp)
 |table user timestamp

0 comments

[0]