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!

Introducing Splunk Enterprise 9.2

WATCH HERE! Watch this Tech Talk to learn about the latest features and enhancements shipped in the new Splunk ...

Adoption of RUM and APM at Splunk

    Unleash the power of Splunk Observability   Watch Now In this can't miss Tech Talk! The Splunk Growth ...

Routing logs with Splunk OTel Collector for Kubernetes

The Splunk Distribution of the OpenTelemetry (OTel) Collector is a product that provides a way to ingest ...