Which User Notifications Have Been Enabled?

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

There is a need to find out which users in Clarity have the Alert, Email, or SMS enabled from either the
a. Modern > Avatar > Settings > Notifications
b. Classic > Home > Personal > Account Settings > Notifications

Resolution

The following query can be used to find out which notification and type are enabled:

SELECT
a.CREATED_DATE, a.CREATED_BY, a.USER_ID, a.NOTIFICATION_TYPE, a.METHOD, b.UNIQUE_NAME
FROM clb_notification_prefs a
inner join srm_resources b
on a.user_id = b.user_id
AND a.PRINCIPAL_TYPE = 'USER'
ORDER BY a.LAST_UPDATED_DATE desc