Splunk Search

timechart total mb per source

arjangoos
Path Finder

I want to create a timechart line graph based on: total kb per source over time. Now I have:

index="_internal" source="*metrics.log" per_source_thruput access_log | bin _time span=1d as day | timechart sum(kb) as totalKB | streamstats sum(totalKB)

This search works but only for access_log, I want to see all sources in one graph

time size result

on 0:00 100kb 100kb

on 1:00 50kb 150kb

on 1:30 27kb 177kb

Tags (1)
0 Karma

arjangoos
Path Finder

Ok thanks for your reply. But it is not an answer to my question. So if anyone knows how I can solve my problem.

0 Karma

yannK
Splunk Employee
Splunk Employee

so you can use the same search, differentiate per series. (the bucket is not necessary, timechart will to it)


index=_internal source="*metrics.log" per_source_thruput |timechart span=1d sum(kb) as totalKB by series | streamstats sum(totalKB)

the totalKB will be the total of each day added the previous days, if you want total per unique day, use |addtotals


index=_internal source="*metrics.log" per_source_thruput |timechart span=1d sum(kb) as totalKB by series | addtotals

then click on the graph display (the third display mode)

0 Karma

yannK
Splunk Employee
Splunk Employee

Do you know that metrics.log contains only a sample of the measures (top 10), this means that you can look at speed measures, but not a volume, especially if yo have more than 10 sources...

if you want to measure precisely the volume per source, check this guide, using license_usage.log

http://wiki.splunk.com/Community:TroubleshootingIndexedDataVolume

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!

How to Break a Kubernetes Pod on Purpose and Let the AI Troubleshooting Agent Find ...

Let's say I've just rolled out a Kubernetes Deployment with a typo in the image tag. Nothing explodes. The pod ...

Splunk Add-on for Microsoft Windows 11.0.3: Parse Once, Search Faster

The updated Splunk Add-on for Microsoft Windows helps customers search Windows events faster by reducing ...

What's New in Splunk Enterprise Security 8.8 and Beyond

Threats move at machine speed. Keeping up should not depend on having the biggest budget, the largest team, or ...