Ticket #2884 (new enhancement)
Cleanup details table as part of history cleanup
| Reported by: | cluther | Owned by: | ecn |
|---|---|---|---|
| Priority: | 3 - Medium | Milestone: | Blue Crab |
| Component: | ZenEvents | Version: | 2.1.2 |
| Keywords: | Cc: | ||
| Community Patch Attached: | Deployed @ Customer: | ||
| Installer: | Maintenance Target: | ||
| Specific ZenPack: | Maintenance Status: | ||
| Documentation Note?: | Not required | Regression: |
Description
Details related to events that no longer exist in the status or history tables should be deleted whenever events are deleted from the history table.
This query does the job:
DELETE FROM detail WHERE evid NOT IN (
SELECT evid FROM status UNION SELECT evid FROM history
);
Change History
Note: See
TracTickets for help on using
tickets.
