→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
PFDTOC
Engaged Sweeper
Is there a way to increase the user login history on the computers to be more than 50?
1 REPLY 1
Hemoco
Lansweeper Alumni
Note that more logons are stored in the database, but asset/user webpages only display the most recent ones. You can create a custom report to list more logons. A sample report can be seen below. It lists user logons that occurred in the last 7 days. Replace the number marked in bold to change the time frame.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblCPlogoninfo.Username,
tblCPlogoninfo.Domain As Userdomain,
tblCPlogoninfo.logontime,
tsysOS.Image As icon
From tblCPlogoninfo
Inner Join tblAssets On tblAssets.AssetID = tblCPlogoninfo.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblCPlogoninfo.logontime > GetDate() - 7
Order By tblAssets.Domain,
tblAssets.AssetName,
tblCPlogoninfo.logontime Desc