Dave asks:

Is there any way as the PWA Administrator, I can go in and find out who has setup their "Alert me about my tasks and status reports" settings? I'm sure there are several people within my origanization that haven't done this yet and are not getting the necessary emails alerting them of their tasks.

Dale Howard replies:

I believe the following SQL Server query will tell you which resources have disabled the permissions that send an Alert to them when they receive either a new task assignment in a project or when their task assignments have changed in a project:

SELECT MSP_WEB_RESOURCES.RES_NAME, MSP_WEB_NOTIFICATION_EVENTS.WNTFY_EVENT_DESC

FROM MSP_WEB_NOTIFICATION_EVENTS

INNER JOIN MSP_WEB_NOTIFICATIONS ON MSP_WEB_NOTIFICATION_EVENTS.WNTFY_EVENT_ID = MSP_WEB_NOTIFICATIONS.WNTFY_EVENT_ID

INNER JOIN MSP_WEB_RESOURCES ON MSP_WEB_NOTIFICATIONS.WNTFY_OWNER_ID = MSP_WEB_RESOURCES.WRES_ID

WHERE(MSP_WEB_NOTIFICATIONS.WNTFY_EVENT_ID = 1001) AND (MSP_WEB_NOTIFICATIONS.WNTFY_IS_ENABLED = 0) OR (MSP_WEB_NOTIFICATIONS.WNTFY_EVENT_ID = 1003) AND (MSP_WEB_NOTIFICATIONS.WNTFY_IS_ENABLED = 0)

ORDER BY MSP_WEB_RESOURCES.RES_NAME

In re-reading your original post, however, the permissions issue might not be the only source of why some resources are not receiving e-mail notifications about their tasks.

Other causes would be that you have not entered e-mail addresses for them in the Enterprise Resource Pool or the project manager has set these resources as Proposed team members on a project. Just a couple of thoughts. Hope this helps.