In my last engagement I built a simple batch file to call RRR|Chive with parameters and then used the Windows scheduler to run monthly record archiving for anything older than 36 months to the read-only archive copy of the form (yes the business wanted to keep three years' worth of tickets in the live form). The batch file ran in the middle of the night (corporate office time) when Remedy activity was at its slowest so the performance impact was minimal. One caveat is that it was only moving less than 10K records each month.
-Rick -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Misi Mladoniczky Sent: Tuesday, August 07, 2012 7:01 AM To: [email protected] Subject: Re: EXTERNAL: Help on archiving data. Hi, RRR|Chive has the ability to MOVE things, which is good when you do archiving. If the forms are identical, it is very easy, and you can retain the original Request ID, which the built in archiving does not support. You can also use RRR|Chive to archive things to ARX-files. If you then use RRR|ArxToHTML, you get a very simple way of accessing your old data from RRR|a web server or a file share. Here is a sample database dump done with RRR|Chive and RRR|ArxToHTML of a newly installed ITSM 7.6.04 Stack Installer: http://rrr.se/itsmdoc/itsm764arxhtml/ This sample rrrchive config will archive between two forms after 3 months: source_server = myserver source_user = Demo source_password = source_form = HPD:Help Desk target_server = myserver target_form = HPD:Help Desk Archive qual = '7' = "Closed" AND '6' < $TIMESTAMP$ - 3*30*24*60*60 transfertype = MOVE logfile = AUTO progressbar = YES This sample rrrchive config will archive to ARX-files after 6 months: source_server = myserver source_user = Demo source_password = source_form = HPD:Help Desk Archive target_dir = C:\archive target_form = HPD:Help Desk Archive qual = '7' = "Closed" AND '6' < $TIMESTAMP$ - 6*30*24*60*60 transfertype = MOVE logfile = AUTO progressbar = YES This RRR|ArxToHTML call will create HTML pages based on an ARX-file and a DEF-file with the form definition: rrrArxToHTML.pl -suppressnull -d "c:\archivehtml\schema.def" -a "c:\archive\HPD_Help_Desk_Archive.arx" -t "c:\archivehtml\html" ADV: If you want a supported solution, you can always sign up for support on RRR|Chive, which is otherwise free to use. Just ask for a quote. Best Regards - Misi, RRR AB, http://rrr.se > Robin, > Both of these could be handled by RRR|Chive. > www.rrr.se > > Misi's tools are very straight forward. > > Thank you, > --- > John J. Reiser > Remedy Developer/Administrator > Senior Software Development Analyst > Lockheed Martin - MS2 > The star that burns twice as bright burns half as long. > Pay close attention and be illuminated by its brilliance. - > paraphrased by me > > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[email protected]] On Behalf Of Robin > Sent: Tuesday, August 07, 2012 3:07 AM > To: [email protected] > Subject: EXTERNAL: Help on archiving data. > > Hi all, > > Can you please let me know your suggestions/solutions on requirements > 1 and 2? > > 1) Transfer records from a regular form to an archive form and delete > records from the regular form. I don't want to use built-in remedy > archive feature as it consumes lot of resources and takes long time to > complete. > > 2) Transfer records from an archive table to a different database > table and delete records from the archive table. > > The AR System database is oracle. > > > Regards > Robin > > ______________________________________________________________________ > _________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" > > ______________________________________________________________________ > _________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
