Find All 32-Bit Windows Devices in Your Network
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