• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1079
  • Last Modified:

Query from Project server 2007 Database to get actual Work

Hi Experts:
I am new to Project server 2007 and i am working to create a text file from the Project server Database with some fields in it. The fields contain Different Projects with different people working on a project and their actual work on it.
Can someone help me in getting the query from the Database to Select the actual work for each project Resource. I am not able to find the table where i can query this.

1 Solution
I can give you a start.

If you are looking for time that has been accepted into a project plan and republished, you will probably be most interested in the reporting database. Take a look at the Views, particularly the MSP_EpmTaskByDay_UserView.

If you need to look at task updates before acceptance, you've got a much harder path ahead. The task updates are only stored as binary objects in the Published database, MSP_ASSIGNMENT_TRANSACTIONS in the ASSN_CHANGE_DATA column.

James Fraser
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now