→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
studerje
Engaged Sweeper II
Here's what I have so far. This report shows me the details I need about the device.
Now I'd like to add the switch and port number on the switch to the device. We already have LanSweeper collecting SNMP info from the switches.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Firstseen,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssetCustom.Model = 'CP-7911G' And tblAssetCustom.State = 1
1 ACCEPTED SOLUTION
Susan_A
Lansweeper Alumni
There's a sample report in our Report Center for this. You can find it here.

View solution in original post

1 REPLY 1
Susan_A
Lansweeper Alumni
There's a sample report in our Report Center for this. You can find it here.