How about doing Nagios distributed monitoring with NSCA? Have the other systems send passive alerts to the main system which does the notifications.
There is also this, if all the servers have access to all the devices... I have not used this so can't comment on it.
Regarding the SQL method, does anyone know of an application that can display nagios data from the NDO dump to SQL'?