Windows: 64-bit processor but 32-bit OS installed (Built-in)

[Daniel_B]

Old name: Computer: 64 bit processor but 32 bit OS installed

The report below lists all windows based assets with 64-bit system architecture and 32-bit operating system

The report will only list assets that meet all of the following criteria:

• The asset state is set to "active".
  
• The asset has been successfully scanned at least once.
  
• The asset is a Windows computer.
  
• The asset has a 64-bit system architecture and a 32-bit OS installed

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
  tblAssets.IPAddress,
  tsysIPLocations.IPLocation,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tsysOS.OSname As OS,
  tblAssets.SP,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblComputersystem.SystemType
From tblAssets
  Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
  Inner Join (Select tblAssets.AssetID,
    Max(tblProcessor.Architecture) As Architecture
  From tblAssets
    Inner Join tblProcessor On tblAssets.AssetID = tblProcessor.AssetID
  Group By tblAssets.AssetID) As ProcCapacity On ProcCapacity.AssetID =
    tblAssets.AssetID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tsysIPLocations On tsysIPLocations.LocationID =
    tblAssets.LocationID
  Inner Join tblState On tblState.State = tblAssetCustom.State
  Left Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblComputersystem.SystemType Like 'X86%' And ProcCapacity.Architecture = 9
  And tblState.Statename = 'Active'
Order By tblAssets.Domain,
  tblAssets.AssetName