cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
cpreister14
Engaged Sweeper

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

1 REPLY 1
Hendrik_VE
Champion Sweeper III

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

New to Lansweeper?

Try Lansweeper For Free

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

Try Now