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
 
Top