İpucu

select 'Authentication Method'=( case when nt_user_name is not null then 'Windows Authentication' else 'SQL Authentication' end), login_name as 'Login Name', ISNULL(nt_user_name,'-') as 'Windows Login Name', COUNT(session_id) as 'Session Count' from sys.dm_exec_sessions group by login_name,nt_user_name