MS-SQL

[#9] Mac Address 및 IP Address 확인 Query

김뽀씨 2013. 6. 17. 13:42

----------------------------------------------------------------

[쿼리]

SELECT A.NET_ADDRESS, B.CLIENT_NET_ADDRESS
FROM SYS.SYSPROCESSES AS A, SYS.DM_EXEC_CONNECTIONS AS B
WHERE A.SPID = B.SESSION_ID AND A.SPID = @@SPID

----------------------------------------------------------------