Retrieve user acceptance details of announcements from database into Bitbucket

This article explains how to view the details of user acceptance of announcements created using the Announcer for Bitbucket Server app by retrieving them from the database.

Instructions

1. Log into the database.

2. Use the scheme that you are using for Bitbucket instance. 
   All the notifications accepted by users are stored in the AO_CE9B14_NOTIF2_USER table.

3. Compose a SELECT query to retrieve the list of notifications accepted by users from the table, as given below:

   select * from AO_CE9B14_NOTIF2_USER,AO_CE9B14_NOTIFICATION_USER;

   This query displays the user acceptance of announcements list in your Bitbucket instance.