Method to delete history out of Notifications without deleting contacts

Products

• Automation Point

Issue/Introduction

 I reset the NM database to its default settings and was able to see the Notification Status (empty but no error message).
Then, I restored all my contacts from another AP server that had the same ones and everything is working okay.

How can I delete the entire history of sent notifications (they come from another machine) without deleting all the contacts ?

Environment

All AP releases, confirmed in 11.7 and 11.8

Resolution

To delete the history only:

1.           Export the NM database,
2.           Delete the ap_nm_notify_item file
3.           Import it back again

When there are no sent messages, the file is not even created for the export, so the operation will not put you beyond regular scenarios. 

Additional Information

We recommend to store the file for further use, as the upcoming 11.8 will be more resilient to extensive workload and you might want to import the records back again.