Historical computer log on info

[Ian_Prentice]

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

[Ian_Prentice]

Superb! that does the job.

Thank you!

[Niko0 · Accepted solution]

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