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

Reply via email to