
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-23-2016 04:44 PM
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
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
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-24-2016 08:01 AM
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:
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
2 REPLIES 2

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-25-2016 12:01 PM
Superb! that does the job.
Thank you!
Thank you!

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-24-2016 08:01 AM
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:
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
