HPE Community
Server Management - Systems Insight Manager
1830250 Members
2942 Online
110000 Solutions
New Discussion

SQL statement to remove Events from SIM database.

 
Hamsaffar1
New Member

‎05-19-2006 12:28 PM

‎05-19-2006 12:28 PM

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

‎05-21-2006 10:34 PM

‎05-21-2006 10:34 PM

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.

0 Kudos
Reply
Hamsaffar1
New Member

‎05-22-2006 01:21 AM

‎05-22-2006 01:21 AM

Re: SQL statement to remove Events from SIM database.

Now that seems a very reasonable suggestion. I will do that.
Thanks a lot.
0 Kudos
Reply
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.