SELECT login_name, session_count, last_batch_time
FROM(
SELECT login_name ,COUNT(session_id) AS session_count, MAX(last_request_end_time) AS last_batch_time
FROM sys.dm_exec_sessions
GROUP BY login_name
) p
ORDER BY session_count DESC
FROM(
SELECT login_name ,COUNT(session_id) AS session_count, MAX(last_request_end_time) AS last_batch_time
FROM sys.dm_exec_sessions
GROUP BY login_name
) p
ORDER BY session_count DESC