hi Vishal, And to find the relationship between objects we can always enable object relationships on the test servers and find out the relations of each form. Once that's done we can use this list of forms for DSO mappings and data transfers. Using a time ranged escalation you can delete the historic data from the forms found by the above method.
Thanks, Vikrant From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Vishal Navale Sent: Sunday, December 02, 2012 8:52 AM To: [email protected] Subject: Re: Remedy archiving methods ** Thanks Vaibav. Do you know how to delete the data from database? How to find out all relationships for IM/CM/PM/SRM/SLM etc Data is huge and we want to delete from database. Thanks Vishal On Thu, Nov 29, 2012 at 11:43 PM, vaibhav wadekar <[email protected]<mailto:[email protected]>> wrote: ** DSO is one of the option I can suggest you for archiving data from main server. Regards/Vaibhav On Thu, Nov 29, 2012 at 12:01 PM, Vishal Navale <[email protected]<mailto:[email protected]>> wrote: ** Hi, We want to archieve Remedy data archive. Currently Remedy have 3 years of data so we want to keep only last 15 months data. Setup is customized. ARS 7.5p4/ITSM 7.6/SQL2008 Please let me know best way to achive this? Regards, Vishal _attend WWRUG12 www.wwrug.com<http://www.wwrug.com/> ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com<http://www.wwrug.com/> ARSlist: "Where the Answers Are"_ _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"
