Query Exchange

 View Only

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

    Posted May 30, 2019 02:40 PM

    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";

    #IncidentResponse
    #Windows
    #Community
    #ITHygiene
    #HelpDeskOperations
    #Compliance


  • 2.  RE: List All Users That Have Logged Onto a Workstation (non built-in)

    Posted Jun 05, 2019 11:19 AM

    Hey   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



  • 3.  RE: List All Users That Have Logged Onto a Workstation (non built-in)

    Posted Jun 06, 2019 09:04 PM

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