Task ownership?

[J Burford Fields]

Is there a way to see who last published or re-published a task?

 

[Gary L. Chefetz [MVP]]

JB:

From the Resource Center, select view resource assignments. The PM field
contains the current owner of the task.

 

[Dale Howard [MVP]]

J --

Are you referring specifically to the person that Project Server designates
as the Manager of each task? The Manager is the person who initially
publishes the task assignments using Collaborate - Publish - New and Changed
Assignments, or the person who takes over as manager by clicking
Collaborate - Publish - Repubish Assignments and selects the "Become the
manager for these assignments" option. The Manager is also the person to
whom task updates are sent from team members when the click the Update All
or Update Selected Tasks button on their PWA timesheet page. If the Manager
of each task is what you seek, you can see this information in the View
Resource Assignments page if you add the Manager field to the list of fields
in the Summary view in the Assignment section.

An alternate approach would be to use a SQL Server query such as follows:

SELECT MSP_WEB_PROJECTS.PROJ_NAME, MSP_WEB_ASSIGNMENTS.TASK_NAME,
MSP_WEB_RESOURCES.RES_NAME AS Resource,
MSP_WEB_RESOURCES_1.RES_NAME AS Manager
FROM MSP_WEB_ASSIGNMENTS INNER JOIN
MSP_WEB_RESOURCES ON MSP_WEB_ASSIGNMENTS.WRES_ID =
MSP_WEB_RESOURCES.WRES_ID INNER JOIN
MSP_WEB_RESOURCES MSP_WEB_RESOURCES_1 ON
MSP_WEB_ASSIGNMENTS.WRES_ID_MGR =
MSP_WEB_RESOURCES_1.WRES_ID INNER JOIN
MSP_WEB_PROJECTS ON MSP_WEB_ASSIGNMENTS.WPROJ_ID =
MSP_WEB_PROJECTS.WPROJ_ID

Please keep in mind that I am not a SQL Server DBA professionally, but I was
able to hack together a Query that revealed the Manager of each task
assignment in the Project Server database. Hope this helps.

 

[J Burford Fields]

Yes, Dale. That was exactly the information I was looking for. Again,
thanks.

J

 

[Dale Howard [MVP]]

J --

You are more than welcome, my friend!

 

[J Burford Fields]

Hi Dale,

I set this asside for a quiet moment, and now that I'm trying it,
danged if I can find the manager field...

Am I missing something?

J

 

[Dale Howard [MVP]]

J --

To edit the Summary view in the Assignment section, simply add the Project
Manager field to the view. Sorry that I did not make that more clear!
Hope this helps.

 

[J Burford Fields]

Ah, well, that was clear enough. I tried it and find that the Project
Manager field is blank when I look at it that way. I was hoping there
was another "manager" field that I was missing, somewhere else. Back
to the investigation....