‎09-25-2018 10:16 AM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tsysOS.OSname,
tblOperatingsystem.Lastchanged,
tsysOS.Image As icon,
tblOperatingsystem.Version As Build,
Version = Case tblOperatingsystem.Version
When '10.0.10240' Then '1507'
When '10.0.10586' Then '1511'
When '10.0.14393' Then '1607'
When '10.0.15063' Then '1703'
When '10.0.16299' Then '1709'
When '10.0.17134' Then '1803'
Else '?'
End,
backgroundcolor = Case tblOperatingsystem.Version
When '10.0.10240' Then '#f7f0ca'
When '10.0.10586' Then '#f7f0ca'
When '10.0.14393' Then '#f7f0ca'
When '10.0.15063' Then '#f7f0ca'
When '10.0.16299' Then '#f7f0ca'
When '10.0.17134' Then '#d4f4be'
Else Case tsysOS.OSname
When 'NT 3.51' Then '#e29c9c'
When 'NT 4' Then '#e29c9c'
When 'Win XP' Then '#e29c9c'
Else '#f7caca'
End
End
From tblAssets
Inner Join tblOperatingsystem On
tblAssets.AssetID = tblOperatingsystem.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tsysOS.OSname Not Like 'Win 20%' And tblAssetCustom.State = 1
Order By Build,
tblAssets.AssetUnique
‎06-27-2019 05:08 PM
‎06-27-2019 02:15 AM
‎06-26-2019 04:29 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tsysOS.OSname,
tblOperatingsystem.Lastchanged,
tsysOS.Image As icon,
tblOperatingsystem.Version As Build,
Version = Case tblOperatingsystem.Version
When '10.0.10240' Then '1507'
When '10.0.10586' Then '1511'
When '10.0.14393' Then '1607'
When '10.0.15063' Then '1703'
When '10.0.16299' Then '1709'
When '10.0.17134' Then '1803'
When '10.0.17763' Then '1809'
When '10.0.18362' Then '1903'
Else '?'
End,
backgroundcolor = Case tblOperatingsystem.Version
When '10.0.10240' Then '#f7f0ca'
When '10.0.10586' Then '#f7f0ca'
When '10.0.14393' Then '#f7f0ca'
When '10.0.15063' Then '#f7f0ca'
When '10.0.16299' Then '#f7f0ca'
When '10.0.17134' Then '#f7f0ca'
When '10.0.17763' Then '#d4f4be'
When '10.0.18362' Then '#d4f4be'
Else Case tsysOS.OSname
When 'NT 3.51' Then '#e29c9c'
When 'NT 4' Then '#e29c9c'
When 'Win XP' Then '#e29c9c'
Else '#f7caca'
End
End
From tblAssets
Inner Join tblOperatingsystem On
tblAssets.AssetID = tblOperatingsystem.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tsysOS.OSname Not Like 'Win 20%' And tblAssetCustom.State = 1
Order By Build,
tblAssets.AssetUnique
‎10-03-2018 01:56 PM
Case tblOperatingsystem.Version
When '10.0.10240' Then '1507'
When '10.0.10586' Then '1511'
When '10.0.14393' Then '1607'
When '10.0.15063' Then '1703'
When '10.0.16299' Then '1709'
When '10.0.17134' Then '1803'
Else '?'
End As Version
‎10-03-2018 01:42 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now