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" <sandra.henni...@usdoj.gov> To: arslist@ARSLIST.ORG 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 sandra.henni...@usdoj.gov _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"