Archiving in ITSM is a complex operation. The first thing to define is what data do you want to archive? To determine this, you need to speak to your user base (Do they want just Incidents, or Incident Work Logs, or Incident Attachments - what do they expect to happen if you want to archive an Incident that is associated with another ticket?
Once you have determined this, then you can begin to plan how to archive. This is a very rough plan of how we did this here: 1. Determine the archive qualification for the base form. 2. Determine the relationship between the base form and child forms (Worklogs, attachments etc) 3. Write a SQL update that will set a flag on the child forms when the base form tickets are ready to be archived. 4. Archive the child forms - using the Archive flag 5. Using a SQL update, set the archive flag on the base form 6. Archive the base forms - using the Archive flag This method was determined to be the most efficient. This way you can keep all your relationships between Incidents, and the SQL updates are used because if you have significant numbers of records to archive, setting the Archive flag using Remedy workflow uses a significant amount of Filter processing. Hope this helps anybody who is thinking of archiving anything in ITSM. Thanks, Gavin Coleman Senior Analyst/Programmer Computacenter (UK) Ltd Services & Solutions Hatfield Avenue Hatfield, Hertfordshire, AL10 9TW, United Kingdom T: +44 (0) 1707 631662 E: gavin.cole...@computacenter.com<mailto:gavin.cole...@computacenter.com> W: www.computacenter.com<http://www.computacenter.com> From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Walters, Mark Sent: 20 April 2010 11:38 To: arslist@ARSLIST.ORG Subject: Re: how to retrieve incidents which are already been archived ** Export the records from the archive form to an arx file using a User Tool report and then import them back into the original form. Mark From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of ITN (Amanullah Bashir Ahmed) Sent: 20 April 2010 04:47 To: arslist@ARSLIST.ORG Subject: how to retrieve incidents which are already been archived ** Hi there, I have successfully archived the incidents. How to retrieve those incidents which are already been archived? Thanks in advance Thanks & Regards Amanullah Software Consultant Thanks & Regards Amanullah Software Consultant IT Application and Enterprise Management Emirates NBD Desk: +971 4 2092634 Mobile: +971 50 2182455 DISCLAIMER:"This e-mail message including any of its attachments is intended solely for the addressee(s) and may contain privileged information. If you are not the addressee or you have received this email message in error, please notify the sender who will remove your details from its database. You are not authorized to read, copy, disseminate, distribute or use this e-mail message or any attachment to it in any manner and must delete the email and destroy any hard copies of it. This e-mail message does not contain financial instructions or commitments of any kind. Any views expressed in this message are those of the individual sender and do not necessarily reflect the views of Emirates NBD PJSC, or any other related subsidiaries, entities or persons." _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ ********************************************************************** COMPUTACENTER PLC is registered in England and Wales with the registered number 03110569. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (UK) Limited is registered in England and Wales with the registered number 01584718. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (Mid-Market) Limited is registered in England and Wales with the registered number 3434654. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (FMS) Limited is registered in England and Wales with the registered number 3798091. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW The contents of this email are intended for the named addressee only. It contains information which may be confidential and which may also be privileged. Unless you are the named addressee (or authorised to receive mail for the addressee) you may not copy or use it, or disclose it to anyone else. If you receive it in error please notify us immediately and then destroy it. Computacenter information is available from: http://www.computacenter.com ********************************************************************** _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"