[PS7] Print the RBS

[CQ]

I have Project Server 2007. I want to print the entire RBS. I don't see a
way to export it from PWA. Not every single level or every RBS is used so
going to the Resource Pool and sorting there won't work either. I can't seem
to create a view that shows me the RBS either. The lookup table won't let me
copy paste from PWA (it only copies one row at a time). How do I do this?

 

[Marc Soester [MVP]]

CQ,

yeah I now what you mean, unfortunalty there is not easy way. You could get
the list out of the Project Server database. That is way I get the values ot
of PS Custom fields.
hope this helps

 

[Jonathan Sofer]

Specifically use this query on the published database, you can then copy and
paste this into excel.

SELECT TOP (100) PERCENT MSP_LOOKUP_TABLES.LT_NAME AS CUSTOM_FIELD_NAME,
MSP_LOOKUP_TABLE_VALUES.LT_VALUE_TEXT AS VALUE,
MSP_LOOKUP_TABLE_VALUES.LT_VALUE_FULL AS Expr1
FROM MSP_LOOKUP_TABLE_VALUES INNER JOIN
MSP_LOOKUP_TABLES ON MSP_LOOKUP_TABLE_VALUES.LT_UID =
MSP_LOOKUP_TABLES.LT_UID
WHERE (MSP_LOOKUP_TABLES.LT_NAME = 'RBS')
ORDER BY CUSTOM_FIELD_NAME, MSP_LOOKUP_TABLE_VALUES.LT_VALUE_SORT_INDEX