Query for Resource Assignment - Summary

A

Ashish kanoongo

Hello

Can anyone tell me SQL query for 'Summary' view for Resoirce Assignment?

Ashish
 
A

Adam Behrle

Hey Ashish,

If by summary information of assignments you mean non-time phased
data, you could check out the MSP_VIEW_PROJ_ASSN_STD table. A catch
however is it is reliant on successful project publishes, being a view
table.

Hope that helps,

Adam
 
A

Ashish kanoongo

Adam

Sorry this table is not worlable for me. If you can tell me how can I
generate a sql using 'Summary' view of Resource-Assignment', it will be very
helpful for me?

Ashish
 
A

Adam Behrle

Forgive me Ashish, but I'm not sure exactly what you mean by 'Summary'
view of Resource-Assignments. Perhaps the SQL queries for extracting
timephased data included in the SDK would help?

Check out the article "Extracting Timephased Data from the Microsoft
Office Project 2003 or Project Server 2003 Database" on MSDN:
http://msdn2.microsoft.com/en-us/library/aa208968(office.11).aspx

You might need to tweak them to get what you want, but hopefully they
get you started.

Adam
 

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

Incone & Expenses Statement 0
Resource Budget Cost - Tracking 0
I am trying to assign resources to tasks but the 'Assign Resources' is greyed out on the Resource tab. 0
Assign Formatted Block of Text to Theme 0
Resource name inside resource sheet: per person, work per hours per week 0
How to implement two shifts per day with multiple teams 0
Using Flags with Resource Percentages 0
How to create visual report that combines resource remaining workacross multiple summary tasks 0

Top