Find Users Logged Into Remote Computer

Have you ever wanted to find out if someone is logged into a computer or maybe who is logged into a computer without having to remote in to check? Recently I was working on a project doing some SharePoint work using 3 accounts: Admin/Install, Farm and Service. The work I was doing required a lot of remote desktop switching between those three accounts, across three environments, plus the SQL Servers and SQL Server service account. Rather than opening up Remote Desktop and logging into each server to see what accounts were logged in I figured I would fire up the good ol’ command line and check that way. There are tons of other ways to do this using PowerShell and I’m sure other command line methods, but this one is quick and easy.
Just fire up the command prompt or PowerShell and run this:
query session /server:”<Server Name Here>”
query session /server:”KERBEROS-SP”
UsersLoggedInRemote_1
As we see in the screenshot there is one user logged into this computer, the Administrator account. If you want to check multiple computers just create a list in notepad and save it as a batch file to run. This clearly won’t work for a large quantity of servers, but it worked great for the 6 servers I needed to check.
Unfortunately if the user does not have the appropriate permissions on the server they will not get an error message. Instead the result will list no sessions.
UsersLoggedInRemote_2

About the author

Bradley Schacht

Bradley Schacht is a Senior Program Manager on the Microsoft Azure Synapse Analytics team based in Jacksonville, FL. He has worked with Microsoft SQL Server and Azure data services since 2009 as a consultant, trainer, and architect. He has co-authored 4 SQL Server and Power BI books, most recently the Microsoft Power BI Quick Start Guide. Bradley enjoys solving interesting problems and teaching others to use new technology. He frequently presents at community events around the country, is a contributor to sites such as SQLServerCentral.com, and is a member of the Jacksonville SQL Server User Group (JSSUG).

3 comments

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Bradley Schacht

Bradley Schacht is a Senior Program Manager on the Microsoft Azure Synapse Analytics team based in Jacksonville, FL. He has worked with Microsoft SQL Server and Azure data services since 2009 as a consultant, trainer, and architect. He has co-authored 4 SQL Server and Power BI books, most recently the Microsoft Power BI Quick Start Guide. Bradley enjoys solving interesting problems and teaching others to use new technology. He frequently presents at community events around the country, is a contributor to sites such as SQLServerCentral.com, and is a member of the Jacksonville SQL Server User Group (JSSUG).

Follow Me