Disable notification for all users using script

[Govind Kumar S1]

Hi all,

I want to disable notification for all users for Temporary purpose. Anyone can suggest me , how to achieve this using Script.

Thanks & Regards

Govind Kumar Sharma

[Gurpreet07]

Hi Govind,

What type of notifications you want to disable. If you want to disable email notifications for all users then you could simply modify the email properties(System Properties --> Email ) to redirect all emails to some other email address.

[Govind Kumar S1]

Hi Gurpreet,

Thanks for reply. I want to disable all notification.I know this this solution. but I want to do this using script. can you please guide me on this.

Thanks & Regards

Govind Kumar Sharma

[Gurpreet07]

Hi Govind,

I am not sure if it will help or not but all i know is , Devices for notification preferences for all users stored in cmn_notif_device table . Thus un checking active for all devices should disable the notifications but not all notifications. if a notification is configured to be send to a user the system first check for the primary notification device of type email and if its not found then it will send email to the email field in the user record. You could inactivate all records using script but remember to keep   a backup. There will be some notification devices which are already inactive and if you are inactivating all the email devices then you will lost the record that which were inactive earlier.

[Kalaiarasan Pus]

There is a notification field on all the user records. Query sys_user table and set it to 'disable' using script for all the users.