New to Lansweeper! Need report on OS x32 or x64

[lfarmer]

Hello All!

I'm new to Lansweeper, and my manager has asked for a report on what computers have Windows 32 bit and which are 64 bit. I've played with the report builder, but can't seem to find what I'm looking for. Thanks in advance for the support!

Lonnie

[Hemoco · Accepted solution]

A sample report can be seen below.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
Case tblComputersystem.SystemType When 'X86-based PC' Then '32-bit'
When 'X64-based PC' Then '64-bit' End As Architecture
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Where tblAssetCustom.State = 1