All Active Assets Report - Only for Windows 10/11

[nitsanreznik]

Hi Chaps,

I need help on creating a report which will show all active assets report but, that capable to show me only Windows 10 and Windows 11. The built-in All Active assets only shows Type of asset which is Windows and nothing else.

I hope that makes sense.

Nitsan

[rader]

Here's a really basic starting point for you.

Win 10/11

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
  tblAssets.IPAddress,
  tblAssets.Version,
  tsysOS.OSname
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblState On tblState.State = tblAssetCustom.State
  Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where (tsysOS.OSname Like 'Win 10' Or tsysOS.OSname Like 'Win 11')
Order By tblAssets.AssetName