Monitoring Splunk

Query to compare total throughput for two distinct dates

chama4tem
Loves-to-Learn

I would like to compare total throughput for two dates 60 days apart (say, current and -60d). The query in the CMC that generates the throughput is 

index=_internal (host=`sim_indexer_url` OR host=`sim_si_url`) sourcetype=splunkd group=per_Index_thruput series!=_*
| timechart minspan=30s per_second(kb) as kb by series

I need the series information, but it could be binned into 1 whole day.

 

Labels (1)
0 Karma

chama4tem
Loves-to-Learn

90 days

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

So what is the time of your earliest event?

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

Try something like this

index=_internal (host=`sim_indexer_url` OR host=`sim_si_url`) sourcetype=splunkd group=per_Index_thruput series!=_* (earliest=@d latest=now) OR (earliest=-60d@d latest=-59d@d)
| timechart minspan=30s per_second(kb) as kb by series
0 Karma

chama4tem
Loves-to-Learn

Hi this doesn't work; I'm not getting anything for the earlier dates (and I have expanded the date range to two days before the -60 date and today).

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

What is the retention period on your index or the earliest event in your index?

0 Karma
Get Updates on the Splunk Community!

Application management with Targeted Application Install for Victoria Experience

  Experience a new era of flexibility in managing your Splunk Cloud Platform apps! With Targeted Application ...

Index This | What goes up and never comes down?

January 2026 Edition  Hayyy Splunk Education Enthusiasts and the Eternally Curious!   We’re back with this ...

Splunkers, Pack Your Bags: Why Cisco Live EMEA is Your Next Big Destination

The Power of Two: Splunk + Cisco at "Ludicrous Scale"   You know Splunk. You know Cisco. But have you seen ...