Find All 64-Bit Windows Machines in Your Network
Find out which computers in your environment are running a 64-bit Windows operating system and won't require an OS update. This report will provide an overview of all 64-bit Windows computers in your environment along with basic information so you have a complete list of which machines are in order. Since 32-bit machines are limited performance wise, having a list of 64-bit computers can be useful to continue an upgrade path for older machines. This list can be used as a source for further hardware upgrades.
64-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 tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode Where tblComputersystem.SystemType Like 'x64%' And tblAssetCustom.State = 1 Order By tblAssets.AssetName