Can you advise how to find local resources task assignments?

[hellohoa]

Can anyone advise how I can find all the task assigments for loca
resources given a project ID
I found the local resources in a specific project as below

SELECT P.WPROJ_ID, P.PROJ_NAME, T.ResourceNam
FROM dbo.MSP_WEB_PROJECTS P INNER JOI
dbo.MSP_VIEW_PROJ_RES_STD T ON P.WPROJ_ID
T.WPROJ_I
WHERE (P.WPROJ_ID = 819) AND (T.ResourceEnterpriseUniqueID
0

 

[Guest]

You moving in the right direction, just extend it a bit more
SELECT
P.WPROJ_ID
, P.PROJ_NAME
, T.ResourceName
, AssignmentUniqueID -- once you have this you can looup whatever you
want
, AssignmentTaskName -- the task name is only a simple example
FROM
MSP_WEB_PROJECTS P
JOIN MSP_VIEW_PROJ_RES_STD T ON P.WPROJ_ID = T.WPROJ_ID
join MSP_VIEW_PROJ_ASSN_STD A on P.WPROJ_ID = A.WPROJ_ID
and T.ResourceUniqueID = A.ResourceUniqueID
WHERE
P.WPROJ_ID = 819
AND T.ResourceEnterpriseUniqueID < 0

Does this answer your question?

Bob Segrest, PMP
Microsoft Project Blackbelt