Agreed. I set mine up with ‘Create Date’ < $DATE$ - (86400 * 365 * 5) since I only had 5 years of back log. Someone thought saving every email was a good idea. Then each week I lowered the multiplier by 0.1 so now I’m down to (86400 * 365 * 2.9). We had 2.6 million email.
Thank you, --- John J. Reiser Building 760-J202 Remedy AR System Developer Senior Software Development Analyst Lockheed Martin - MST Moorestown Region The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Arner, Todd Sent: Tuesday, August 30, 2016 11:39 AM To: [email protected] Subject: Re: EXTERNAL: Application-Query-Delete-Entry ** Be cautious when adding the archiving, especially if the first night it runs if it will be trying to archive a large number of records. We ran into some major performance issues. We ended up slow adjusting the archive criteria so that a smaller amount of records were archived each night until the back log was processed. Todd Arner Great Lakes From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Dave Barber Sent: Tuesday, August 30, 2016 10:29 AM To: [email protected]<mailto:[email protected]> Subject: Re: EXTERNAL: Application-Query-Delete-Entry ** I had completely forgotten about the archiving options (my bad, etc. etc) Much appreciated, I've put that in place to run overnight, with luck it should work! On 30 August 2016 at 15:11, Reiser, John J <[email protected]<mailto:[email protected]>> wrote: ** Dave, Have you tried using the Archive function to just “Delete from Source”? It sets up just like an escalation with a timing cycle to run it and a Qualification to select which data to delete. Thank you, --- John J. Reiser Building 760-J202 Remedy AR System Developer Senior Software Development Analyst Lockheed Martin - MST Moorestown Region The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me From: Action Request System discussion list(ARSList) [mailto:[email protected]<mailto:[email protected]>] On Behalf Of Dave Barber Sent: Tuesday, August 30, 2016 9:49 AM To: [email protected]<mailto:[email protected]> Subject: EXTERNAL: Application-Query-Delete-Entry ** All, I'm trying to figure out the syntax required for Application-Query-Delete-Entry .... (Server is running ARS 7.5) Trying to keep an "archive" of emails - we have a requirement to keep 6 months worth in the system (audit trail, proof of sending, etc.), and the form was actually turning out to be the largest on the system (over 7 million records - I manually deleted the older ones via the user tool, that is not fun!). In an active link, just trying a simple $PROCESS$ @@:Application-Query-Delete-Entry "AR System Email Messages" '3' < ($TIMESTAMP$ - (86400 * 75)) The 75 is related to a test system and the data that is on it (would obviously be changed on live). The query itself is fine against the email messages form, it just comes up with a qualification error when run via the active link. Any suggestions? I could try an alternative using Application-Delete-Entry <form> <record ID> and table walking, but that'll be horrendously inefficient in comparison to Application-Query-Delete-Entry. Regards Dave Barber _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ ________________________________ The information contained in this communication may be confidential, is intended only for the use of the recipient(s) named above, and may be protected under state or federal law. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please forward the communication to [email protected]<mailto:[email protected]> immediately and destroy or delete the original message and any copy of it from your computer system. If you have any questions concerning this message, please contact the sender. _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
