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!

Index This | Forward, I’m heavy; backward, I’m not. What am I?

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

A Guide To Cloud Migration Success

As enterprises’ rapid expansion to the cloud continues, IT leaders are continuously looking for ways to focus ...

Join Us for Splunk University and Get Your Bootcamp Game On!

If you know, you know! Splunk University is the vibe this summer so register today for bootcamps galore ...