DB/MSSQL
[MSSQL] 접속 세션 조회 및 아이피 확인
alien22c
2024. 8. 20. 22:29
728x90
728x90
접속세션확인/아이피확인
SELECT P.spid
, P.login_time
, P.last_batch
, P.status
, P.hostname
, P.program_name
, P.cmd
, C.client_net_address
FROM sys.sysprocesses AS P
INNER JOIN sys.dm_exec_connections AS C
ON P.spid=C.session_id
ORDER BY hostname
;
728x90
728x90