Method of finding currently logged on users in database
In database,what is the method of finding how many users are currently logged into the system and what are their IP addresses.
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Pravin MorePosted Nov 29, 2011, 12:35 AM
Hi stephen, use below query...
SELECT HOST_NAME() AS HostName, SUSER_NAME() LoggedInUser
Thanks,
Pravin