Server Management - Systems Insight Manager
cancel
Showing results for 
Search instead for 
Did you mean: 

SQL statement to remove Events from SIM database.

Hamsaffar1
Occasional Visitor

SQL statement to remove Events from SIM database.

IS there a collection of Administrative SQL statements for SIM database ?

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.
2 REPLIES
T. Vander Auwera
Frequent Advisor

Re: SQL statement to remove Events from SIM database.

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.

Hamsaffar1
Occasional Visitor

Re: SQL statement to remove Events from SIM database.

Now that seems a very reasonable suggestion. I will do that.
Thanks a lot.