How can I get the hours of work assigned to the resource

[Daisy]

Hi,
I have created a project and have assigned some task to the
resources.Through PSI i want to access the no. of hours the resource had to
work in the project. I didn't find any table from database where I can get
those hours.So that the total effort given by the resource can be
calculated.How can I get the hours of work assigned to the resource.Please
help

 

[Stephen Sanderlin]

If I'm reading your question correctly, you are trying to determine the
total Work a Resource has been assigned in a particular Project.



You should be able to obtain this information by calling the ReadProject
method of the Project PSI and filtering RES_UID column in the Assignment
table of the returned ProjectDataSet for the appropriate Resource GUID.



You can also retrieve this data from the Reporting Database by SUMing
AssignmentWork in MSP_EpmAssignment_UserView after filtering for
ResourceUID and ProjectUID.



--

Stephen Sanderlin

Principal Consultant

MSProjectExperts



For Project Server Consulting: http://www.msprojectexperts.com

For Project Server Training: http://www.projectservertraining.com



Read my blog at: http://www.projectserverhelp.com/

Join the community at: http://forums.epmfaq.com