I would like to show the switch name, unit number and port number on the below report. Any help would be greatly appreciated.
Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetName,
tblAssetCustom.Model As [Device model],
tblAssetCustom.Serialnumber,
tblAssetCustom.DNSName,
tblAssetCustom.Building,
tblAssetCustom.Location,
tblAssetCustom.Custom3,
tblAssetCustom.Department,
tblAssetCustom.Manufacturer,
tblAssets.Mac,
tblAssets.IPAddress,
tblAssetGroups.AssetGroup
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
Inner Join tblAssetGroupLink On tblAssets.AssetID = tblAssetGroupLink.AssetID
Inner Join tblAssetGroups On tblAssetGroups.AssetGroupID =
tblAssetGroupLink.AssetGroupID
Where tblAssetGroups.AssetGroup = 'SmartPrint Printers' And
tblAssetCustom.Printedpages Is Not Null And tblAssetCustom.State = 1
Order By tblAssetCustom.Building,
tblAssetCustom.Location,
tblAssetCustom.Custom3,
tblAssets.AssetName
