Find out which computers in your environment are still running a 32-bit Windows and could use an upgrade. This report will provide an overview of all 32-bit Windows computers in your environment along with basic information so you have a complete list of which machines could use an upgrade. Since 32-bit machines are limited performance wise, this could reduce the efficiency of anyone using the machine which is a great reason to update to a 64-bit Windows operating system along with additional updates.
32-bit Windows Computer Query
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tblAssets.Description,
tblComputersystem.Lastchanged,
tsysOS.Image As icon
From tblAssets
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where tblComputersystem.SystemType Like 'x86%' And tblAssetCustom.State = 1
Order By tblAssets.AssetName
