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!

Webinar Recap | Revolutionizing IT Operations: The Transformative Power of AI and ML ...

The Transformative Power of AI and ML in Enhancing Observability   In the realm of IT operations, the ...

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

ICYMI - Check out the latest releases of Splunk Edge Processor

Splunk is pleased to announce the latest enhancements to Splunk Edge Processor.  HEC Receiver authorization ...