Jira Service Desk - Show customers unsubscribed from notifications

[Gavin Johnson]

Hi,

I'm hoping you can help me.

I'm wondering if it's possible to see the details of any of my customers that have unsubscribed from Jira Service Desk notifications sent to their inbox.

Thanks,

Gavin

[Earl McCutcheon]

Hello,

You can use the following Query in the database to get this list:

SELECT * FROM "AO_54307E_SUBSCRIPTION" WHERE "SUBSCRIBED"='f';

Regards,
Earl

[Gavin Johnson]

Hi @Earl McCutcheon,

Thanks for the answer, unfortunately I can't use it as I'm using a Cloud instance.

Thanks