Domain Users logged into multiple computers

[KHabershon]

Anyone have a report or can create one that shows a list of a "single" user that has logged into multiple computers.

What I am trying to do is find out a list of users that potentially have multiple systems, like a desktop and then also has a laptop.

[Kreg]

Hi there,
Someone can share the query for LanSweeper 5 ?
I have the same need 🙂

Many thanks

[KHabershon]

This is what I used specifically

SELECT query.Domain, query.Username, COUNT(query.Computername) AS Expr1, tblcomputers.Computer
FROM (SELECT DISTINCT Computername, Domain, Username, ADsite
FROM tblCPlogoninfo
GROUP BY ALL Computername, Domain, Username, ADsite) AS query INNER JOIN
tblcomputers ON query.Computername = tblcomputers.Computername

WHERE ADSite LIKE '%<YOUR AD SITE HERE>%'
GROUP BY query.Domain, query.Username, tblcomputers.Computer
ORDER BY tblcomputers.Computer

[Kassim]

Hi KHabershon,

would you be able to provide the complete SQL query with your addition?

Thanks

[KHabershon]

Worked well thank you, I added the tblcomputers.Computer since I needed to find all the individual system names.

[Hemoco · Accepted solution]

Can you try this one:

Select query.Domain, query.Username, Count(query.Computername)
From (Select Distinct tblCPlogoninfo.Computername, tblCPlogoninfo.Domain,
      tblCPlogoninfo.Username
    From tblCPlogoninfo       
    Group By All tblCPlogoninfo.Computername, tblCPlogoninfo.Domain,
      tblCPlogoninfo.Username) query
Group By query.Domain, query.Username
Order By Count(query.Computername) Desc