DiscoveredDeviceSNMPInfo Table

Records any SNMP information discovered for a DiscoveredDevice.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.
Table 1. Database columns for DiscoveredDeviceSNMPInfo table

Database Column

Details

DeviceID

Type: integer. Key

Device identity number.

SNMP_snmpCommunityString

Type: text (max 256 characters). Nullable

The SNMP Community String that was used for obtaining SNMP MIBs. This and all following SNMP attributes are defined in RFC1907 and others available from the IETF websites.

SNMP_sysDescr

Type: text (max 256 characters). Nullable

A textual description of the device. This value should include the full name and version identification of the system’s hardware type, software operating-system, and networking software.

SNMP_sysObjectID

Type: text (max 256 characters). Nullable

The vendor’s authoritative identification of the network management subsystem contained in the entity. This value is allocated within the SMI enterprises subtree (1.3.6.1.4.1) and provides an easy and unambiguous means for determining ‘what kind of device’ is being managed. For example, if vendor ‘Flintstones, Inc.’ was assigned the subtree 1.3.6.1.4.1.4242, it could assign the identifier 1.3.6.1.4.1.4242.1.1 to its ‘Fred Router’.

SNMP_sysObjectIDSymbolic

Type: text (max 256 characters). Nullable

The symbolic representation of the same value as sysObjectID.

SNMP_sysUpTime

Type: big integer. Nullable

The time (in hundredths of a second) since the network management portion of the system was last re-initialized.

SNMP_sysContact

Type: text (max 256 characters). Nullable

The textual identification of the contact person for this managed node, together with information on how to contact this person.

SNMP_sysName

Type: text (max 256 characters). Nullable

An administratively-assigned name for this managed node. By convention, this is the node’s fully-qualified domain name.

SNMP_sysLocation

Type: text (max 256 characters). Nullable

The physical location of this node (for example, ‘telephone closet, 3rd floor’).

SNMP_sysServices

Type: integer. Nullable

A bitmask indicating at which of the seven OSI protocol levels the system provides services (physical=1, TCP = 8, applications = 64, etc).

SNMP_ipForwarding

Type: integer. Nullable

Set to 1 if the device forwards IP packets, 2 otherwise.