→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Ian_Prentice
Champion Sweeper
Hi Folks,

Needing some help.

If I select a PC from my asset list, then select "config / user info /last logon" I can see the last 40 entries of the previous logged on users.

Is there anyway to get a report that will go back further than 40 entries? ideally I would like 1 month's worth of historical data.

Thanks!
Ian
1 ACCEPTED SOLUTION
Niko0
Engaged Sweeper III
That list only shows the most recent ones.

To get all the logins in the past month you will have to use a custom report.

This report lists all logins during the past 31 days:

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

View solution in original post

2 REPLIES 2
Ian_Prentice
Champion Sweeper
Superb! that does the job.

Thank you!
Niko0
Engaged Sweeper III
That list only shows the most recent ones.

To get all the logins in the past month you will have to use a custom report.

This report lists all logins during the past 31 days:

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