How to clear applications in Get notifications from these senders

Dear Friends

I have found STStephenHaxby solution for Windows 10 1607:

1. Backup file: "%USERPROFILE%\AppData\Local\Microsoft\Windows\Notifications\wpndatabase.db".
2. Install application: DB Browser for SQLite.
3. Open file: "%USERPROFILE%\AppData\Local\Microsoft\Windows\Notifications\wpndatabase.db".
4. Go to tab: "Execute SQL".
5. Enter and execute entry: "select * from NotificationHandler".
6. Find "HandlerID" for application you want to remove from "Get notifications from these senders".
7. Enter and execute entry: "delete from HandlerSettings where HandlerID = X".
8. Enter and execute entry: "delete from Notification where HandlerID = X".
9. Enter and execute entry: "delete from WNSPushChannel where HandlerID = X".
10. Enter and execute entry: "delete from NotificationHandler where HandlerID = X".
11. Save file: "wpndatabase.db".
12. Reboot your system.

EDIT

Where X is your application's "HandlerID" you have found earlier.

Sincerely

I created an account to say thank you too!!

And I want to add some help. I have an application that create lot of records in table NotificationHandler. So I made this scripts to delete all of them:

delete from HandlerSettings where handlerid in (select recordid from notificationhandler where primaryid like "%explorer.notification.{%");
delete from Notification where handlerid in (select recordid from notificationhandler where primaryid like "%explorer.notification.{%");
delete from WNSPushChannel where handlerid in (select recordid from notificationhandler where primaryid like "%explorer.notification.{%");
delete from NotificationHandler where primaryid like "%explorer.notification.{%";

You have to replace text betwen % with the value in field primarid you want to delete. Symbol % is a wildcard, so any record cointaing part from text between % will be deleted.

I hope this help to another person too.

Thank you.