Database Objects OpenNMS

wikibot

OpenNMS (test 104 17.02.2011 23:14:31)

Tables

alarm_attributes (public)
alarms (public)
application_service_map (public)
applications (public)
assets (public)
atinterface (public)
categories (public)
category_node (public)
datalinkinterface (public)
demandpolls (public)
distpoller (public)
element (public)
events (public)
ifservices (public)
inventory (public)
ipinterface (public)
iprouteinterface (public)
location_monitor_details (public)
location_monitors (public)
location_specific_status_changes (public)
map (public)
node (public)
notifications (public)
outages (public)
pathoutage (public)
pollresults (public)
qrtz_blob_triggers (public)
qrtz_calendars (public)
qrtz_cron_triggers (public)
qrtz_fired_triggers (public)
qrtz_job_details (public)
qrtz_job_listeners (public)
qrtz_locks (public)
qrtz_paused_trigger_grps (public)
qrtz_scheduler_state (public)
qrtz_simple_triggers (public)
qrtz_trigger_listeners (public)
qrtz_triggers (public)
reportlocator (public)
resourcereference (public)
servermap (public)
service (public)
servicemap (public)
snmpinterface (public)
statisticsreport (public)
statisticsreportdata (public)
stpinterface (public)
stpnode (public)
testdatatypes (public)
usersnotified (public)
vlan (public)
vulnerabilities (public)
vulnplugins (public)

Functions

getmanagedoutageforintfinwindow (public)
getmanagedoutagefornodeinwindow (public)
getmanagedservicecountforintf (public)
getmanagedservicecountfornode (public)
getmanagepercentavailintfwindow (public)
getmanagepercentavailnodewindow (public)
getoutagetimeinwindow (public)
getpercentavailabilityinwindow (public)

Trigger Functions

setifservicekeysoninsert (public)
setifservicekeysonupdate (public)
setipinterfacekeysoninsert (public)
setipinterfacekeysonupdate (public)
setsnmpinterfacekeysoninsert (public)
setsnmpinterfacekeysonupdate (public)

Sequences

alarmsnxtid (public)
catnxtid (public)
demandpollnxtid (public)
eventsnxtid (public)
mapnxtid (public)
nodenxtid (public)
notifynxtid (public)
opennmsnxtid (public)
outagenxtid (public)
pollresultnxtid (public)
reportnxtid (public)
servicenxtid (public)
testdatatypes_id_seq (public)
usernotifnxtid (public)
vulnnxtid (public)