Project ID field and WSS content DB links in Project Server 2007

[EPM Consultant]

I am creating a SSRS report to show some SharePoint data (some customized
lists like Lesson learned, Meeting minutes etc data). I am not seeing any
table either in Publish or Reporting database that shows any any ties with
the relavent Project ID. It seems that Project workspace is not tied up with
Project_ID in Project Server 2007 anywhere as it was in version 2003.

I can use tp_dir field in Usersdata table in Content database that shows the
URL and it is working fine but how to handle it in case if we rename a
project from ProjectA to ProjectB and the URL will show the old ProjectA to
show the SharePoint data.

I would appreciate for your earliest response...

Thanks,
EPM Consultant

 

[Roy G]

Hi,
In Project 2007 the unique identifier of a Project entitiy (Project, Task,
Resource or Assignment) is its GUID. so in Published DB you should look for
PROJ_UID and in Reporting DB it's ProjectUID that you're after.

HTH,
Roy

 

[EPM Consultant]

Thanks for your response! I understand that but again what I wanted to know
as below

How can I find a table/view either in Publish/Reporting DB or WSS Content
database that shows both Proj_uid or Projectuid and a url that shows the
relavent project team site in one table or views?

 

[Roy G]

in Published DB - MSP_PROJECTS.WPROJ_STS_SUBWEB_NAME
in Reporting DB - MSP_EpmProject_UserView.ProjectWorkspaceInternalHRef

 

[EPM Consultant]

Thanks a lot! it was exactly what i was looking for....

 

[Steve P]

What about in Content DB



Roy wrote:

RE: Project ID field and WSS content DB links in Project Server 20
16-Mar-09

in Published DB - MSP_PROJECTS.WPROJ_STS_SUBWEB_NAM
in Reporting DB - MSP_EpmProject_UserView.ProjectWorkspaceInternalHRe

:

Previous Posts In This Thread:

Project ID field and WSS content DB links in Project Server 2007
I am creating a SSRS report to show some SharePoint data (some customized
lists like Lesson learned, Meeting minutes etc data). I am not seeing any
table either in Publish or Reporting database that shows any any ties with
the relavent Project ID. It seems that Project workspace is not tied up with
Project_ID in Project Server 2007 anywhere as it was in version 2003.

I can use tp_dir field in Usersdata table in Content database that shows the
URL and it is working fine but how to handle it in case if we rename a
project from ProjectA to ProjectB and the URL will show the old ProjectA to
show the SharePoint data

I would appreciate for your earliest response..

Thanks
EPM Consultant

RE: Project ID field and WSS content DB links in Project Server 2007
Hi
In Project 2007 the unique identifier of a Project entitiy (Project, Task,
Resource or Assignment) is its GUID. so in Published DB you should look for
PROJ_UID and in Reporting DB it's ProjectUID that you're after

HTH
Ro

:

RE: Project ID field and WSS content DB links in Project Server 20
Thanks for your response! I understand that but again what I wanted to know
as belo

How can I find a table/view either in Publish/Reporting DB or WSS Content
database that shows both Proj_uid or Projectuid and a url that shows the
relavent project team site in one table or views

:

RE: Project ID field and WSS content DB links in Project Server 20
in Published DB - MSP_PROJECTS.WPROJ_STS_SUBWEB_NAM
in Reporting DB - MSP_EpmProject_UserView.ProjectWorkspaceInternalHRe

:

RE: Project ID field and WSS content DB links in Project Server 20
Thanks a lot! it was exactly what i was looking for...


:

EggHeadCafe - Software Developer Portal of Choice
Xcompress - IIS HTTP Compression
http://www.eggheadcafe.com/tutorial...c7-861a0909f404/xcompress--iis-http-comp.aspx