Lansweeper User Account report

[dlafleur]

Good day everyone.

Is there a report out there somewhere for On-Prem and Cloud that will show who has account access in Lansweeper?
Basically a report showing who has access to log into Lansweeper and what their role / access is?

Thanks

Dave

[Hendrik_VE]

I use this chart to show the most active users (save the report as "Chart: xxx"):

Select Top 1000000 htblusers.name,
Count(tblLoginLog.LogID) As logins
From tblLoginLog
Inner Join htblusers On tblLoginLog.UserName = Concat(htblusers.userdomain,
'\', htblusers.username)
Group By htblusers.name
Order By logins Desc

[PapaTuck]

I assume the login info in this report shows the number of logins for the web console? It would be nice to see the last login by user, their role and department. I'm not a SQL guy, so any help would be appreciated.

When I added a Date column, the number of users went from 200+ (several hundred too low) to over 74k (thousands too high).

[Mister_Nobody]

+ Read this topic

https://community.lansweeper.com/t5/reports-analytics/looking-to-create-a-report-to-list-all-the-das...

[Mister_Nobody]

Try built-in reports:

Users: Logins into the Lansweeper web console

Users: Changes made to Lansweeper configuration