The following SELECT statement displays information on all current session.
SELECT UserName, SessionNo, DefaultDatabase, LogonSource FROM DBC.SessionInfoV;
Result:
UserName SessionNo DefaultDatabase LogonSource --------- --------- --------------- ---------------------------- DBC 1,005 DBC <TCP/IP> EB9F 141.206.1.84