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.

Users Logged onto multiple computers.

Avatar
mmuni

What would be the best way to setup a report that checks for duplicates?

For example a list of computers, but only ones for a user that is currently logged on to multiple computers.

0

Comments

2 comments
Date Votes
  • Avatar
    mmuni

    I used a SQL report and was able to get a list of users who were logged onto multiple computers and how many they were logged into.

    select Computers.Name as "Computer Name", Computers.CurrentUser, COUNT(*) from Computers where <ComputerFilter> group by Computers.CurrentUser having COUNT(*) > 1

    however I would like to have a list of computers for which the user is also logged onto another computer.

    0
  • Avatar
    Brigg Angus

    Hi Mmuni,

    Shane was able to come up with a fancy SQL report that should give you what you want:

    SELECT UPPER(CurrentUser) AS User, Name AS Computer
    FROM Computers where CurrentUser IN (SELECT CurrentUser FROM Computers GROUP BY CurrentUser HAVING COUNT(*) > 1)
    AND NOT CurrentUser = '' AND <ComputerFilter>
    ORDER BY Name ASC

    I wasn't able to get the ORDER BY to play nice, though.

    0