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
Get Updates on the Splunk Community!

Splunk APM: New Product Features + Community Office Hours Recap!

Howdy Splunk Community! Over the past few months, we’ve had a lot going on in the world of Splunk Application ...

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 ...