Aurora_Gaimon

CA Tuesday Tip - Query to find out users and their disabled notifications

Discussion created by Aurora_Gaimon Employee on Mar 4, 2014
Latest reply on Feb 16, 2016 by nick_darlington

We may see issues with resource who don't receive email notifications. Following tip will show how to query DB and find out what notifications have been disabled:

SELECT USER_ID, NOTIFICATION_TYPE, METHOD
FROM CLB_NOTIFICATION_PREFS

 

CLB_NOTIFICATION_PREFS is the table JUST for disabled notifications. Check with user to enable his/her notifications via Clarity UI (Account settings -> notifications)

 

 

Note: List of all types of notifications:

NOTIFICATION_TO_DO_TYPE
NOTIFICATION_CHANGES
NOTIFICATION_DISCUSSION_TYPE
NOTIFICATION_DOCUMENT_TYPE
NOTIFICATION_ESCALATION
NOTIFICATION_EVENT_TYPE
NOTIFICATION_FIN_MANAGEMENT
NOTIFICATION_INCIDENTS
NOTIFICATION_ISSUES
NOTIFICATION_WORKFLOW
NOTIFICATION_PROJ_PARTICIPANTS
SCHEDULER_TYPE
NOTIFICATION_REQUISITIONS
NOTIFICATION_RISKS
NOTIFICATION_TIMESHEETS_TYPE

 

 

Outcomes