Splunk Search

Details on indexes

beepboop12
Explorer

Hello, I need certain details for my indexes. I have searched Splunk answers but have yet to find an answer that works for me.

Essentially, I need to find the average daily volume for my indexes in the last ~30 days. I also need to find out how the indexes are being used and by whom.

Any information would be greatly appreciated. Thank you for your help

0 Karma

aljohnson_splun
Splunk Employee
Splunk Employee

Daily Volume for Indexes

Check out S.o.S. (Splunk on Splunk) ! It's a free app.

alt text

`set_internal_index` host="some_host" source=*metrics.log group="per_index_thruput"
                | bin _time 
                | stats sum(kb) AS KB by series,_time
                | timechart minspan=30s  avg(eval(round(KB/1024/1024,2))) by series

You could then change sum (like the image) to avg (in the code above).

Index Access & Usage

It sounds like you want to explore the _internal index!

See this documentation for lots of information.

martin_mueller
SplunkTrust
SplunkTrust

Additionally, if you're on 6.2.x, check out the Distributed Management Console that ships since this version. It has many great base statistics you can work off from.

0 Karma

knutsod
Path Finder

For the index usage, use this search to get started:

index=_internal source="*metrics.log" group="per_index_thruput" | timechart span=1d sum(kb) by series

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Announcing Modern Navigation: A New Era of Splunk User Experience

We are excited to introduce the Modern Navigation feature in the Splunk Platform, available to both cloud and ...

Modernize your Splunk Apps – Introducing Python 3.13 in Splunk

We are excited to announce that the upcoming releases of Splunk Enterprise 10.2.x and Splunk Cloud Platform ...

Step into “Hunt the Insider: An Splunk ES Premier Mystery” to catch a cybercriminal ...

After a whole week of being on call, you fell asleep on your keyboard, and you hit a sequence of buttons that ...