Report on local resources

[Vaso Vukovic]

Has anybody made a report (SQL SRS) that displays projects and full names of
local resources as they appear on the resource sheet in the MS Project
client?? If so, willing to share the db query ? )

When I look in to Reporting DB I can see something like Unassigned resource
where I have local resource.. I'm trying to oust usage of local resources
(yes I can prevent creation by security setting but before I do that I want
to capture one whihc already have it)

Regards,
Vaso

 

[Chak]

Hi Vaso,

You have to use Published database to query the local resource names.

(Note: Microsoft recommends only reporting database for query/
reporting purposes.)

Here is the SQL query to retrieve the local resource names used in all
the enterprise projects saved in Project Server 2007.

************************************************************

SELECT DISTINCT MSP_PROJECT_RESOURCES.PROJ_UID,
MSP_PROJECTS.PROJ_NAME,
MSP_PROJECT_RESOURCES.RES_NAME
FROM MSP_PROJECT_RESOURCES INNER JOIN
MSP_PROJECTS ON MSP_PROJECT_RESOURCES.PROJ_UID = MSP_PROJECTS.PROJ_UID
WHERE MSP_PROJECT_RESOURCES.RES_IS_ENTERPRISE_RESOURCE = 0 AND
MSP_PROJECT_RESOURCES.RES_NAME IS NOT NULL

********************************************************************

Thanks
Chak
pVector Technologies
http://www.pvectortech.com
http://www.epmcentral.com

 

[Vaso Vukovic]

Thanks Chak,

your query works like charm.

I was hoping that the data is in reporting db (can't see why not?) but this
will do!