List All Users That Have Logged Onto a Workstation (non built-in)

[cstamand]

Description: List All Users on Workstation.

What The Data Shows: Useful to see if any local accounts created that aren't normal.

SQL:

Select
Username,
Description,
Directory 

FROM Users 

WHERE GID <> "513";

[esullivan]

Hey @cstamand  appreciate your contribution!  We'll vet this submission and if it runs as expected we'll change this status of your query from Under Review to CB Approved.

Thanks again!

Ed Sullivan

[tmccormack]

Thanks @cstamand as always for your participation in our community. Nice query.