Trying to add a field to a report.

[Technut27]

I want to add the switch that computers are plugged into to a report but haven't found what table that value is stored on yet. Does anyone know where that is? On a computer asset page its in the Network wake on lan section under Connection, "Name WOL IP Address Mask Gateway Mac Address Connection". It gives you a link to the switch's asset page and the port number. I would be happy if I can just add the name of the switch to my custom report, the port number would be an extra bonus.

This is what the report looks like now. I'm getting the info I'm looking for except for the switch that the computers are plugged into.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblADComputers.OU,
tblAssets.Username,
tblAssets.Userdomain,
tblADComputers.Description,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tsysAssetTypes.AssetType
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID
Where (tblADComputers.OU Like '%CTO%' And tblADComputers.OU Like '%Westlake%')
And tblADComputers.Description Not Like '%WinWire%' And tblAssetCustom.State =
1
Order By tblADComputers.Description

[Hemoco · Accepted solution]

Sample report:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As Icon,
tblSNMPAssetMac.AssetMacAddress,
tblAssets_1.AssetName As Switch,
tblSNMPInfo.IfIndex As Port
From tsysAssetTypes
Inner Join tblAssets On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblAssetMacAddress
On tblAssets.AssetID = tblAssetMacAddress.AssetID
Inner Join tblSNMPAssetMac On tblAssetMacAddress.Mac =
tblSNMPAssetMac.AssetMacAddress
Inner Join tblSNMPInfo On tblSNMPAssetMac.IfIndex = tblSNMPInfo.IfIndex And
tblSNMPAssetMac.AssetID = tblSNMPInfo.AssetID
Inner Join tblAssets tblAssets_1 On tblSNMPInfo.AssetID = tblAssets_1.AssetID
Order By tblAssets.AssetName