→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
gli
Engaged Sweeper
How can i create a report to see the lastlogon to domain?
1 ACCEPTED SOLUTION
Nick_VDB
Champion Sweeper III
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





View solution in original post

1 REPLY 1
Nick_VDB
Champion Sweeper III
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