topic Re: SQL statement to remove Events from SIM database. in Server Management - Systems Insight Manager https://community.hpe.com/t5/server-management-systems/sql-statement-to-remove-events-from-sim-database/m-p/3791591#M20339 You may consider making a new event collection in the HPSIM console to find old events ( more than 90 days old for example) and link a task (Options/Events/Delete events) that you can schedule to run every month so that it automatically keeps the total number of registered events under control.<BR /><BR /> Mon, 22 May 2006 05:34:02 GMT T. Vander Auwera 2006-05-22T05:34:02Z SQL statement to remove Events from SIM database. https://community.hpe.com/t5/server-management-systems/sql-statement-to-remove-events-from-sim-database/m-p/3791590#M20338 IS there a collection of Administrative SQL statements for SIM database ?<BR /><BR />I am looking to delete "Informational Events" from the SIM database directly through the SQL since the web interface is too slow for such a huge entries. Fri, 19 May 2006 19:28:49 GMT https://community.hpe.com/t5/server-management-systems/sql-statement-to-remove-events-from-sim-database/m-p/3791590#M20338 Hamsaffar1 2006-05-19T19:28:49Z Re: SQL statement to remove Events from SIM database. https://community.hpe.com/t5/server-management-systems/sql-statement-to-remove-events-from-sim-database/m-p/3791591#M20339 You may consider making a new event collection in the HPSIM console to find old events ( more than 90 days old for example) and link a task (Options/Events/Delete events) that you can schedule to run every month so that it automatically keeps the total number of registered events under control.<BR /><BR /> Mon, 22 May 2006 05:34:02 GMT https://community.hpe.com/t5/server-management-systems/sql-statement-to-remove-events-from-sim-database/m-p/3791591#M20339 T. Vander Auwera 2006-05-22T05:34:02Z Re: SQL statement to remove Events from SIM database. https://community.hpe.com/t5/server-management-systems/sql-statement-to-remove-events-from-sim-database/m-p/3791592#M20340 Now that seems a very reasonable suggestion. I will do that.<BR />Thanks a lot. Mon, 22 May 2006 08:21:13 GMT https://community.hpe.com/t5/server-management-systems/sql-statement-to-remove-events-from-sim-database/m-p/3791592#M20340 Hamsaffar1 2006-05-22T08:21:13Z