MS SQL - wyświetlenie połączeń z Bazami na hoscie

SELECT
    s.session_id,
    s.login_name,
    s.host_name,
    s.program_name,
    c.client_net_address,
    s.status,
    s.last_request_start_time,
    s.last_request_end_time
FROM sys.dm_exec_sessions s
LEFT JOIN sys.dm_exec_connections c
    ON s.session_id = c.session_id
WHERE s.is_user_process = 1;

SELECT 
    d.name AS DatabaseName,
    d.compatibility_level AS CompatibilityLevel,
    SERVERPROPERTY('ProductVersion') AS EngineVersion,
    SERVERPROPERTY('ProductLevel') AS EngineLevel,
    SERVERPROPERTY('Edition') AS EngineEdition
FROM sys.databases d
ORDER BY d.name;