Convert v4 report to v5

[harringg]

Requesting assistance converting this v4 report to v5 "compliant".

I can then use this example, with the resutling v5 report and clean up the rest of my older reports.

Select Top 1000000 upgrade_tblcomputers.Computername,
  upgrade_tblcomputers.ComputerUnique,
  upgrade_web40osname.Compimage As icon,
  upgrade_web40osname.OSname,
  upgrade_tblcomputers.SP As [Service Pack],
  upgrade_tblcompcustom.Location,
  upgrade_tblcompcustom.Department As [Research Unit],
  upgrade_tblcompcustom.Custom1 As [User Name],
  TsysChassisTypes.ChassisName As Type,
  upgrade_tblcompcustom.BarCode As [Inventory Number],
  upgrade_tblbios.ReleaseDate,
  upgrade_tblsystemenclosure.SerialNumber
From upgrade_tblcomputers
  Left Outer Join upgrade_web40processorcapacity
    On upgrade_tblcomputers.Computername =
    upgrade_web40processorcapacity.Computername
  Inner 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_tblbios On upgrade_tblcomputers.Computername =
    upgrade_tblbios.Computername
  Left Join upgrade_tblsystemenclosure On upgrade_tblcomputers.Computername =
    upgrade_tblsystemenclosure.Computername
  Left Join TsysChassisTypes On TsysChassisTypes.Chassistype =
    upgrade_tblsystemenclosure.ChassisTypes
Where upgrade_tblcompcustom.Location Like '%BLD01%'
Order By upgrade_tblcomputers.Computername

[harringg]

Thank you. I'll now use that as a general template to study what is different between the two and migrate my "upgraded" reports to the new v5 format.

Thanks again!

[Hemoco · Accepted solution]

Please try the report below.

Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename As Type,
tblAssetCustom.Model,
tblAssetCustom.Manufacturer,
tblAssetCustom.Location,
tblAssetCustom.PurchaseDate,
tblAssetCustom.Serialnumber,
tblAssetCustom.Contact,
tblAssetMacAddress.Mac,
tblAssets.IPAddress,
tblAssetCustom.Custom11,
tblAssetCustom.Custom12,
tblAssetCustom.Custom13
From tblAssets
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Left Join tblAssetMacAddress On tblAssets.AssetID = tblAssetMacAddress.AssetID
Where tsysAssetTypes.AssetType = 217
Order By tblAssetCustom.Location,
tblAssets.AssetName

[Hemoco]

The report you posted is already a version 5.0 report. The "upgrade_" tables are specifically used to convert 4.2 reports to 5.0.

[harringg]

Lansweeper wrote:
The report you posted is already a version 5.0 report. The "upgrade_" tables are specifically used to convert 4.2 reports to 5.0.

Select Top 1000000 upgrade_tsysDevicetypes.itemtypeicon10 As icon,
  upgrade_tblCustDevices.Displayname As [Device name],
  upgrade_tblCustDevices.Model,
  upgrade_tblCustDevices.Vendor,
  upgrade_tblCustDevices.Location,
  upgrade_tblCustDevices.DeviceKey,
  upgrade_tblCustDevices.PurchaseDate,
  upgrade_tblCustDevices.Serialnumber,
  upgrade_tblCustDevices.Contact,
  upgrade_tblCustDevices.Devicetype,
  upgrade_tblCustDevices.Mac,
  upgrade_tblCustDevices.IPAddress
From upgrade_tblCustDevices
  Inner Join upgrade_tsysDevicetypes On upgrade_tsysDevicetypes.itemtype =
    upgrade_tblCustDevices.Devicetype
Where upgrade_tblCustDevices.Devicetype = '217'
Order By upgrade_tblCustDevices.Location

I've seen several recent posts about this same topic.

My question is I want to produce this report, but using tblAssestCustom.Custom11 (12 and 13) and I don't see a way to link the upgrade_tblCustDevices to the tblAssetCustom to include those columns.