Table to specify 32 bit or 64 bit OS

[gdavis]

I to add a field in the OS version report to specify 32 bit or 64 bit versions. I am having trouble finding the table to include in the report. I know the field exists because lansweeper specifies this information on the top of the computer main page. Has anyone found this field? Thanks for the help.

[Hemoco · Accepted solution]

This information is stored in the SystemType field of tblComputersystem. A sample report can be seen below.

Select Top 1000000 Web40OSName.Compimage As icon, tblComputers.Computername, tblComputers.Computer, tblComputers.Domain, Web40OSName.OSname As OS, Web40OSName.SP, tblComputers.LastknownIP As IP, tblComputersystem.SystemType As Architecture, tblComputers.Lastseen From tblComputers Inner Join Web40OSName On Web40OSName.Computername = tblComputers.Computername Left Join tblComputersystem On tblComputers.Computername = tblComputersystem.Computername Where tblComputers.Lastseen <> '' 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.