Splunk Search

Need a search string to find MB indexed per 24 hour by a specific host

nls21
Explorer

Need a search string to find MB indexed per 24 hour by a specific host. Can someone send an example?

Tags (1)
0 Karma

dnolan
Explorer

I use this search to get a chart of per-host indexing volume:

index="_internal" source="*metrics.log" per_host_thruput | chart sum(kb) by series

An easy change to that is to search by the hostname in the series field:

index="_internal" source="*metrics.log" per_host_thruput series=some-host-name | stats sum(kb)

For extra fun, lets look at 30 day trends:

index="_internal" source="*metrics.log" per_host_thruput series=some-host-name earliest=-30d@d latest=@d | timechart span=1d sum(kb)
0 Karma

Simeon
Splunk Employee
Splunk Employee

If the host is in the top 10 hosts of traffic, you can do:

index=_internal source=*metrics.log* per_host_thruput <hostname> | eval mb=kb/1024 | timechart span=1d sum(mb) as Total

If it is not in the top 10 hosts, you will have to do a raw length search that can be expensive. So something like:

host=<hostname> | eval size=len(_raw) | timechart span=1d sum(size) | addtotals
0 Karma

hbazan
Path Finder

app/search/indexing_volume ?

0 Karma
Get Updates on the Splunk Community!

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

ICYMI - Check out the latest releases of Splunk Edge Processor

Splunk is pleased to announce the latest enhancements to Splunk Edge Processor.  HEC Receiver authorization ...

Introducing the 2024 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...