MSP_VIEW_PROJ_TASK_TP_BY_DAY

[Yoav]

I'm working on Project Server 2003.
In the SQL DB there is a table called MSP_VIEW_PROJ_TASK_TP_BY_DAY, which
contains published working hours per day.
Where can I find SAVED working hours per day?

 

[Rod Gill]

They are in the main tables, but not in a format that is easy to use. The
MSP_VIEW tables are recommended and are the equivalent to the reporting db
in PS 2007.

--

Rod Gill
Microsoft MVP for Project

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

 

[Yoav]

The thing is I want to extract saved data and not published data. The PMs
often forget to publish their projects which lead to presenting incorrect
data.
Can you please refer me to the relevant tables? I couldn't find them
Thanks,
Yoav

 

[Rod Gill]

Get the Project SDK. Note that the db structure may change after any Service
Pack, but View Tables won't. What you have is a process and training
problem. If PMs won't publish, then you may need to force publish by
creating a macro to read and publish all projects from one PC using project
pro.

--

Rod Gill
Microsoft MVP for Project

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