SNMP Trap Details v8
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.
| Identifier | Meaning |
|---|---|
| 1 | ISO, ISO is the group that established the OID standard |
| 3 | org, Organization identification schemes registered according to ISO/IEC 6523-2 |
| 6 | dod, United States Department of Defense (DoD) |
| 1 | internet, Communication will be via Internet/network |
| 4 | private, This is a device manufactured by a private entity (not goverment) |
| 1 | enterprise, The device manufacturer is classified as an enterprise |
| 27645 | PostgreSQL global development group |
| 5444 | pem |
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>.
| Identifier | Alert Target Level |
|---|---|
| 1 | Agent |
| 2 | Server |
| 3 | Database |
| 4 | Schema |
| 5 | Table |
| 6 | Index |
| 7 | Sequence |
| 8 | Function |
| 9 | Global |
<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>
| Identifier | Variable Name |
|---|---|
| 1 | alertName |
| 2 | agentID |
| 3 | serverID |
| 4 | agentName |
| 5 | serverName |
| 6 | databaseName |
| 7 | schemaName |
| 8 | objectName |
| 9 | thresholdvalue |
| 10 | previousValue |
| 11 | value |
| 12 | previousStatus |
| 13 | status |
| 14 | recordedTime |
| 15 | downObjects |
| 16 | detailedInformation |
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