Resources from Enterprise Resource Pool

A

Andrzej B³och

Hi.
I add new resource to Enterprise Resource Pool. Then I change work time of
the resource to some nondefault values and save the resource.
Is there any way to extract this data from ProjectServer database?
I can find some data in MSP_RESOURCES table (resource name, initials and so
on) , but
what about work time? I can't find it anywhere.

Any hints?
 
G

Garon Line

There is a DBSchema and Entity Relationship diagram in
the Project Server 2003 Resources (Downloads) section.

This may help. I have not had a chance to look through
it completely, so am not sure if it includes the
relationship to the Calendar tables.

You need to be looking for Views tables that are related
to the Resource Calendar (I believe)

Hope this gets you going in the right direction.

Regards
Garon
 

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

removing inactive resources from the enterprise resource pool 1
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Enterprise Resource Pool locked 1
Identifying resources in use from the Enterprise resource pool 3
Filter Enterprise Resource in Project Pro when trying to build tea 1
Project Server 2007 - Import Wizard Adds Resources to Enterprise 3
Convert Local Resources to Enterprise 5
Edits in Resource Enterprise Pool not reflected in Project Plans 1

Top