A
Anatess
Hi all -
I'm on MS Project Server 2003. I'm trying to create an external report via
SQL queries to show some Resource Information. The exact field I'm looking
for is Resource Availability From and To Dates. Looking at MSP_RESOURCES, I
see the fields RES_AVAIL_FROM and RES_AVAIL_TO which seems to be what I'm
looking for. But, resource info is by project. I see a record for Proj_ID =
1. This looks like non-project-specific information being stored in this
record and there is a RES_AVAIL_FROM and RES_AVAIL_TO value on it as well,
except, it is not current. We have a resource that has 2 Resource
Availability entries on the Enterprise Resource Pool General Tab and the
value in Proj_ID = 1 record shows only the first line. When we save a
project with the resource in it, it updates the availability data on the
project resource record, but Proj_ID = 1 remained the same. Is there a place
in the database where I can grab resource availability data regardless of
project?
Thanks.
I'm on MS Project Server 2003. I'm trying to create an external report via
SQL queries to show some Resource Information. The exact field I'm looking
for is Resource Availability From and To Dates. Looking at MSP_RESOURCES, I
see the fields RES_AVAIL_FROM and RES_AVAIL_TO which seems to be what I'm
looking for. But, resource info is by project. I see a record for Proj_ID =
1. This looks like non-project-specific information being stored in this
record and there is a RES_AVAIL_FROM and RES_AVAIL_TO value on it as well,
except, it is not current. We have a resource that has 2 Resource
Availability entries on the Enterprise Resource Pool General Tab and the
value in Proj_ID = 1 record shows only the first line. When we save a
project with the resource in it, it updates the availability data on the
project resource record, but Proj_ID = 1 remained the same. Is there a place
in the database where I can grab resource availability data regardless of
project?
Thanks.