Splunk Search

Logon session time

ghnwmlguy
Explorer

I am trying to gather average login session times for a server given multiple users logon and logoff log entries. I am using ossec to filter the logs first so standard windows fields may not apply, but I have extracted the user field (called "user").

I am not really sure where to start since I cannot seem to figure out how to gather average user session times for any time period given there are multiple users.

Any ideas?

Tags (2)
0 Karma
1 Solution

David
Splunk Employee
Splunk Employee

If you have the events that indicate logon and logoff, you could build a transaction and then grab the duration, a la:

YourSearch | transaction Username startswith=LogonEventID endswith=LogoffEventID 
           | eval DurationInMin = round(duration/60,2) 
           | stats avg(DurationInMin) as "Average Session Duration (Minutes)" by Username

http://www.splunk.com/base/Documentation/latest/SearchReference/Transaction

View solution in original post

David
Splunk Employee
Splunk Employee

If you have the events that indicate logon and logoff, you could build a transaction and then grab the duration, a la:

YourSearch | transaction Username startswith=LogonEventID endswith=LogoffEventID 
           | eval DurationInMin = round(duration/60,2) 
           | stats avg(DurationInMin) as "Average Session Duration (Minutes)" by Username

http://www.splunk.com/base/Documentation/latest/SearchReference/Transaction

gkanapathy
Splunk Employee
Splunk Employee

Also, if there is a session ID (often there is not), it is probably more efficient (and definitely more scalable) to do: YourSearch | stats range(_time) as sessiondur by sessionID,Username | stats sum(sessiondur) as user_total_dur by Username instead.

gkanapathy
Splunk Employee
Splunk Employee

Minor thing I'd do is only round after taking the average: `... | stats avg(DurationInMin) as avgdur by Username | eval avgdur=round(avgdur/60,2) | rename avgdur as "Average Session Duration (Minutes)".

0 Karma

ghnwmlguy
Explorer

Thanks David, I can't beleive that have never noticed the transaction command.

0 Karma
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!

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 ...

Move CrowdStrike FDR ingestion to Data Inputs with a guided migration

CrowdStrike Falcon Data Replicator data is essential for security investigations, detections, and response. It ...

Make Your Machine Data AI-Ready in Splunk

Every team is getting ready for AI agents.    Watch On-Demand   In this Tech Talk, Splunk platform specialists ...