Custom Report All Users on All Computers

Discussion created by mark.potts Employee on Sep 13, 2018
Latest reply on Jun 26, 2019 by ken.staude

I have had a number of requests for a report to show all the users who have logged into any computer, this can be used for a number of purposes, for example identifying computers being regularly used by multiple people, or identifying all computers a certain user has logged into.


In all honesty, this one is a very simple report, but feel free to add your own spin on it.


select tco.[HostName], tu.[UserName], tcu.LastLogon, tcu.LogonCount, tcu.MostFrequent, tcu.MostRecent from
tblComputerUsers tcu
left join tblComputer tco on tcu.ComputerID = tco.ComputerID
left join tblUser tu on tcu.UserID = tu.UserID


As always, you could load this report into Snow License Manager, see my original post on how to do this.