Monitoring client and management of SNMP tables and joins across multiple tables

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
[email protected]
Please see the following page to unsubscribe or change other options:
https://lists.sourceforge.net/lists/listinfo/net-snmp-users