Need help with simple Report

[greasyspoon42]

I know this may be simple but I can't see how to do it. I have never really worked with Databases.
All I want is report that lists: Computer Name, IP Address,Mac Address, Switch and switch port.

I know this data is in there because when I click on a computer asset like my computer at the bottom of info the is a Network section and info looks like
Name IP Address Mask Gateway Mac Address Connection
Intel(R) Ethernet Connection I217-LM 10.10.2.39 , fe80::ada2:dacb:b996:43b1 255.255.255.0 , 64 10.10.2.1 34:17:EB:C1:EA:58 JBR-BENCH-SW1.optusinc.com <-> 19 | FastEthernet0/23 (Fa0/23)

I just want this list but with the computer name in the front.
So basicly the report would look like
Name IP MAC address Swith Switch Port
Workbench 10.10.2.39 34:17:EB:C1:EA:58 JBR-BENCH-SW1.optusinc.com <-> 19 | FastEthernet0/23 (Fa0/23)
We are using Lansweeper 5.3.0.34
Thanks for any help you can offer.

[Susan_A · Accepted solution]

I've included a sample report below, which you can add to your Lansweeper installation by following these instructions.

Select Distinct Top 1000000 tsysOS.Image As icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblNetwork.IPAddress,
  tblNetwork.MACaddress,
  tblAssets1.AssetName As Switch,
  tblSNMPInfo.IfIndex As Port,
  tblSNMPInfo.ifName As PortName,
  tblSNMPInfo.IfDescription As PortDescription
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tblNetwork On tblAssets.AssetID = tblNetwork.AssetID
  Left Join tblAssetMacAddress On tblAssets.AssetID = tblAssetMacAddress.AssetID
  Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
  Left Join tblSNMPAssetMac On tblSNMPAssetMac.AssetMacAddress =
    tblAssetMacAddress.Mac
  Left Join tblAssets tblAssets1 On tblAssets1.AssetID = tblSNMPAssetMac.AssetID
  Left Join tblSNMPInfo On tblSNMPInfo.AssetID = tblSNMPAssetMac.AssetID And
    tblSNMPInfo.IfIndex = tblSNMPAssetMac.IfIndex
Where tblAssetCustom.State = 1 And tblNetwork.IPEnabled = 1
Order By tblAssets.Domain,
  tblAssets.AssetName

[willrun4fun]

Susan.A wrote:
I've included a sample report below, which you can add to your Lansweeper installation by following these instructions.

Select Distinct Top 1000000 tsysOS.Image As icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblNetwork.IPAddress,
  tblNetwork.MACaddress,
  tblAssets1.AssetName As Switch,
  tblSNMPInfo.IfIndex As Port,
  tblSNMPInfo.ifName As PortName,
  tblSNMPInfo.IfDescription As PortDescription
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tblNetwork On tblAssets.AssetID = tblNetwork.AssetID
  Left Join tblAssetMacAddress On tblAssets.AssetID = tblAssetMacAddress.AssetID
  Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
  Left Join tblSNMPAssetMac On tblSNMPAssetMac.AssetMacAddress =
    tblAssetMacAddress.Mac
  Left Join tblAssets tblAssets1 On tblAssets1.AssetID = tblSNMPAssetMac.AssetID
  Left Join tblSNMPInfo On tblSNMPInfo.AssetID = tblSNMPAssetMac.AssetID And
    tblSNMPInfo.IfIndex = tblSNMPAssetMac.IfIndex
Where tblAssetCustom.State = 1 And tblNetwork.IPEnabled = 1
Order By tblAssets.Domain,
  tblAssets.AssetName

This report if very similar to what I am trying to accomplish, except I do not want computers but my IP Phones. How would I modify this to pull Asset Type VOIP Phone?