Event tables
"Madden, Joe" <[email protected]>
| Newsgroups | gmane.network.opennms.general |
|---|---|
| Message-ID | <LO1P123MB0051A2722734211A5583038491D90@LO1P123MB0051.GBRP123.PROD.OUTLOOK.COM> |
Hi All, Just after some advice regarding event table maintenance on OpenNMS. In previous version of OpenNMS the table maintenance was covered by this wiki entry: https://wiki.opennms.org/wiki/Event_Maintenance After a few weeks its occurred to me that this is no longer in date as data within the events table now also has values within the event_parameters table. I guess I need to come up with SQL that will get the ID's from events and delete the associated rows within event_parameters as required. Separately to this - I've got rows within event_parameters which no longer have an associated row in events due to my scheduled maintenance but the table is huge now and I'm struggling to delete rows in here that are no longer required. Cheers Joe ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ Please read the OpenNMS Mailing List FAQ: http://www.opennms.org/index.php/Mailing_List_FAQ opennms-discuss mailing list To *unsubscribe* or change your subscription options, see the bottom of this page: https://lists.sourceforge.net/lists/listinfo/opennms-discuss