Report lastlogon

[gli]

How can i create a report to see the lastlogon to domain?

[Nick_VDB · Accepted solution]

The report below uses the 'tblCPlogoninfo'. This table stores the user logon events that occurred on your Windows computers. Whenever Lansweeper scans a Windows computer, it detects the currently logged on user and creates a logon event for this user. The logontime value reflects when Lansweeper scanned the computer and detected the user; it does not necessarily reflect when the user actually logged into the computer. Users that do not log into a computer during a computer scan are not detected. To capture all logon events and to have the logontime value reflect when the user actually logged into the computer, deploy the LsPush scanning agent in a logon script/group policy.

Instructions for adding the report below to your Lansweeper installation can be found here.

Select Top 1000000 tblCPlogoninfo.Domain,
  tblCPlogoninfo.Username,
  Max(tblCPlogoninfo.logontime) As [Logon Date\Time],
  tblAssets.AssetName
From tblCPlogoninfo
  Inner Join tblAssets On tblAssets.AssetID = tblCPlogoninfo.AssetID
Group By tblCPlogoninfo.Domain,
  tblCPlogoninfo.Username,
  tblAssets.AssetName
Order By tblCPlogoninfo.Domain,
  [Logon Date\Time],
  tblAssets.AssetName