SNMP Trap Details v7

Every SNMP trap send by PEM starts with oid .1.3.6.1.4.1.27645.5444, Significance of each identifier in oid is as follow’s.

IdentifierMeaning
1ISO, ISO is the group that established the OID standard
3org, Organization identification schemes registered according to ISO/IEC 6523-2
6dod, United States Department of Defense (DoD)
1internet, Communication will be via Internet/network
4private, This is a device manufactured by a private entity (not goverment)
1enterprise, The device manufacturer is classified as an enterprise
27645PostgreSQL global development group
5444pem

How OID's are formed?

PEM’s SNMP trap has following oid format 1.3.6.1.4.1.27645.5444.<alert_target_level_identifier>.<alert_identifier>

Following table lists down possible values for <alert_target_level_identifier>.

IdentifierAlert Target Level
1Agent
2Server
3Database
4Schema
5Table
6Index
7Sequence
8Function
9Global
<alert\_identifier> is unique identifier for each alert, which you can find in snmp\_oid column of pem.alert\_template table.

For example, snmp_oid for Agent Down alert template is 34, hence trapOID for agent down alert will be 1.3.6.1.4.1.27645.5444.1.34

How OID's for binding variables are formed?

Every binding variable oid has following format 1.3.6.1.4.1.27645.5444.10.<binding_variable_identifier>, where 10 is identifier for binding variable Following table lists down possible values for <binding_variable_identifier>

IdentifierVariable Name
1alertName
2agentID
3serverID
4agentName
5serverName
6databaseName
7schemaName
8objectName
9thresholdvalue
10previousValue
11value
12previousStatus
13status
14recordedTime
15downObjects
16detailedInformation

For example, 1.3.6.1.4.1.27645.5444.10.1 is oid for binding variable alertName.

Details of each snmp traps in pem.snmp_spool table. For example,

pem=# select * from  pem.snmp_spool;
-[ RECORD 1 ]----+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
id               | 1
trap_oid         | .1.3.6.1.4.1.27645.5444.1.34
enterprise_oid   | .1.3.6.1.4.1.27645.5444
trap_version     | 2
varbinding_oid   | .1.3.6.1.4.1.27645.5444.10.1|.1.3.6.1.4.1.27645.5444.10.2|.1.3.6.1.4.1.27645.5444.10.4|.1.3.6.1.4.1.27645.5444.10.9|.1.3.6.1.4.1.27645.5444.10.10|.1.3.6.1.4.1.27645.5444.10.11|.1.3.6.1.4.1.27645.5444.10.12|.1.3.6.1.4.1.27645.5444.10.13|.1.3.6.1.4.1.27645.5444.10.14
varbinding_value | Agent Down||Postgres Enterprise Manager Host|{0.1,0.2,0.3}|0|1|CLEAR|HIGH|2020-06-22 15:51:03.266437+10
sent_status      | s
recorded_time    | 22-JUN-20 15:51:03.266437 +10:00