Sql table with total work by project

[Hernandezz]

Hello

You know if exists any table with total Work by Project in Proj.
Server 2007 SQL
tables? I searched this but I not founded.

best regards

 

[Rod Gill]

HI,

Please post Project Server related questions in the Project Server group,

To answer your question, create a View in SQL Server that reads the
MSP_EpmTask_UserView view and only shows tasks with TaskIndex=0. These are
the ProejctSummary tasks and include total work for the project. The
MSP_EpmTask_UserView is useful because it has all project custom fields as
extra columns at the end.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

 

[Hernandezz]

HI,

Please post Project Server related questions in the Project Server group,

To answer your question, create a View in SQL Server that reads the
MSP_EpmTask_UserView view and only shows tasks with TaskIndex=0. These are
the ProejctSummary tasks and include total work for the project. The
MSP_EpmTask_UserView is useful because it has all project custom fields as
extra columns at the end.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:http://www.projectvbabook.com

Hi Rod.., lots of thanks...You help me a lot...this view works..
Exists any book or page in internet with explanation about
projectserver 2007 SQL tables and views? I know exists with
explanation about databases, but I not founded about tables and
views...

thanks

 

[Rod Gill]

Hi,

All tables and Views in the Reporting database are explained in the Project
SDK you can download free from MSDN. The tables and views in the other
databases are not described anywhere as Microsoft does not what them used as
they reserve the right to modify them in any hotfix or service pack.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

 

[Hernandezz]

Hi,

All tables and Views in the Reporting database are explained in the Project
SDK you can download free from MSDN. The tables and views in the other
databases are not described anywhere as Microsoft does not what them used as
they reserve the right to modify them in any hotfix or service pack.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:http://www.projectvbabook.com

OK..thanks..

best regards

PS. I have your book, congratulations it's very good e complete.