SNMP Trap Details

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