Having the scenario in which is necessary to check from an admin view perspective which are the notifications settings and options enabled for all the users in DWP.

Screenshots below shows the only view available for end-user but DWP is not having a global view so the admin can verify the settings enabled for all the users.

Example of DWP Notification Settings under User Profile > Preferences



Example of the notification options for Requests..




 

SQL query below will show the Notification Settings and option enables for all DWP users:

select
DWP_Business.USER_PREFERENCES.USER_LOGIN_ID as User_LoginID, DWP_Business.USER_PREFERENCES.BELL_COMMUNICATION as In_App_Notification, DWP_Business.USER_PREFERENCES.APPROVAL_EMAIL_COMMUNICATION as Approvals_Email, DWP_Business.USER_PREFERENCES.APPROVAL_PHONE_COMMUNICATION as Approvals_Push, DWP_Business.USER_PREFERENCES.SR_EMAIL_COMMUNICATION as Requests_Email, DWP_Business.USER_PREFERENCES.SR_PHONE_COMMUNICATION as Requests_Push, DWP_Business.USER_PREFERENCES.SURVEY_EMAIL_COMMUNICATION as FeedBack_Survey_Email, DWP_Business.USER_PREFERENCES.SURVEY_PHONE_COMMUNICATION as FeedBack_Survey_Push, DWP_Business.USER_PREFERENCES.FEED_NOTIFICATION_METHOD as Social_Activity,
DWP_Business.NOTIFICATION_PREFERENCES.TYPE as Notification_Type, DWP_Business.NOTIFICATION_PREFERENCES.KEY_NAME as Option_Name, DWP_Business.NOTIFICATION_PREFERENCES.ENABLED as Option_Enabled, DWP_Business.NOTIFICATION_PREFERENCES.MODIFIED_DATE as Option_Modification_Date
from DWP_Business.USER_PREFERENCES
inner join DWP_Business.NOTIFICATION_PREFERENCES 
on DWP_Business.USER_PREFERENCES.PK = DWP_Business.NOTIFICATION_PREFERENCES.USER_PREFERENCES_PK
order by USER_LOGIN_ID, TYPE
;

Notes and Considerations:

 * The SQL query was wrote and tested using MS SQL Server Management Studio, so if you are using another SQL tool, some small adjustments could be necessary. 

 - 1 means that the Notification setting is turned on per customer preferences.
 - 0 means that the Notification setting is turned off.

 - Only for Social Activity column there are 4 possible values as noted below:
    0 means that both email and push notifications are turned off.
    1 means that only email notification is turned on.
    2 means that only push notification is turned on.
    3 means that both email and push notifications are turned on.  


Tables and Columns involved from DWP application Database:

Table: DWP_Business.USER_PREFERENCES
Columns:
BELL_COMMUNICATION > In App Notifications
APPROVAL_EMAIL_COMMUNICATION > Approvals Email
APPROVAL_PHONE_COMMUNICATION > Approval Push
SR_EMAIL_COMMUNICATION > Request Email
SR_PHONE_COMMUNICATION > Request Push
SURVEY_EMAIL_COMMUNICATION > Feedback Survey Email
SURVEY_PHONE_COMMUNICATION > Feedback Survey Push
FEED_NOTIFICATION_METHOD > Social Activity

Example of above SQL query output:



...