Computers logged onto

[McClure77]

Lansweeper shows a list of the computers that a username has logged onto. However, it only shows the latest logon to a specific server, not each time this server was logged onto by the user. Is there a way to either configure this view to report each login, or to runa report showing that?

[Susan_A · Accepted solution]

Modifying the user page isn't possible, but you can indeed run a report to list the information instead. A full login history can be found in the tblcplogoninfo database table. I've included a sample report below that lists all logon events stored for a specific user. You'll need to insert your own username and domain into the query. Instructions for adding a report to your Lansweeper installation can be found here.

If you are interested in building or modifying reports, we do recommend:

• Reviewing some SQL tutorials, as the Lansweeper report builder is a standard SQL editor. If you know SQL, you know how to build Lansweeper reports as well. This seems like a good tutorial.
  
• Making use of our database dictionary, more information on which can be found here. The dictionary explains in great detail what each table and field stores.

Select Top 1000000 tblCPlogoninfo.Username,
  tblCPlogoninfo.Domain As Userdomain,
  tblCPlogoninfo.logontime,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.IPAddress,
  tblAssets.Description,
  tblOperatingsystem.Caption As OS,
  tblAssets.SP
From tblAssets
  Inner Join tblCPlogoninfo On tblAssets.AssetID = tblCPlogoninfo.AssetID
  Inner Join tblOperatingsystem
    On tblAssets.AssetID = tblOperatingsystem.AssetID
Where tblCPlogoninfo.Username = 'administrator' And tblCPlogoninfo.Domain = 'lansweeper'
Order By tblCPlogoninfo.logontime Desc