Splunk Search

count value per minute and then sum the count per hour

mmdacutanan
Explorer

I have the query that gives me the results I need. I just wanted to ask the gurus out here to look at my SPL and if there is a more efficient way to do it then I'd love to hear it. 😃 Thanks in advance!

Here's the SPL:

index=abc (sourcetype=abc_MainReportLog  "Entered Phone Number" Phone!=1234567890) OR ( sourcetype=abc_core_MainReportLog "\|RemoteApplicationData\|" VH_ICMUUI_CALLVARIABLE3!=1234567890 CV7=*)
| rename CALLVARIABLE3 as Phone
| bucket _time span=1m
| stats dc(CallID) as Count by _time Phone CV7
| where Count >=2
| timechart span=1h sum(Count) as Total
| fillnull value=0
Tags (1)
0 Karma
Get Updates on the Splunk Community!

Upcoming Webinar: Unmasking Insider Threats with Slunk Enterprise Security’s UEBA

Join us on Wed, Dec 10. at 10AM PST / 1PM EST for a live webinar and demo with Splunk experts! Discover how ...

.conf25 technical session recap of Observability for Gen AI: Monitoring LLM ...

If you’re unfamiliar, .conf is Splunk’s premier event where the Splunk community, customers, partners, and ...

A Season of Skills: New Splunk Courses to Light Up Your Learning Journey

There’s something special about this time of year—maybe it’s the glow of the holidays, maybe it’s the ...