Last logon report

[Simmarc]

Good afternoon everyone,

I was wondering if there's a way to create a report where I would find computers that have not had any login activity for 30-60-90 days. This, we can pinpoint computers that could probably be picked up and used somewhere else. We just don't want computers sleeping on desks.

Thank you for your time!

[Simmarc]

That seems to work fine! Are we able to add a condition to only show ONLINE PC's?

[Hemoco]

Simmarc wrote:
Are we able to add a condition to only show ONLINE PC's?

No, as Lansweeper does not continuously ping machines to see if they're online and does not store an asset's ping status in the database. What you can do is run the report, hit the Ping Assets button and sort the ping column so that pingable machines are on top.

[Hemoco]

Run the report below and replace 30 with any time frame you would like to report on.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
Max(tblCPlogoninfo.logontime) As LastLogon
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblCPlogoninfo On tblAssets.AssetID = tblCPlogoninfo.AssetID
Where tblAssetCustom.State = 1
Group By tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried
Having Max(tblCPlogoninfo.logontime) < GetDate() - 30