SQL Table were I found project Work

[Hernandezz]

Hi,

exists any table with total work by project in Project Server 2007 SQL
tables? I searched this but not founded.

thanks and best regards

 

[Chak]

Hi,

exists any table with total work by project in Project Server 2007 SQL
tables? I searched this but not founded.

thanks and best regards

Hello,

Do you mean total work by project or work by each resource in
project?

Thanks
Chak
http://www.epmcentral.com

 

[Hernandezz]

Hello,

Do you mean total work by project or work by each resource in
project?

Thanks
Chakhttp://www.epmcentral.com

Hi Chak.. I mean total work by project, total work in a project. If
not exists how I search this in SQL tables ? maybe by a view with the
sum of resources work?

 

[Chak]

Hi Chak.. I mean total work by project, total work in a project. If
not exists how I search this in SQL tables ? maybe by a view with the
sum of resources work?- Hide quoted text -

- Show quoted text -

Hello Hernandezz,

Run the following query, you will get total work by project. This
query will give all the column values that you see in PWA Project
Center.

***********************************************************************************************

SELECT MSP_EpmProject.ProjectName AS ProjectName,
MSP_EpmTask.TaskStartDate AS Start,
MSP_EpmTask.TaskFinishDate AS Finish,
MSP_EpmTask.TaskPercentCompleted AS '%Complete',
MSP_EpmTask.TaskWork AS WorkinHrs,
MSP_EpmTask.TaskActualWork AS ActualWorkinHrs,
MSP_EpmTask.TaskDuration/8 AS DurationDays,
MSP_EpmTask.TaskPercentWorkCompleted AS '%WorkComplete',
MSP_EpmResource.ResourceName AS Owner
FROM MSP_EpmTask INNER JOIN
MSP_EpmProject ON MSP_EpmTask.ProjectUID = MSP_EpmProject.ProjectUID
INNER JOIN
MSP_EpmResource ON MSP_EpmProject.ProjectOwnerResourceUID =
MSP_EpmResource.ResourceUID
WHERE (MSP_EpmTask.TaskOutlineLevel = 0) AND
(MSP_EpmTask.TaskOutlineNumber = 0)

*******************************************************************************************************************

Thanks
Chak
http://www.epmcentral.com

 

[Chak]

Hello Hernandezz,

   Run the following query, you will get total work by project. This
query will give all the column values that you see in PWA Project
Center.

***************************************************************************­********************

SELECT MSP_EpmProject.ProjectName AS ProjectName,
MSP_EpmTask.TaskStartDate AS Start,
MSP_EpmTask.TaskFinishDate AS Finish,
MSP_EpmTask.TaskPercentCompleted AS '%Complete',
MSP_EpmTask.TaskWork AS WorkinHrs,
MSP_EpmTask.TaskActualWork AS ActualWorkinHrs,
MSP_EpmTask.TaskDuration/8 AS DurationDays,
MSP_EpmTask.TaskPercentWorkCompleted AS '%WorkComplete',
MSP_EpmResource.ResourceName AS Owner
FROM  MSP_EpmTask INNER JOIN
MSP_EpmProject ON MSP_EpmTask.ProjectUID = MSP_EpmProject.ProjectUID
INNER JOIN
MSP_EpmResource ON MSP_EpmProject.ProjectOwnerResourceUID =
MSP_EpmResource.ResourceUID
WHERE (MSP_EpmTask.TaskOutlineLevel = 0) AND
(MSP_EpmTask.TaskOutlineNumber = 0)

***************************************************************************­****************************************

Thanks
Chakhttp://www.epmcentral.com- Hide quoted text -

- Show quoted text -

Hello,

I forgot to mention, please run the above query against Reporting
database.
Please look for WorkinHrs column in query result, which is total work
of the project.

Thanks
Chak
http://www.epmcentral.com