RBS & MS Query

[Vinnyliphoo1]

Hi There

I'm trying to run an MS Query so that I can pull data from the Project
Server 2003 into an Excel 2007 worksheet.

Could someone tell me how to pull the RBS data for a resource onto the
XLS?

Thanks in Advance.

I'm a novice at MS Query & SQL so please be gentle with the response!

 

[Jonathan Sofer [MVP]]

I can give you the query you need to pull the data from the ProjectServer
database. It is:

SELECT dbo.MSP_PROJECTS.PROJ_ID, dbo.MSP_PROJECTS.PROJ_NAME,
dbo.MSP_RESOURCES.RES_NAME, dbo.MSP_OUTLINE_CODES.OC_NAME,
dbo.MSP_OUTLINE_CODES.OC_CACHED_FULL_NAME,
dbo.MSP_OUTLINE_CODES.OC_DESCRIPTION
FROM dbo.MSP_RESOURCES INNER JOIN
dbo.MSP_PROJECTS ON dbo.MSP_RESOURCES.PROJ_ID =
dbo.MSP_PROJECTS.PROJ_ID INNER JOIN
dbo.MSP_PROJECTS MSP_PROJECTS_1 INNER JOIN
dbo.MSP_CODE_FIELDS INNER JOIN
dbo.MSP_OUTLINE_CODES ON
dbo.MSP_CODE_FIELDS.CODE_FIELD_ID = dbo.MSP_OUTLINE_CODES.OC_FIELD_ID AND
dbo.MSP_CODE_FIELDS.CODE_UID =
dbo.MSP_OUTLINE_CODES.CODE_UID ON
MSP_PROJECTS_1.PROJ_ID = dbo.MSP_OUTLINE_CODES.PROJ_ID
ON
dbo.MSP_RESOURCES.RES_UID =
dbo.MSP_CODE_FIELDS.CODE_REF_UID AND
dbo.MSP_RESOURCES.PROJ_ID =
dbo.MSP_CODE_FIELDS.PROJ_ID
WHERE (MSP_PROJECTS_1.PROJ_TYPE = 2) AND (dbo.MSP_PROJECTS.PROJ_ID = 1)
AND (dbo.MSP_CODE_FIELDS.CODE_CATEGORY = 1) AND
(dbo.MSP_OUTLINE_CODES.OC_FIELD_ID = 205521540)

205521540 is the code for the RBS field. This will return the leaf value
and the full value of the RBS for each resource in the Enterprise Resource
Pool.

Hope this helps,

Jonathan Sofer