All scanned OIDs

List All Scanned OIDs

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

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

Run This Report in 3 Easy Steps

Download-Install-Lansweeper

1. Download & Install Lansweeper

Save-and-Run-the-Report

3. Run the Report

Download Lansweeper to Run this Report

Harness the Power of Reporting