→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here
‎02-28-2013 07:10 PM
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
Solved! Go to Solution.
‎03-13-2013 03:05 PM
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
‎03-13-2013 03:08 PM
‎03-13-2013 03:05 PM
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
‎03-01-2013 11:26 AM
‎03-11-2013 05:58 PM
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
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now