Custom Report Help

[Hertel]

Hello,

I would like to create a custom report that shows the following

Computer
IP Location
Usernames
User Logon Time

I created a report using the web40lastlogontop1 view but it seems not all of the users are in the report?

If I go to a machine in the LANSweeper web console, click Config > User Info > Last Logon. There are more users in the list? Is there another view/table somewhere?

I also need to add the IP Location but I think this is just the web40AllIPLocations view?

Thanks

[Hertel]

Works well, thank you 🙂

[Hemoco]

Please try the following query:

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, web40AllIPLocations.IPLocation, tblCPlogoninfo.logontime,
tblCPlogoninfo.Username
From tblComputers Inner Join
tblCPlogoninfo On tblComputers.Computername = tblCPlogoninfo.Computername
Left Join
web40AllIPLocations On web40AllIPLocations.Computername =
tblComputers.Computername
Order By tblComputers.ComputerUnique, tblCPlogoninfo.logontime Desc