View user acceptance of announcements from database using Announcer for Jira

This article explains how to view the details of user acceptance of announcements from the database using the Announcer for Jira app.

Instructions

Log into the database.
Use the scheme that you are using for Jira instance. All the notifications accepted by users list are stored in the AO_63D3CD_NOTIF2_USER table.
Compose a SELECT query to retrieve the list of notifications accepted by users from the table, as given below:
```
select * from AO_63D3CD_NOTIFICATION_USER, AO_63D3CD_NOTIF2_USER;
```

No table captures the list of notifications, that were not accepted by users.
Make sure you are not running CREATE/UPDATE/DELETE operations. These operations may impact the application.
The above-given example is from MySQL database.