Splunk Search

Proper Std Dev Generation

bnafziger
Engager

I am a newbie. I'd like an another user's opinion of my logic. Is this the proper syntax for generation of std dev? In particular, to show the prior 7 days of the std dev of total, successful and failed logins using a prior 30 day time span? This is crufted logic from several other answers. Thank you.

    [index source sourcetype]  %ASA-auth "AAA user authentication" earliest=-60d@d latest=now 
    | timechart span=60m count as total 
    count(eval(searchmatch("Successful"))) as success 
    count(eval(searchmatch("Rejected"))) as rejected
    | streamstats window=720 stdev(total) as stdevtotal mean(total) as meantotal
    | streamstats window=720 stdev(success) as stdevSuccess mean(success) as meanSuccess
    | streamstats window=720 stdev(rejected) as stdevRejected mean(rejected) as meanRejected
    | eval total = (total - meantotal) / stdevtotal 
    | eval success = (success - meanSuccess) / stdevSuccess
    | eval rejected = (rejected - meanRejected) / stdevRejected 
    | eval three = 3
    | fields _time total success rejected three
    | where _time > relative_time(now(),"-7d@d")
Tags (2)
0 Karma

richcollier
Path Finder

Hi bnafziger,

I'm not sure of your ultimate goal, but it looks as if you want to find "outliers" in events based upon "normal" historical behavior. The problem with using just plain old "average" and "std deviation" is that if the "model" of the data isn't a perfect Gaussian distribution (i.e. a "bell curve") , then using avg and stdev will yield misleading results.

An alternative approach is to do what the Prelert Anomaly Detective app does, which uses dynamic modeling to "fit" the data better and you'll get more accurate results. And, it's easy to use!

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!

Accelerate Splunk App Development with AI

  Learn how to automate the repetitive parts of your build cycle.   Watch On-Demand   Replay the Accelerate ...

Splunk Agent Observability: Measuring AI Value with Splunk Tokenomics on AWS

The AI landscape is moving faster than ever, and our latest 2026 State of Observability report provides the ...

Enterprise Security Watch Party: What’s New in 8.8 - Recap

Splunk Community HQ hosted a Splunk Enterprise Security Watch Party: What’s New In ES 8.8 last Thursday. I had ...