Reporting on Resources' Actual Work

B

Brian

Hi, I'm new to the DB side of MS Project server, so I have a question. If I
wanted to write a query that would return the actual work submitted by all
resources in a given week, which tables would I used? Does the
"AssignmentTimeActualWork" field in the "MSP_VIEW_PROJ_ASSN_TP_BY_DAY" table
store this?

Thanks,
Brian
 
G

Gary L. Chefetz [MVP]

Brian:

I think you'll want to query MSP_Web_Work. You should note that the data
dictionaries for Project and Project Server are located in the help
directory of your Project Server installation. These will provide tremendous
help.
 

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

Resource name inside resource sheet: per person, work per hours per week 0
Report of Actual Hours by Day by Resource 9
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Display weeks from a Milestone 0
Resource Pool changes actual hours in 2010 0
Missing Data in AssignmentTimeActualWorkProtected DB field 0
How to see Actual work data before it is published? 3
Level resource allocation error 1

Top