→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Jorge_Piris
Engaged Sweeper
Hello , first sorry for my english, is very limit 😛

I have switchs dell N2024 , and the problems is after scan asset, i need exclude the port information .
It this possible?
Error
1 REPLY 1
Esben_D
Lansweeper Employee
Lansweeper Employee
I would take a look at the report in this topic: https://www.lansweeper.com/forum/yaf_postst9860_All-switches-and-the-assets-connected-to-them.aspx#post38286

I added some criteria to the report from that post so you can enter the name of the switch and the port names you want to see. You can replace MySwitch below with the name of your switch and the highlighted numbers with the port range you want to see.

Select Distinct Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename As AssetType,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblSNMPInfo.IfIndex As Interface,
tblSNMPInfo.IfDescription As Name,
tblSNMPIfTypes.IfTypename As Type,
tblSNMPInfo.IfAdminstatus As Admin,
tblSNMPInfo.IfMTU As MTU,
Ceiling(tblSNMPInfo.IfSpeed / 1000 / 1000) As Speed,
tblSNMPInfo.IfIPAddress As IP,
tblSNMPInfo.IfMask As Mask,
tblSNMPInfo.IfMacaddress As MAC,
tblAssets1.AssetName As Asset
From tblAssets
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblSNMPInfo On tblAssets.AssetID = tblSNMPInfo.AssetID
Inner Join tblSNMPIfTypes On tblSNMPIfTypes.IfType = tblSNMPInfo.IfType
Left Join tblSNMPAssetMac On tblSNMPAssetMac.AssetID = tblSNMPInfo.AssetID And
tblSNMPAssetMac.IfIndex = tblSNMPInfo.IfIndex
Left Join tblAssetMacAddress On tblAssetMacAddress.Mac =
tblSNMPAssetMac.AssetMacAddress
Left Join tblAssets tblAssets1 On tblAssets1.AssetID =
tblAssetMacAddress.AssetID
Where tblAssets.AssetName = 'MySwitch' And tsysAssetTypes.AssetTypename =
'switch' And tblSNMPInfo.IfIndex Between 0 And 649
Order By tblAssets.AssetName,
Interface