identifying users that disabled specific email notifications

[BrunoPer]

During our instance setup, some agents got overwhelmed by the amount of received emails and just disabled their mail notifications.
Now that those have been stabilized, I want to ensure those are re-enabled again, so I'm looking for a way to see which users are (or are not) subscribing to a specific type (and/or all) of my system email notifications.

[PeriyasamyP]

You can find this info from this table "sys_recipient_notif_preference".

If Send is False, then notification is disabled.

[BrunoPer]

hello, thanks for your help! this seems to track the latest action in relation to a specific user and not the overall user's status per notification. That is what I am looking forward.

Any hint around cmn_notif_message,  glide.notification.preference.ui.enabled or sys_notif_subscription?

[PeriyasamyP]

I think, you can find info what you are looking for.

If there is no entry here, then use haven't modified anything. (ie Email will be sent to users) 

[kateparker7]

To find this information in ServiceNow, you’ll want to look at the User Preferences and Notification Preferences tables. There isn't a single "out of the box" report for this, but you can find the data easily using these steps:

1. Check for Global Disables
If agents turned off all notifications, look at the User Preferences (sys_user_preference) table:

Search for the name "notification_all".

Filter for Value is false.

This will give you a list of every user who has completely opted out of system emails.

2. Check for Specific Notifications
If they only disabled specific ones, you need the Notification Preferences (cmn_notif_device_filter) or Notification Message (cmn_notif_message) tables:

Go to cmn_notif_message.list in your filter navigator.

Filter by the Notification name you are interested in.

Add a filter for Boolean is false.

This will show you exactly which users have toggled that specific notification to "off."

3. Quick Fix (Mass Re-enable)
If you have a long list and want to re-enable them all at once, you can run a quick background script to set those Boolean values back to true, or simply delete the "false" records for those specific preferences so they revert to the system default (which is usually "on").

Tip: Moving forward, it might be worth looking into Notification Categories so agents can manage groups of emails rather than having to hunt through every single one.