Discover all of the scanned custom OIDs from your network in one overview. This overview will provide a list of all the custom OIDs that have been scanned in your environment per asset. This also includes the data that was retrieved from the custom OIDs. By default, Lanswepeer will already retrieve a lot of information from network devices using SNMP. Custom OID scanning allows users to scan additional specific information from devices.
All scanned OIDs Query
Select Top 1000000 tblAssets.AssetID,
tsysAssetTypes.AssetTypeIcon10 As Icon,
tblAssets.AssetName,
tblOIDData.Label As [OID Label],
tblOIDData.[Key] As OID,
tblOIDData.Data As [OID Data],
tblAssets.Domain,
tblAssets.IPAddress,
tblAssets.Description,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.Location,
tsysIPLocations.IPLocation,
tblAssets.Firstseen,
tblAssets.Lastseen
From tblAssets
Inner Join tblOIDData On tblAssets.AssetID = tblOIDData.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Left Outer Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Left Outer Join tsysOS On tsysOS.OScode = tblAssets.OScode
Left Join tsysIPLocations On tsysIPLocations.StartIP <= tblAssets.IPNumeric
And tsysIPLocations.EndIP >= tblAssets.IPNumeric
