Custom pws how to determine proj_uid

[winnes]

Having a customised project workspace.
In which number of additional custom lists are located.
Would need the project guid in these lists...
Now facing the problem that in en event receiver on these lists, need to
reference to the correct project.

Any ideas?

 

[Stephen Sanderlin [MVP]]

I would suggest executing the following query against Project Server's RDB:

SELECT
MEP.ProjectUID
FROM
MSP_EpmProject MEP
WHERE
MEP.ProjectWorkspaceInternalHref = 'http://url/to/workspace'

Replace http://url/to/workspace with something like http://int/pwa/Test.
This will return the Project GUID. Remember to leave the trailing slash off
the workspace URL.

--
Stephen Sanderlin, Project MVP
VP of Technology
MSProjectExperts

For Project Server Consulting: http://www.msprojectexperts.com
For Project Server Training: http://www.projectservertraining.com

Read our blog at: http://www.projectserverhelp.com

Learn | Connect | Grow @ The Microsoft Project Conference Phoenix, AZ -
September 14-17, 2009

 

[winnes]

Stephen,

I could have guessed you would be the first one to answer.
Meanwhile I also did my own research and thought of this query:

select proj_uid
from msp_projects
where wproj_sts_subweb_name=... , or proj_session_description = ...

of course I would use the PSI for this
But I see your suggestion needs no fiddling the url, but is against the
reporting db, which I do not know that well...

But again, great help, thanks a lot