cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
timoV
Engaged Sweeper

Hi there,

we used a different tool that was able to search for a specific device (eg. by name or by serial number) to see who was logged in last.

i did not find such an option in Lansweeper yet.

Here in the forums i found out that Lansweeper only collects the logged in user when the user is logged in during a scan - this can be fixed by forcing the pc to report to the LS-server on login via lspush.exe (https://community.lansweeper.com/t5/general-discussions/current-logged-in-user/td-p/57299)

still i struggle to figure out how to get these user names in a report. 

could someone please give me a hint on that?

 

 

 

1 ACCEPTED SOLUTION
Josha
Engaged Sweeper II

If you search for an asset you can click on Config > User Info > Last Logon which will list recent users who were logged in when Lansweeper scanned the Windows asset.  It doesn't show the full history though. 

You would need to create your own custom reporting to access the tblCPlogoninfo table for that like the below.   I get 40 rows in the GUI but the SQL report gives me 1158 rows for my asset.  

 

SELECT 
lgi.LogonTime, 
lgi.UserName, 
lgi.IPAddress, 
asset.AssetName, 
cus.Model, 
cus.SerialNumber
FROM tblCPlogoninfo lgi
LEFT JOIN tblAssets asset on lgi.assetid = asset.assetid
LEFT JOIN tblAssetCustom cus on lgi.AssetID = cus.AssetID
WHERE asset.AssetName = 'ComputerName'
ORDER BY LogonTime Desc

 

View solution in original post

2 REPLIES 2
Josha
Engaged Sweeper II

If you search for an asset you can click on Config > User Info > Last Logon which will list recent users who were logged in when Lansweeper scanned the Windows asset.  It doesn't show the full history though. 

You would need to create your own custom reporting to access the tblCPlogoninfo table for that like the below.   I get 40 rows in the GUI but the SQL report gives me 1158 rows for my asset.  

 

SELECT 
lgi.LogonTime, 
lgi.UserName, 
lgi.IPAddress, 
asset.AssetName, 
cus.Model, 
cus.SerialNumber
FROM tblCPlogoninfo lgi
LEFT JOIN tblAssets asset on lgi.assetid = asset.assetid
LEFT JOIN tblAssetCustom cus on lgi.AssetID = cus.AssetID
WHERE asset.AssetName = 'ComputerName'
ORDER BY LogonTime Desc

 

timoV
Engaged Sweeper

thank you very much!



you pointed me to the right direction 🙂

thats why i initially wrote "i did not find such an option in Lansweeper yet." 😉