Hrm... I don't have a gui method, but here are the steps via command line.
1. connect to mysql (mysql -u zenoss -p) 2. enter your mysql password (this was set during install) 3. list the databases to make sure you are connecting to the right one (show databases;) (don't forget the ;) 4. connect to the events database (use events;) 5. list the tables (show tables;) (the history table should be in there) 6. see how many rows contain your device (select count(*) from history where device='yourdevicename';) (I had like 2400 rows of an old device) 7. delete the rows from the history table that correspond to your device (delete from history where device='yourdevicename';) 8. check and see if your delete command worked (select count(*) from history where device='yourdevicename';) (I had 0 rows after there delete :) I confirmed the existance and non-existance of the device in my history through the GUI too. In the GUI I went to the event console and clicked the View History link. I set the Start and End dates to encompass the life of my zenoss server and then filtered by the device name. Before the delete, ~2400 rows, after the delete, ~0 (a couple rows remained that had the device name in the summary of events that belonged to other devices). Be careful with the delete command you don't want to delete the wrong thing! There may be a cleaner way, but this works. -------------------- m2f -------------------- Read this topic online here: http://forums.zenoss.com/viewtopic.php?p=30651#30651 -------------------- m2f -------------------- _______________________________________________ zenoss-users mailing list [email protected] http://lists.zenoss.org/mailman/listinfo/zenoss-users
