→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
harringg
Champion Sweeper
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
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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

View solution in original post

4 REPLIES 4
harringg
Champion Sweeper
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
Lansweeper Alumni
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
Lansweeper Alumni
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
Champion Sweeper
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.