Report for computers showing offline

[cpreister14]

Hi,

I'm needing a report that show me Windows 10 devices in offline state. I wasn't sure if anybody had something to share?

Thanks

[Hendrik_VE]

Can you be more clearly what you mean with 'offline state'?

In case you mean the Windows 10 devices that haven't reported to Lansweeper, than you could use this report (for devices that haven't reported in the last 60 days):

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tsysOS.OSname,
tblAssets.Description,
tblAssets.Lastseen As [Last Seen],
tsysOS.Image As icon
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tsysOS.OSname Like '%Win 10%' And tblAssets.Lastseen < GetDate() - 60 And
tblAssetCustom.State = 1
Order By [Last Seen] Desc,
tblAssets.AssetName