topic How to calculate volume of events across various indexes ? in Getting Data In

How to calculate volume of events across various indexes ?

xbbj3nj — Thu, 10 Apr 2014 21:20:01 GMT

All I want to do is create a query that fetches the below result

Day Index-name Volume
4/1 abc 5GB
4/2 abc 8GB
4/3 abc 10GB
4/4 abc 15GB
4/5 abc 4GB
........

Can any one help on this regard ? Any help is much appreciated

Re: How to calculate volume of events across various indexes ?

martin_mueller — Thu, 10 Apr 2014 21:42:06 GMT

The SoS app should give you that out of the box, Indexing -> Indexing Performance -> split by index
http://apps.splunk.com/app/748/

Re: How to calculate volume of events across various indexes ?

xbbj3nj — Thu, 10 Apr 2014 21:53:10 GMT

Thank you so much !! but what does the Total column indicate.. is it volume in GB ? and i have 2 indexers.. so can i get a one shot view of volume in gb by individual indexes.

Re: How to calculate volume of events across various indexes ?

martin_mueller — Mon, 28 Sep 2020 16:21:57 GMT

...app/sos/indexing_performance lets you pick any indexer and can split by index, .../app/sos/indexing_distributed lets you split by indexers but not by index... but this being Splunk, anything can be extended. Taking the queries from those two views, you could build this:

`set_internal_index` source=*metrics.log group=per_index_thruput [inputlookup splunk_servers_cache | search server_role!="search-head" | search server_role!="*forwarder*" | eval host=sos_server | fields host] | timechart minspan=30s per_second(kb) AS KBps by series useother=false limit=100

Re: How to calculate volume of events across various indexes ?

martin_mueller — Thu, 10 Apr 2014 22:05:01 GMT

You may also want to take a look at http://host:8000/en-US/app/sos/license_usage_30days on your license master, that gives you a volume per day splittable by index.
Also available under http://host:8000/en-US/manager/search/licenseusage not requiring SoS.