Purge Script
My organization has elected to not use archiving for the last year and we have now run into a space issue. I have been tasked with backing up and purging a large volume of rows from the ITSM tables. Has anyone had to do this and if so be willing to share a script? My fear is that relationships to Audit or Work Info or other will be missed and orphaned resulting in further headaches. Thanks in advance! ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Purge Script
Best to do from Archive form properties of desired forms, e.g. purging data using form property archiving from HPD_Help_Desk will also clean up related associated data due to built in filter workflow on DELETE. Do you means archive - i.e. to another form or db, or purge the old data? Attached is a script for sql server for you to be able to cut and paste into excel to determine largest tables. (just remove the ' kb' references to sort correctly. If you haven't already, there are some system forms that get huge that are no brainers for cleanup, e.g. - AR System Email Messages - NTE:Notifier - NTE:Notifier Logs Also if on ITSM 7.5+ consider whether you need people CI data as, that version and above will automatically add a person CI for every CTM:People record - if you're in a large enterprise, that can added up. If you don't need it and it is taking up valuable space then you set a reconciliation job to delete them. Regards, Andrew Goodall Software Engineer 2 | Development Services | jcpenney . www.jcp.com -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Matthew Moellmer Sent: Monday, December 12, 2011 12:50 PM To: arslist@ARSLIST.ORG Subject: Purge Script My organization has elected to not use archiving for the last year and we have now run into a space issue. I have been tasked with backing up and purging a large volume of rows from the ITSM tables. Has anyone had to do this and if so be willing to share a script? My fear is that relationships to Audit or Work Info or other will be missed and orphaned resulting in further headaches. Thanks in advance! ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are table-space-used.sql Description: table-space-used.sql
Re: Purge Script
Alternately you can also delete obsolete records from table, export table data, truncate table and import back the data, in that order to free up unused blocks used by large tables in Oracle.. This would perhaps be quicker if you have large number of tables you wish to perform that exercise on. Joe -Original Message- From: Andrew C Goodall Sent: Monday, December 12, 2011 2:51 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Purge Script Best to do from Archive form properties of desired forms, e.g. purging data using form property archiving from HPD_Help_Desk will also clean up related associated data due to built in filter workflow on DELETE. Do you means archive - i.e. to another form or db, or purge the old data? Attached is a script for sql server for you to be able to cut and paste into excel to determine largest tables. (just remove the ' kb' references to sort correctly. If you haven't already, there are some system forms that get huge that are no brainers for cleanup, e.g. - AR System Email Messages - NTE:Notifier - NTE:Notifier Logs Also if on ITSM 7.5+ consider whether you need people CI data as, that version and above will automatically add a person CI for every CTM:People record - if you're in a large enterprise, that can added up. If you don't need it and it is taking up valuable space then you set a reconciliation job to delete them. Regards, Andrew Goodall Software Engineer 2 | Development Services | jcpenney . www.jcp.com -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Matthew Moellmer Sent: Monday, December 12, 2011 12:50 PM To: arslist@ARSLIST.ORG Subject: Purge Script My organization has elected to not use archiving for the last year and we have now run into a space issue. I have been tasked with backing up and purging a large volume of rows from the ITSM tables. Has anyone had to do this and if so be willing to share a script? My fear is that relationships to Audit or Work Info or other will be missed and orphaned resulting in further headaches. Thanks in advance! ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer. ___ 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
