Tadeu,
I dealt with this very thing yesterday. Here is what I did, and it did not affect the server. Deleting all these entries from a Remedy client will take forever and may not even complete. Use the TRUNCATE TABLE command (SQL Server) to instantly clear out all entries for this form. To do so, find out the table names that comprise the Remedy form. Run the following command to get the schema number. SELECT schemaId FROM ARSchema WHERE name = 'Alert Events' On my system it is 6. Then run these three commands to clear out all entries (substitute the number 6 for the number on your system). TRUNCATE TABLE T6 TRUNCATE TABLE H6 TRUNCATE TABLE B6 Now that the form is clear add workflow to automatically maintain the form size. Add a display-only radio button field to the form named something like 'Delete This Record'. Add a filter that runs on Modify when this field = 0. The filter will use a Run Process with the command Application-Delete-Entry "$SCHEMA$" $1$ to delete the record. Create an escalation that runs once a night which sets the value of 0 to the 'Delete This Record' field when 'Create Date' < ($TIMESTAMP$ - (86400 * 21)) This will keep only that last 21 days of entries in this form. Stephen Remedy Skilled Professional ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tadeu Augusto Dutra Pinto Sent: Thursday, January 10, 2008 8:00 AM To: arslist@ARSLIST.ORG Subject: Delete Records of Alert Events Hello for all, How can I clean up records from a table that growths abnormaly?? I'm facin' a serious problem with "Alert Events" table. Since 2004 it's been growing without control... Nowadays, this table has around 7 GB... I want to know if have a way that I can delete all records of this table with a security mode (not crashing the server)... Could it be with Escalations? If Yes, how? With Application-Delete-Entry? Application-Query-Delete-Entry?? I thought in a way to delete records based in a range of date... Like taking the date of First record saved in this table and going to deleting month by month (in a range of a month/day)... Is it possible?? Gimme your suggestions, please! Thankx-in-advance... Regards... P.S.1: I have knowledge tha exists the Escalation "CleanUpAlertEvents" but I think that this way will crash my ARS server if I runs it... P.S.2: I have another tables like that... but Alert Events is the greater... Tadeu Augusto Dutra Pinto ----------------------------------------------------------------- IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing ----------------------------------------------------------------- Confiabilidade, Inovação e Qualidade em T.I. __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"