Report trouble - Master list

[crichie]

I used to run the following report on a different server. I have since then reloaded Lansweeper on a different server from scratch. I copied the report below, but It isn't working. It isn't recognizing the Upgrade_ txt.

Select Top 1000000 upgrade_tblcomputers.Computername,
upgrade_tblcomputers.ComputerUnique,
upgrade_web40osname.Compimage As icon,
upgrade_tblcomputers.Domain,
upgrade_tblcomputers.Description,
upgrade_tblcomputers.Username,
upgrade_tblcomputers.Userdomain,
upgrade_tblComputerSystemProduct.Name As Model,
upgrade_tblComputerSystemProduct.Vendor As Manufacturer,
upgrade_tblComputerSystemProduct.IdentifyingNumber As Serial,
upgrade_tblcomputers.LastknownIP As [IP Address],
upgrade_tblcomputers.Lastseen,
upgrade_web40osname.OSname,
upgrade_web40osname.SP,
upgrade_web40processorcapacity.MaxClockSpeed,
upgrade_web40processorcapacity.NrOfProcessors,
upgrade_web40processorcapacity.CPU,
upgrade_web40correctmemory.Memory,
upgrade_tblerrors.CFGname,
upgrade_tblerrors.ErrorText,
upgrade_tblerrors.Lastchanged
From upgrade_tblcomputers
Left Join upgrade_tbldiskdrives On upgrade_tblcomputers.Computername =
upgrade_tbldiskdrives.Computername
Left Outer Join upgrade_web40processorcapacity
On upgrade_tblcomputers.Computername =
upgrade_web40processorcapacity.Computername
Left Join upgrade_web40activecomputers On upgrade_tblcomputers.Computername =
upgrade_web40activecomputers.Computername
Left Join upgrade_web40correctmemory
On upgrade_web40correctmemory.Computername =
upgrade_tblcomputers.Computername
Left Join upgrade_web40osname On upgrade_web40osname.Computername =
upgrade_tblcomputers.Computername
Left Join upgrade_tblComputerSystemProduct
On upgrade_tblcomputers.Computername =
upgrade_tblComputerSystemProduct.Computername
Left Join upgrade_tblcompcustom On upgrade_tblcomputers.Computername =
upgrade_tblcompcustom.Computername
Left Join upgrade_tblvideocontroller On upgrade_tblcomputers.Computername =
upgrade_tblvideocontroller.Computername
Left Join upgrade_tblerrors On upgrade_tblcomputers.Computername =
upgrade_tblerrors.Computername
Where upgrade_tblComputerSystemProduct.Name <> 'VMware Virtual Platform' And
upgrade_tblvideocontroller.DeviceID = 'VideoController1' And
upgrade_tbldiskdrives.Caption = 'c:'
Order By upgrade_tblcomputers.Computername

[Hemoco · Accepted solution]

Database objects starting with "upgrade_" are only available in version 4.x upgraded SQL server installations.

You will need to use the new tables to create your report.