SELECT c.connect_time
 , s.login_time
 , s.host_name
 , s.login_name
FROM sys.dm_exec_connections AS c
   JOIN sys.dm_exec_sessions AS s ON c.session_id = s.session_id

select *
from sys.dm_exec_sessions

select *
from sys.dm_exec_sessions
where is_user_process = 1

select s.login_name, *
from sys.dm_exec_connections c join sys.dm_exec_sessions s on  c.session_id =s.session_id