---
title: "Retrieve user acceptance details of announcements from database into Bitbucket"
canonical: "https://support.appfire.com/space/SUPPORT/80881465/Retrieve%20user%20acceptance%20details%20of%20announcements%20from%20database%20into%20Bitbucket"
format: markdown
---
<span style="color: #333333">This article explains how to view the details of user acceptance of announcements created using the</span><span style="color: #333333"> </span>*<span style="color: #333333">Announcer for Bitbucket Server</span>*<span style="color: #333333"> </span><span style="color: #333333">app by retrieving them from the database.</span>

## Instructions

1. <span style="color: #333333">Log into the database.</span>
2. <span style="color: #333333">Use the scheme that you are using for Bitbucket instance. </span>  
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:
  This query displays the user acceptance of announcements list in your Bitbucket instance.

> ℹ️ - No table captures the list of notifications that were not accepted by users.
> ℹ️ - <span style="color: #333333">Ensure to not run </span>**<span style="color: #333333">CREATE/UPDATE/DELETE</span>****<span style="color: #333333"> </span>**<span style="color: #333333">operations that may impact the data at the application level.</span>
> ℹ️ - <span style="color: #000000">MySQL is the database used in this example.</span>