Splunk Search

List last one month peak traffic time

muniyappasamy_m
New Member

Hi,

Here is my query, It works fine for one day , but if i change the custom time like last one month data , then it is not showing last one month data, instead it show cumulative of intergers

i'm trying to get peak connections (connection/sec) for last one month.
Could any one please help me in this.

Stats comes for every 10 mins, so i divided/600 in order convert to seconds

index="rrs_interval_summary" HOST=*shsrrs*  | stats max(RRShttpConnections) as RRS_HTTP_CONNECTIONS by HOST |eval peak=RRS_HTTP_CONNECTIONS/600 |stats sum(peak) as peak
Tags (2)
0 Karma

somesoni2
SplunkTrust
SplunkTrust

If you're trying to get peak connection per second for a given period (a month in your case), simple use max without the "by HOST" clause.

index="rrs_interval_summary" HOST=*shsrrs*  | stats max(RRShttpConnections) as RRS_HTTP_CONNECTIONS |eval peak=RRS_HTTP_CONNECTIONS/600 
0 Karma

somesoni2
SplunkTrust
SplunkTrust

Stats is returning single value.

0 Karma

strive
Influencer

But he wont be able to plot all points on chart.. Isn't there a limit of 1000 points.

0 Karma

ankireddy007
Path Finder

Hi,

Do you want peak value in last 1 month by host? you can try like this (added by HOST at the end)

index="rrs_interval_summary" HOST=*shsrrs*  | stats max(RRShttpConnections) as RRS_HTTP_CONNECTIONS by HOST |eval peak=RRS_HTTP_CONNECTIONS/600 |stats sum(peak) as peak by HOST

or else you can try like below to know peak of all hosts

 stats sum(peak) as peak
0 Karma
Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...