Reporting

Inconsistency in the data every day while running the query report

deepthi5
Path Finder
index=wineventlog EventCode=4625 | search user!="sa*" AND user!="VD*" AND user_email!=""

| bucket _time span=10m

| eval minute=strftime(_time, "%M")

| eval hour=strftime(_time, "%H")

| eval day=strftime(_time, "%D")

| eval wday=strftime(_time, "%A")

| stats count(EventCode) as aantal by hour, wday, day

| rename aantal as #_failed_logins

| eval search_value = wday+"_"+hour

| table hour, day, wday, search_value, #_failed_logins, upperBound, upperBound_2stdev, upperBound_2.5stdev, upperBound_3stdev, upperBound_3.5stdev, upperBound_4stdev, twoSigmaLimit, hour_avg, hour_avg_2sig, hour_stdev, hour_stdev_2sig

 

 

Every day this query gives a different count 

Labels (2)
0 Karma

somesoni2
Revered Legend

Different count of rows OR different count for #_Failed_Logins?

The number of rows depends upon the availability of events in Splunk, so they may not be same every day (unless you expect same number failed logins every day occurring on same hour every day).

0 Karma

deepthi5
Path Finder

Different count of #_Failed_logins

deepthi5_0-1657119758953.pngdeepthi5_1-1657119766500.png

deepthi5_2-1657119776066.png

 

0 Karma
Get Updates on the Splunk Community!

Splunk Observability for AI

Don’t miss out on an exciting Tech Talk on Splunk Observability for AI!Discover how Splunk’s agentic AI ...

Splunk Enterprise Security 8.x: The Essential Upgrade for Threat Detection, ...

Watch On Demand the Tech Talk on November 6 at 11AM PT, and empower your SOC to reach new heights! Duration: ...

Splunk Observability as Code: From Zero to Dashboard

For the details on what Self-Service Observability and Observability as Code is, we have some awesome content ...