Processor Details

[Srikanth08]

Hi,

Is there any query to find whether the computer is 32 bit or 64 bit? i want to know the

details of System is 32 bit or 64 bit with details like system name, user name , processor details, model and serial no

[Hemoco]

Please use the report below for the information you are after.

Select tblComputers.Computername, tblComputers.Computer, tblComputers.Domain,
Case tblComputersystem.SystemType When 'x86-based PC' Then '32-bit'
When 'x64-based PC' Then '64-bit'
End As [System Type], tblComputers.Userdomain, tblComputers.Username,
web40ProcessorCapacity.NrOfProcessors, web40ProcessorCapacity.CPU,
tblComputersystem.Model, tblComputerSystemProduct.IdentifyingNumber
From tblComputers Inner Join
tblComputersystem On tblComputers.Computername =
tblComputersystem.Computername Inner Join
tblComputerSystemProduct On tblComputers.Computername =
tblComputerSystemProduct.Computername Inner Join
web40ProcessorCapacity On web40ProcessorCapacity.Computername =
tblComputers.Computername
Order By tblComputers.ComputerUnique

To use the specified report, do the following:
• Open the Lansweeper configuration console and select Reports & Alerts\Report Builder. Hit the “New” button.
• Copy the SQL code provided and paste it at the bottom of the newly created report, replacing the default SQL code.
• Click somewhere near tblComputers so the new code applies.
• Give the report a “View name” and a “Report name” and hit the “Save” button.
• Double-click on the report in the report list to see its results and export options.