Agile Central - Notifications: How to export a list of all project users along with their email notifications status

Products

• CA Agile Central On Premise (Rally)
• CA Agile Central SaaS (Rally)

Issue/Introduction

How can we find the Email Notification selection of all users in our project?
 

Environment

Release:
Component: ACSAAS

Resolution

The Email Notification is a preference of each user. It is part of the User endpoint, in a field named: EmailNotificationsEnabled. 
However, this field is not part of any of the Agile Central screens and can not be added to apps such as Custom List. The reason is that this field is not queriable:

<Please see attached file for image>

However, we can use the Excel add-in to get this information. In the Excel add-in we shall use the ProjectPermission endpoint , filter it by the project we need and manually include the 'User.UserProfile.EmailNotificationEnabled' column. Below is a screenshot showing how to create the query along with the spreadsheet.

<Please see attached file for image>

Additional Information

More on how to set up email notifications: https://help.rallydev.com/set-your-notifications#email

More articles on the Excel add-in, see here. 

More on how query your projects users by permission, see here.