HPE Community read-only access December 15, 2018
This is a maintenance upgrade. You will be able to read articles and posts, but not post or reply.
Hours:
Dec 15, 4:00 am to 10:00 am UTC
Dec 14, 10:00 pm CST to Dec 15, 4:00 am CST
Dec 14, 8:00 pm PST to Dec 15, 2:00 am PST
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.