Assets: Unique SNMP OID (Built-in)

[Daniel_B]

Old name: Device: Unique SNMP OID (Built-in)

The report below lists the SNMP OIDs detected in the network, number of devices having one SNMP OID

The report will only list assets that meet all of the following criteria:

• The asset state is set to "active".
  
• The asset has been successfully scanned at least once.
  
• The SNMP protocol on the asset is enabled

Select Top 1000000 tblAssetCustom.SnmpOID,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tsysAssetTypes.AssetTypename,
  tblAssetCustom.Model,
  tblAssetCustom.Manufacturer,
  Count(tblAssets.AssetID) As Total
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
Where tblAssetCustom.State = 1
Group By tblAssetCustom.SnmpOID,
  tsysAssetTypes.AssetTypeIcon10,
  tsysAssetTypes.AssetTypename,
  tblAssetCustom.Model,
  tblAssetCustom.Manufacturer
Having tblAssetCustom.SnmpOID <> ''
Order By tblAssetCustom.SnmpOID