OpenNMS 090807

From dbscript Online Help

Contents 1 wikibot 1.1 Tables 1.2 Functions 1.3 Trigger Functions 1.4 Sequences

wikibot

OpenNMS (OpenNMS 090807)

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)