cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

OID Lookup: All scanned OIDs (Built-in)

Esben_D
Lansweeper Employee
Lansweeper Employee
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
0 REPLIES 0