How to identify users who have enabled partially Notifications in Preferences?

[pandunaidu2]

Hi All,

I would like to identify users who have enabled Partial Notifications in their User Preferences under the Notifications tab.

I want to understand:

Where this setting is stored in the database (table and field name)

How to query users who have Partial Notifications enabled

Whether this is stored in sys_user_preference or any other table

I checked the sys_user_preference table, but I was unable to clearly identify which records correspond to Partial Notification settings.

My goal is to generate a report of users who have Partial Notifications enabled.

Any guidance, table references, or sample scripts would be very helpful.

Thanks in advance.

[GlideFather]

Hi @pandunaidu2,

can you explain what do you mean "partial notifications"?

I was trying to find some table that stores the changes in notification toggles, but haven't found anything.

Anyways, you might be luckier, go to this list of all tables containing "notification" in their name and perhaps you will find something:

https://yourinstance.service-now.com/sys_db_object_list.do?sysparm_query=nameLIKEnotification

[Dr Atul G- LNG]

Hi @pandunaidu2 

I tried in my pdi:

https://INSTANCENAME.service-now.com/now/nav/ui/classic/params/target/sys_user_preference_list.do%3Fsysparm_query%3Duser%253D6816f79cc0a8016401c5a33be04be441%26sysparm_first_row%3D1%26sysparm_view%3D