index=_audit sourcetype=audittrail (action="login attempt" OR action="logout") | stats values(_time) as action_time by user, action | eventstats range(action_time) as range by user | eventstats min(action_time) as min_time max(action_time) as max_time by user, range | where action="login attempt" OR action="logout" | stats values(action_time) as action_time by user | eval login_time=mvindex(action_time, 0), logout_time=mvindex(action_time, -1) | eval session_duration=logout_time - login_time | eval session_duration_str=strftime(session_duration, "%H:%M:%S") | table user session_duration_str from this search I would need to know the duration of the individual days
... View more