→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
an28
Engaged Sweeper
hi,
in the user details in lansweeper there is an area where the computers are listed which i logged onto ("Computers logged onto") at the bottom. Can anyone tell me where this information is in the database (which table)? I found the "last user" from the computer details but I can't find the information I really need.

Regards,
An28
2 REPLIES 2
an28
Engaged Sweeper
Thank you very much! That really helps a lot.
Hemoco
Lansweeper Alumni
This information is stored in tblCPlogoninfo within the Lansweeper report builder. An example report can be seen below.

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblCPlogoninfo.logontime, tblCPlogoninfo.Domain
As Domain1, tblCPlogoninfo.Username, tblCPlogoninfo.ADsite,
tblCPlogoninfo.Ipaddress
From tblComputers Inner Join
tblCPlogoninfo On tblComputers.Computername = tblCPlogoninfo.Computername
Order By tblComputers.ComputerUnique, tblCPlogoninfo.logontime Desc


To use the specified report, do the following:
• Open the Lansweeper configuration console and select Reports & Alerts\Report Builder. Hit the “New” button.
• Copy the SQL code provided and paste it at the bottom of the newly created report, replacing the default SQL code.
• Click somewhere near tblComputers so the new code applies.
• Give the report a “View name” and a “Report name” and hit the “Save” button.
• Double-click on the report in the report list to see its results and export options.