SQL Query for actual hours worked by day including summary tasks

T

-Thomas

Hi everyone!

As the topic informs, I am desperately in the need of a query that gives me
the actual hours worked by every resource for a certain period of time. I am
perticularly interested in the summary task levels, because that is our
reporting level. We have a structure like follows:

Billable work(summary task)
Product1(task)
Product2(task)
Product3(task)

So our users report their hours to a certain product, but I want to get the
actual hours reported for the summary task(Billable work). I have tried many
queries obtained from this forum by altering them but haven't succeeded yet.

So basicly I want to get the same data from the query as I can get from PWA
in the "View resource assignments" section.

I am using project server 2003.

Any help would be greatly appreciated!
 
R

Rod Gill

I don't have PS 2003 available to play with at the moment, but the easiest
solution is to read from the MSP_VIEW tables. There is table with a record
of actual hours for each day there, so a query to sum them. I think the
MSP_VIEW_Task table has the name of the summary task so group by that field.

--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx
 
T

-Thomas

Hi Rod! Many thanks for your response!

I succeeded in getting the data I was interested in, however, my query still
lacks the time period functionality. What would be the easiest way to select
a certain time period just like in PWA by SQL?

For example, if I would like to know how many actual hours a certain
resource has reported in a month, how should I proceed? Any ideas on this?
-Thomas
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL Query for scheduled work hours by day 1
How to get TASK_ID field for summary tasks without using Project.a 2
Report View for Summary Tasks 5
How to write an MDX query to create a new Billed Hours measure? 0
Actual hours for task vs. Duration 2
how to display work by resource for a summary task 3
Summary roll up of actual hours worked by day??? 4
Recording Actual Hours Worked 4

Top