
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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
- Labels:
-
Built-In Reports

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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
