search cancel

How to check users' custom notification settings?

book

Article ID: 187288

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

Some of our users' notification settings do not update when we update defaults and click Save. How can we see what the custom user notification preferences are? 

Environment

Release : All Supported Clarity releases

Component : CA PPM USERS, GROUPS, OBS ADMINISTRATION

Resolution

You might want to check the table CLB_NOTIFICATION_PREFS to see if the users have custom settings if any:

select *

from CLB_NOTIFICATION_PREFS c, cmn_sec_users u

where  c.user_id = u.id and c.principal_type = 'USER'

and u.user_name ='<enter here the user name>'