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
