RBS Field

[Kathy S]

Does anyone know which table the RBS data is stored in in MSP 2003
Project Server? I need a SQL query which will refer to data from the
RBS field for resources.

Thanks,
Kathy

 

[Gérard Ducouret]

Kathy,

In the Project Server 2003 database you will find the table:
MSP_VIEW_RES_ENT with the fields :
- ResourceEnterpriseOutlineCode30ID
- ENT_ResourceUniqueID
In the MSP_WEB_RESOUCES table you will find the fields:
-WRES_ID
- RES_NAME
- WRES_RBS_UID

Hope this helps,

Gérard Ducouret

 

[Kathy S]

Kathy,

In the Project Server 2003 database you will find the table:
MSP_VIEW_RES_ENT with the fields :
 - ResourceEnterpriseOutlineCode30ID
 - ENT_ResourceUniqueID
In the MSP_WEB_RESOUCES table you will find the fields:
  -WRES_ID
 - RES_NAME
 - WRES_RBS_UID

Hope this helps,

Gérard Ducouret

"Kathy S" <[email protected]> a écrit dans le message de (e-mail address removed)...





- Show quoted text -

Thank you for the information.

 

[Gérard Ducouret]

In the MSP_WEB_RESOURCES table ....