Splunk Dev

I want to find daily Indexed size and over all Indexed size

rakesh44
Communicator

Hi Friends,

I have one Index name myindex , with sourcetype application, need to find out daily and monthly Indexed size for specific Index.

| dbinspect index=myindex | eval GB=sizeOnDiskMB/1024| stats sum(GB)

Getting 15.46 GB is this correct for over all Index size, if yes then need to daily indexed size for myindex.Thanks

Tags (1)
1 Solution

chrisyounger
SplunkTrust
SplunkTrust

Oh also, if you use the timepicker with your current query it will work for what you want. Alternatively use this query:

| dbinspect index=_internal earliest=-1d@d latest=-0d@d | eval GB=sizeOnDiskMB/1024| stats sum(GB)

View solution in original post

0 Karma

chrisyounger
SplunkTrust
SplunkTrust

Oh also, if you use the timepicker with your current query it will work for what you want. Alternatively use this query:

| dbinspect index=_internal earliest=-1d@d latest=-0d@d | eval GB=sizeOnDiskMB/1024| stats sum(GB)

0 Karma

rakesh44
Communicator

One help if am having 2 different sourcetype, and like to know which sourcetype took how much indexed size , do we have any such provision.Thanks

0 Karma

chrisyounger
SplunkTrust
SplunkTrust

Its not possible to determine the size on disk between two sourcetypes in the same index. This is because their terms/keywords will be shared.

If you wish to know the uncompressed size of the data you could do this:

index=myindex | eval len=len(_raw)| stats sum(len) by sourcetype

0 Karma

chrisyounger
SplunkTrust
SplunkTrust

Hi @rakesh44
There is a dashboard in the monitoring console that can easily tell you this information:

Settings >Monitoring Console >Indexing > License Usage

All the best

0 Karma

rakesh44
Communicator

Thanks for quick reply, I dont have monitoring console.Thanks

0 Karma
Get Updates on the Splunk Community!

Detecting Remote Code Executions With the Splunk Threat Research Team

WATCH NOWRemote code execution (RCE) vulnerabilities pose a significant risk to organizations. If exploited, ...

Enter the Splunk Community Dashboard Challenge for Your Chance to Win!

The Splunk Community Dashboard Challenge is underway! This is your chance to showcase your skills in creating ...

.conf24 | Session Scheduler is Live!!

.conf24 is happening June 11 - 14 in Las Vegas, and we are thrilled to announce that the conference catalog ...