I think NTE:Notifier already has a scheduled job to delete it’s records. Look for an escalation that deletes anything 21 days or older.
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Hennigan, Sandra Sent: Tuesday, August 06, 2013 6:41 AM To: [email protected] Subject: Re: NTE:Notifier and NTE:Notifier Log Forms - Resolved ** Sounds like a perfect plan!! I will setup the archive/delete of the NTE:Notifier and NTE:Notifier Log Forms to match the archival of tickets. Thank you, Sandra Hennigan Remedy Developer From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Jason Sent: Tuesday, August 06, 2013 9:10 AM To: [email protected] Subject: Re: NTE:Notifier and NTE:Notifier Log Forms ** You don't want to just delete them. Most places I've been to, we've setup a delete schedule to remove them after either 6 or 12 months. When you view the audit logs for an incident, change, etc... The notifications tab displays the records in the log form. The NTE:Notifier is the table that actually sends out your ITSM notifications. When a user clicks on a URL in the notifications, they are taken to the NTE:Notifier form and workflow redirects them to the incident, change, etc. If you delete the records in there, users will get an error that the record doesn't exist when they try to click on the URL. Jason Bess From: "Hennigan, Sandra" <[email protected]> To: [email protected] Sent: Monday, August 5, 2013 5:53 PM Subject: NTE:Notifier and NTE:Notifier Log Forms ** Windows 2008 r2 Oracle 11g ARS 8.1 ITSM 8.1 So I was troubleshooting an issue that caused me to search the NTE:Notifier and NTE:Notifier Log Forms. I had expected NOT to find any records in either form except where there might be an error on the record. I thought (and the Delete Filters, NTE:NTS:Delete_800 and NTE:NTL:Delete_795 confirm) that there should not be any records. Except I found over 48,000. Do I just delete the records? What are the implications/complications of leaving them other than increasing the size of the database? Issues to be aware of if I delete them? How do I get the delete filters to function? Thank you, Sandra Hennigan Remedy Developer Criminal Division | U.S. Department of Justice ☎ (202) 353-0557 Mobile: 202-716-0848 [email protected] _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_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
