Ill start off i am newer to splunk....
I am using the following search
index=server source="WinEvent" EventCode=1234 OR EventCode=5678| eval locked_account_name=mvindex(Account_Name, 1)| eval account_that_unlokcedit=mvindex(Security_ID, 0)| transaction startswith="locked out" endswith="unlocked"| stats sum(duration) as duration by locked_account_name account_that_unlokcedit| eval min=duration/60| eval min=round(min,2)| search account_that_unlokcedit=*APP1234* OR account_that_unlokcedit=*z_xxx* OR account_that_unlokcedit=*APP56789*
I need to chang the min column to minutes..... then i need to get the average of that column(minutes) and put the average in its own column
| rename min as minutes
| eventstats avg(minutes) as avgMinutes
View solution in original post