prgrammatically extract project work by month?

K

Kris Rudin

We need to programmatically extract data from the project server database
such that we can get the number of work hours for each calendar month for a
given project. If we have to get it task by task and sum it up, that is
fine. But we can't figure out how to get this from Project, via SQL. That
is, what tables would have this data, and how would we break it out?

We can see total work for any given task, and a task's start and finish
dates. But if we have a task starting 10/15 and ending 12/5, we need to know
how many Work hours are assigned for October (15-31), November (1-30) and
December (1-5). Or, for the entire project.

How do we get this?

This is NOT ACTUALS (as entered by user in PWA), so most of the references
to "time-phased" data I find at MSDN or in the documentation doesn't work
for us.

Who can help us?

Thanks.
 
G

Gary L. Chefetz

Kris:

For planned work, I thin the time-phased tables are your best bet.

--

Gary Chefetz [MVP]
http://www.msprojectexperts.com
"We wrote the book on Project Server"

*** Remember to look for line breaks in links posted to the news group, use
cut and paste for these.
 
H

Hugues Perron

Hi Kris,

I think the best way should be to use the Portfolio analyzer. With it you
can get whatever you want.

Hugues Perron
 
K

Kevin Flanagan

Kris-

If you extract the data from the MSP_TASKS table and set
the where clause for TASK_UID=0 you will get the Summary
Task information, which in effect is the Project level
information for a given project.

Kevin
 
K

Kris Rudin

The key word here (though misspelled!) was PROGRAMMATICALLY. We need to do
this via code, not interactively.

Kris
 
K

Kris Rudin

But that still won't tell us the hours assigned BY MONTH. That is what we
need, not the total over the life of the project, or the total over the life
of a task, but how many hours were scheduled, over the entire project, for a
SINGLE month.

Kris
 
K

Kris Rudin

Yes, but how do we get the hours for each project for each MONTH? The
timephased tables don't break it down into calendar month increments...

Kris
 
Top