opennms=> select * from events where eventuei LIKE 'uei.opennms.org/internal/discovery/newSuspect'; -[ RECORD 1 ]-----------+--------------------------------------------------------- eventid | 18 eventuei | uei.opennms.org/internal/discovery/newSuspect nodeid | eventtime | 2017-02-15 14:46:58.569+01 eventhost | eventsource | Discovery ipaddr | 172.16.3.47 eventsnmphost | serviceid | eventsnmp | eventparms | RTT=0.45(string,text);location=Default(string,text) eventcreatetime | 2017-02-15 14:46:58.571+01 eventdescr |

Interface 172.16.3.47 has been discovered and is | being queued for a services scan.

eventloggroup | eventlogmsg | A new interface (172.16.3.47) has been discovered and is | being queued for a services scan. eventseverity | 4 eventpathoutage | eventcorrelation | eventsuppressedcount | eventoperinstruct | eventautoaction | eventoperaction | eventoperactionmenutext | eventnotification | eventtticket | eventtticketstate | eventforward | eventmouseovertext | eventlog | Y eventdisplay | Y eventackuser | eventacktime | alarmid | ifindex | systemid | 00000000-0000-0000-0000-000000000000 -[ RECORD 2 ]-----------+--------------------------------------------------------- eventid | 17 eventuei | uei.opennms.org/internal/discovery/newSuspect nodeid | eventtime | 2017-02-15 14:23:28+01 eventhost | localhost.localdomain eventsource | Web UI ipaddr | 172.16.3.47 eventsnmphost | serviceid | eventsnmp | eventparms | eventcreatetime | 2017-02-15 14:23:29.13+01 eventdescr |

Interface 172.16.3.47 has been discovered and is | being queued for a services scan.

eventloggroup | eventlogmsg | A new interface (172.16.3.47) has been discovered and is | being queued for a services scan. eventseverity | 4 eventpathoutage | eventcorrelation | eventsuppressedcount | eventoperinstruct | eventautoaction | eventoperaction | eventoperactionmenutext | eventnotification | eventtticket | eventtticketstate | eventforward | eventmouseovertext | eventlog | Y eventdisplay | Y eventackuser | eventacktime | alarmid | ifindex | systemid | 00000000-0000-0000-0000-000000000000 opennms=>