Retrieve Resource Actual Work Assignment

[fefe78]

Hello everybody,

Can someone help me building a query to extract from the project server
database the resource actual work assignment for a project?
I found this query in microsoft documentation but I don't know why the
results are different from what PWA views show.

select
PROJ_NAME as Project,
TASK_NAME as Task_Name,
RES_NAME as Team_Member,
ASSN_ACT_WORK as ActualWork
from
MSP_WEB_PROJECTS p,
MSP_WEB_RESOURCES r,
MSP_WEB_ASSIGNMENTS a
where
a.WRES_ID = r.WRES_ID
and a.WPROJ_ID = p.WPROJ_ID
and a.WNWRK_ID is NULL
order by
PROJ_NAME,
Team_Member

Thanks to everyone help.

Bye

 

[Rod Gill]

I,

From the query I assume you are using Project Server 2003? If so, try using
the MSP_VIEW tables. They are easier to use, especially if you want
timescaled data. These tables are only updated after a project is published.

--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx

 

[fefe78]

Rod Gill ha scritto:

I,

From the query I assume you are using Project Server 2003? If so, try using
the MSP_VIEW tables. They are easier to use, especially if you want
timescaled data. These tables are only updated after a project is published.

Good hint Rod! I've worked many times with MSP_VIEW tables but it
doesn't came to my mind. It works!
Thanks!!

Bye