Splunk Search

how to calculate the data received per day?

pacifikn
Communicator

Greetings!!

Dear all!

Hope you are well.

 

I need your support on how to calculate the size of events we received per day, for instance, if you want to check the size of each data we have received in one week?

I am using Splunk enterprise (Linux server)

Thank you in advance!

 

 

Tags (1)
0 Karma
1 Solution

aasabatini
Motivator

Hi @pacifikn 

try this search 

index=_internal source=*license_usage.log | eval GB=b/1024/1024/1024 | stats sum(GB) by h | sort -sum(GB)
“The answer is out there, Neo, and it’s looking for you, and it will find you if you want it to.”

View solution in original post

0 Karma

pacifikn
Communicator

help me also on How to calculate the percentage of Daily license used? I mean per day?

0 Karma

aasabatini
Motivator

Hi @pacifikn 

try this search 

index=_internal source=*license_usage.log | eval GB=b/1024/1024/1024 | stats sum(GB) by h | sort -sum(GB)
“The answer is out there, Neo, and it’s looking for you, and it will find you if you want it to.”
0 Karma

pacifikn
Communicator

Thank you so much @aasabatini  for your prompt response,

This works well for each source, Is there anyhow you could also calculate the total size of all sources we have received?

0 Karma

aasabatini
Motivator

Hi @pacifikn 

 

index=_internal source=*license_usage.log  | eval GB=b/1024/1024/1024 | stats sum(GB) as volume_in_GB by idx s st | sort - volume_in_GB 
| rename idx AS index s AS source st AS sourcetype

if this search help karma point is appreciated

Alessandro

“The answer is out there, Neo, and it’s looking for you, and it will find you if you want it to.”
Get Updates on the Splunk Community!

Community Content Calendar, November Edition

Welcome to the November edition of our Community Spotlight! Each month, we dive into the Splunk Community to ...

October Community Champions: A Shoutout to Our Contributors!

As October comes to a close, we want to take a moment to celebrate the people who make the Splunk Community ...

Stay Connected: Your Guide to November Tech Talks, Office Hours, and Webinars!

What are Community Office Hours? Community Office Hours is an interactive 60-minute Zoom series where ...