OID Lookup: All scanned OIDs (Built-in)

[Esben_D]

The report below gives back a list of all scanned OIDs.

The report will only list OIDs when the following criteria are met:

• You have Lansweeper 7.0 or higher.
  
• There are custom OID scans configured.

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