Good day,
I'm a community member of OpenNMS[1] and I also use it at work to monitor our environment. We also use Firebird 2.5, but in a very small scenario (and a little faltering)... I'm always interested to connect together OpenSource projects so I heard the call of duty to create an OpenNMS datacollection for Firebird databases. All the more if I have a both systems in access. OpenNMS is able to use JDBC, we have already a JDBC Monitor[2] and JDBC StoredProcedure Monitor[3] and OpenNMS is able to collect time series data over JDBC. So it should be easy to access the Firebird database and collect data using the Jaybird driver. I already found out, that Firebird provides monitoring tables[4]. It seems, they should give really good information. And that is my problem. I don't have much database know how, so I'm not able to decide, which data is worth beeing collected / monitored. To be honest, my hope is, that some people here can provide universal SQL queries for statistics and/or fault management purposes. But I'm glad for any other help, too. Thanks a lot and have a nice weekend! -- Marcel [1] http://opennms.org [2] http://docs.opennms.org/opennms/releases/18.0.2/guide-admin/guide-admin.html#_jdbcmonitor [3] http://docs.opennms.org/opennms/releases/18.0.2/guide-admin/guide-admin.html#_jdbcstoredproceduremonitor [4] http://ibexpert.net/ibe/index.php?n=Doc.AdministrativeFeatures21[[#Metadata
