1. PDQ Deploy & Inventory Help Center
  2. Community
  3. PDQ Inventory
 

Important Notice: On February 29th, this community was put into read-only mode. All existing posts will remain but customers are unable to add new posts or comment on existing. Please feel to join our Community Discord for any questions and discussions.

Way to see ever computer a user has logged in to?

Avatar
Evan Sullivan

I am wondering if there is a way to see list all the computers a user has logged in to. The agent logs that information, I would image there is a way?

0

Comments

2 comments
Date Votes
  • Avatar
    Evan Sullivan

    I am not an SQL wiz but I have been playing. Have this so far, but it's returning computers where I am not logged in the agent events.

    select AgentEvents.UserName, Computers.Name from AgentEvents, Computers where AgentEvents.UserName Like 'ASD\esullivan'

    I think it's not pulling only computer names from the agentevents where it equals the username, it's pulling all

    0
  • Avatar
    Evan Sullivan

    I got it for the most part, some tweaking to do but this does the trick

    select AgentEvents.UserName, Computers.Name from AgentEvents INNER JOIN Computers ON AgentEvents.ComputerId = Computers.ComputerId where AgentEvents.UserName Like 'asd\esullivan'

    0