I have the following report and we are just doing a stagged roll out to staff as we are mostly laptops in remote sites via 4G connections.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Version,
tblAssets.Domain,
tblAssetCustom.Location,
tsysIPLocations.IPLocation,
tblAssets.IPAddress,
tsysAssetTypes.AssetTypename As Type,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssets.Lastseen,
tsysAssetTypes.AssetTypeIcon10 As icon,
Case
When tblAssets.Version Like '1903%' Then '#d4f4be'
Else '#ffadad'
End As backgroundcolor
From tblAssets
Left Outer Join tsysIPLocations On tblAssets.IPNumeric >=
tsysIPLocations.StartIP And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Left Outer Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblAssets.IPAddress Is Not Null And tblAssets.IPAddress != '' And
tsysAssetTypes.AssetTypename = 'Windows' And tblAssetCustom.State = 1
Order By tblAssets.Version,
tblAssets.IPNumeric