Hi, I define the four following tables in my MIB:
-- The servers table -- monServerTable OBJECT-TYPE SYNTAX SEQUENCE OF MonServerEntry MAX-ACCESS not-accessible STATUS current DESCRIPTION "A Table containing all servers running" ::= { monMetrics 1 } monServerEntry OBJECT-TYPE SYNTAX MonServerEntry MAX-ACCESS not-accessible STATUS current DESCRIPTION "A row in the table of servers" INDEX { monServerIndex } ::= { monServerTable 1 } MonServerEntry ::= SEQUENCE { monServerIndex Unsigned32, monServerName OCTET STRING, monServerProductName OCTET STRING, monServerHostname OCTET STRING, monServerPID Unsigned32 } monServerIndex OBJECT-TYPE SYNTAX Unsigned32(1..65535) MAX-ACCESS not-accessible STATUS current DESCRIPTION "The unique value which identifies a Server" ::= { monServerEntry 1 } monServerName OBJECT-TYPE SYNTAX OCTET STRING (SIZE(0..32)) MAX-ACCESS read-only STATUS current DESCRIPTION "The name of the Server" ::= { monServerEntry 2 } monServerProductName OBJECT-TYPE SYNTAX OCTET STRING (SIZE(0..32)) MAX-ACCESS read-only STATUS current DESCRIPTION "The Product name the Server belongs to" ::= { monServerEntry 3 } monServerHostname OBJECT-TYPE SYNTAX OCTET STRING (SIZE(0..32)) MAX-ACCESS read-only STATUS current DESCRIPTION "The Hostname where the Server runs" ::= { monServerEntry 4 } monServerPID OBJECT-TYPE SYNTAX Unsigned32(1..65535) -- MAX-ACCESS read-only STATUS current DESCRIPTION "The Process Id of the Server" ::= { monServerEntry 5 } -- Generic Numerical metrics for servers -- monNumericMetricsTable OBJECT-TYPE SYNTAX SEQUENCE OF MonNumericMetricsEntry MAX-ACCESS not-accessible STATUS current DESCRIPTION "List of numerical metrics exposed by a server This table is generic and specific for each server" ::= { monMetrics 3 } monNumericMetricsEntry OBJECT-TYPE SYNTAX MonNumericMetricsEntry MAX-ACCESS not-accessible STATUS current DESCRIPTION "" INDEX { monServerIndex, monNumericMetricsShortName } ::= { monNumericMetricsTable 1 } MonNumericMetricsEntry ::= SEQUENCE { monNumericMetricsShortName OCTET STRING, monNumericMetricsName OCTET STRING, monNumericMetricsValue Unsigned32 } monNumericMetricsShortName OBJECT-TYPE SYNTAX OCTET STRING (SIZE(0..32)) MAX-ACCESS read-only STATUS current DESCRIPTION "Short name describing the numerical metric" ::= { monNumericMetricsEntry 1 } monNumericMetricsName OBJECT-TYPE SYNTAX OCTET STRING (SIZE(0..64)) MAX-ACCESS read-only STATUS current DESCRIPTION "Name describing the numerical metric (Long name used for display)" ::= { monNumericMetricsEntry 2 } monNumericMetricsValue OBJECT-TYPE SYNTAX Unsigned32 MAX-ACCESS read-only STATUS current DESCRIPTION "Numerical metric value" ::= { monNumericMetricsEntry 3 } -- Generic Alphanumerical metrics for servers -- monAlphaNumericMetricsTable OBJECT-TYPE SYNTAX SEQUENCE OF MonAlphaNumericMetricsEntry MAX-ACCESS not-accessible STATUS current DESCRIPTION "List of alpha-numerical metrics exposed by a server This table is generic and specific for each server" ::= { monMetrics 4 } monAlphaNumericMetricsEntry OBJECT-TYPE SYNTAX MonAlphaNumericMetricsEntry MAX-ACCESS not-accessible STATUS current DESCRIPTION "" INDEX { monServerIndex, monAlphaNumericMetricsShortName } ::= { monAlphaNumericMetricsTable 1 } MonAlphaNumericMetricsEntry ::= SEQUENCE { monAlphaNumericMetricsShortName OCTET STRING, monAlphaNumericMetricsName OCTET STRING, monAlphaNumericMetricsValue OCTET STRING } monAlphaNumericMetricsShortName OBJECT-TYPE SYNTAX OCTET STRING (SIZE(0..32)) MAX-ACCESS read-only STATUS current DESCRIPTION "Short name describing the alpha-numerical metric" ::= { monAlphaNumericMetricsEntry 1 } monAlphaNumericMetricsName OBJECT-TYPE SYNTAX OCTET STRING (SIZE(0..64)) MAX-ACCESS read-only STATUS current DESCRIPTION "Name describing the alpha-numerical metric (Long name used for display)" ::= { monAlphaNumericMetricsEntry 2 } monAlphaNumericMetricsValue OBJECT-TYPE SYNTAX OCTET STRING (SIZE(0..256)) MAX-ACCESS read-only STATUS current DESCRIPTION "Alpha-Numerical metric value" ::= { monAlphaNumericMetricsEntry 3 } There is one master table monServerTable with: - the principal index identifying a server (monServerIndex) And two tables linked to the table monServerTable by the index monServerIndex + an extra field monNumericMetricsShortName / monAlphaNumericMetricsShortName. 1. Does anybody know if an open-source client monitoring can manage joins between tables so that it can display for one server: - all the numerical metrics (table monNumericMetricsTable) by using the index monServerIndex - all the alpha numerical metrics (table monAlphaNumericMetricsTable) by using the index monServerIndex 2. Does anybody know if commercial tools can perform this too (Tivoli, BMC Patrol, HP OpenView) Thanks in advance. Arnaud. _________________________________________________________________ Express yourself instantly with MSN Messenger! Download today it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Net-snmp-users mailing list Net-snmp-users@lists.sourceforge.net Please see the following page to unsubscribe or change other options: https://lists.sourceforge.net/lists/listinfo/net-snmp-users