cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Simmarc
Engaged Sweeper
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!
3 REPLIES 3
Simmarc
Engaged Sweeper
That seems to work fine! Are we able to add a condition to only show ONLINE PC's?
Hemoco
Lansweeper Alumni
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
Lansweeper Alumni
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

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now