"Alert me about my tasks and status reports"

[David]

Is there anyway 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. Are
the "Sent" emails being kept somewhere?

Any help would be appreciated

Dave

 

[Rolly Perreaux]

Is there anyway 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. Are
the "Sent" emails being kept somewhere?

Any help would be appreciated

Dave

Hi Dave,

That would be a very useful tool, but unfortunately I have not seen this
tool. :-(

However, you could query the Project Server SQL database for this
information. You'll need to review 2 tables:

MSP_WEB_NOTIFICATIONS
MSP_WEB_RESOURCES

The WNTFY_OWNER_ID in MSP_WEB_NOTIFICATIONS table equals the WRES_ID in
the MSP_WEB_RESOURCES table.

Obviously the tables can be very long depending on the number of users
and which notifications they enabled

You can view the data (nothing really fancy) of these tables by
following these instructions:

Open SQL Server Enterprise Manager
Expand to Databases --> ProjectServer --> Tables
Right click on the MSP_WEB_NOTIFICATIONS table and navigate to Open
Table --> Return all rows
A new window appears displaying the data in the table
Repeat for the MSP_WEB_RESOURCES table

Good Luck

--
Rolly Perreaux, PMP
Project Server Trainer/Consultant

IT Summit Series
Advanced Microsoft Technology Training
http://www.itsummitseries.com

 

[David]

Thanks, I'll give it a try.

Dave

Hi Dave,

That would be a very useful tool, but unfortunately I have not seen this
tool. :-(

However, you could query the Project Server SQL database for this
information. You'll need to review 2 tables:

MSP_WEB_NOTIFICATIONS
MSP_WEB_RESOURCES

The WNTFY_OWNER_ID in MSP_WEB_NOTIFICATIONS table equals the WRES_ID in
the MSP_WEB_RESOURCES table.

Obviously the tables can be very long depending on the number of users
and which notifications they enabled

You can view the data (nothing really fancy) of these tables by
following these instructions:

Open SQL Server Enterprise Manager
Expand to Databases --> ProjectServer --> Tables
Right click on the MSP_WEB_NOTIFICATIONS table and navigate to Open
Table --> Return all rows
A new window appears displaying the data in the table
Repeat for the MSP_WEB_RESOURCES table

Good Luck

--
Rolly Perreaux, PMP
Project Server Trainer/Consultant

IT Summit Series
Advanced Microsoft Technology Training
http://www.itsummitseries.com

 

[Dale Howard [MVP]]

Dave --

To piggyback on Rolly's excellent answer, 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 them 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.

--
Dale A. Howard [MVP]
Enterprise Project Trainer/Consultant
Denver, Colorado
http://www.msprojectexperts.com
"We wrote the books on Project Server"