mark.potts

Custom Report All Users on All Computers

Discussion created by mark.potts Employee on Sep 13, 2018

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.  https://community.snowsoftware.com/docs/DOC-1283-adding-custom-sql-reports-in-snow-license-manager

Outcomes