How to Disable the DWP Notifications for all Existing Users? |
First Solution: Submit a Change Request to perform the activity in bulk - To Disable as below: (Please make the necessary changes in your request as per the request needed) A)Take a backup of the tables as per below: 1) select * from dwp_notificationpreferences update dwp_userpreferences set SURVEY_EMAIL_COMMUNICATION='True' where SURVEY_EMAIL_COMMUNICATION='False' update dwp_user_preferences set SURVEY_PHONE_COMMUNICATION='True' where SURVEY_PHONE_COMMUNICATION='False' update dwp_user_preferences set ApprovalEmailCommunication='False' update dwp_user_preferences set ApprovalPhoneCommunication='False' update dwp_user_preferences set BellCommunication='False' update dwp_user_preferences set FeedCommunication='False' update dwp_user_preferences set SrEmailCommunication='False' update dwp_user_preferences set SrPhoneCommunication='False' update dwp_user_preferences set FeedNotification='False' and FeedNotificationMethod=0 update dwp_notification_preferences set Enabled=False update dwp_user_preferences set APPROVAL_EMAIL_COMMUNICATION='False' Second Solution: In DWP Admin console
This will also stops sending out DWP notifications. Third Solution: Go to Cops and search for 'DWP SMTP Enabled' parameter and set it to "No". save and deploy project. (This is application for SaaS customers only) |