SQL Query to find out local resources ?

F

FlyingNavi

Hello, can anybody send me a SQL String, I would find out in which project
are local resources includes.

Thanks a lot.
 
J

James Fraser

Hello, can anybody send me a SQL String, I would find out in which project
are local resources includes.

Thanks a lot.
Click to expand...


If for 2003, take a look at the help files installed with the server.
I think the file name is pjdb.htm and pjsrv.htm or somthing similar.
That has the database schema included. If 2007, download the SDK and
use the reporting database. (I think this info is in the reporting
database, but I'm not sure.)

Certainly on 2003, this is an easy query. I think the key field is
res_type, IIRC.


James Fraser
 
J

Jonathan Sofer

FYI, in 2007, if you are looking to show resources that are just added to
the project team but have no assignments, you will only be able to get that
from the Published DB from the MSP_PROJECT_RESOURCES table. It does not
exist on the Reporting database.

SELECT dbo.MSP_PROJECTS.PROJ_NAME, dbo.MSP_PROJECT_RESOURCES.RES_NAME,
dbo.MSP_PROJECT_RESOURCES.RES_TYPE,
dbo.MSP_PROJECT_RESOURCES.RES_WORK
FROM dbo.MSP_PROJECT_RESOURCES INNER JOIN
dbo.MSP_PROJECTS ON dbo.MSP_PROJECT_RESOURCES.PROJ_UID
= dbo.MSP_PROJECTS.PROJ_UID

Jonathan
 
Top