2007 Database question: Where is the team?

J

James Fraser

Related to a thread from yesterday, has anyone found the resource list
for a project team in the databases, reporting or otherwise?

I can easily get enterprise resources with assignments, but what about
resources without assignments or local resources?


Any leads appreciated...
James Fraser
 
P

Paul Conroy

I'm guessing as I don't have a DB in front of me to check.

MSP_Resources in the Published DB.

I doubt it would be in the Reporting DB.
 
J

James Fraser

I'm guessing as I don't have a DB in front of me to check.

MSP_Resources in the Published DB.

Makes sense, but doesn't seem to be the case.It's in there in 2003 but
in 2007, that table only has each Enterprise resource listed once and
doesn't indicate what projects they are associated with. I haven't
found local resources in the DBs at all yet

Any more ideas?


James Fraser
 
P

Paul Conroy

MSP_Project_Resource (published db) where RES_IS_Enterprise = True

Joined with MSP_Project on Proj_UID

Check to see if local resources are stored in the same tabel.

Paul
 
J

James Fraser

MSP_Project_Resource (published db) where RES_IS_Enterprise = True

Joined with MSP_Project on Proj_UID

Yes! That's exactly it.

MSP_PROJECT_RESOURCES is similar to 2003 MSP_RESOURCES. They both
include local resources.


Thanks...
James Fraser
 
Top