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!

Observe and Secure All Apps with Splunk

  Join Us for Our Next Tech Talk: Observe and Secure All Apps with SplunkAs organizations continue to innovate ...

Splunk Decoded: Business Transactions vs Business IQ

It’s the morning of Black Friday, and your e-commerce site is handling 10x normal traffic. Orders are flowing, ...

Fastest way to demo Observability

I’ve been having a lot of fun learning about Kubernetes and Observability. I set myself an interesting ...