12-15-2022 11:20 PM - edited 12-15-2022 11:21 PM
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
12-16-2022 10:00 AM
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
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now