Finding out who the current project owner is

T

Traci

I am interested in knowing if there is a SQL query or some other way to
extract who the current project owner is. I'm already aware that you can
check Web Access, however that information will only be as good as the last
person that manually changed that information...as it does not change
automatically if the project is republished and someone else takes ownership
of the project. If someone does not go out to Web Access and make that
update in ownership change, it will show the original owner. So, I'm looking
for another way to find out who the current owner of a project is within the
system. This question was already posted on the Server section and it was
suggested by one of the Microsoft MVPs to post it here. Any suggestions on
how I can extract this information?
 
R

Rod Gill

From the pjsvrdb.htm file (in one of Project's program folders this SQL
query returns a list of projects and their PMs:

select
PROJ_NAME as Project,
RES_NAME as Project_Manager,
(select count(*) from MSP_WEB_ASSIGNMENTS a
where a.WPROJ_ID = p.WPROJ_ID) as Assignments
from
MSP_WEB_PROJECTS p,
MSP_WEB_RESOURCES r
where
p.WRES_ID = r.WRES_ID
and p.WPROJ_ID <> 1
order by
PROJ_NAME,
RES_NAME


--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx
 
T

Traci

Excellent. Thank you Rod!

Rod Gill said:
From the pjsvrdb.htm file (in one of Project's program folders this SQL
query returns a list of projects and their PMs:

select
PROJ_NAME as Project,
RES_NAME as Project_Manager,
(select count(*) from MSP_WEB_ASSIGNMENTS a
where a.WPROJ_ID = p.WPROJ_ID) as Assignments
from
MSP_WEB_PROJECTS p,
MSP_WEB_RESOURCES r
where
p.WRES_ID = r.WRES_ID
and p.WPROJ_ID <> 1
order by
PROJ_NAME,
RES_NAME


--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Lock File .LACCDB / Now shows as a notepad file 0
How do I retrieve the current Project Owner value 0
Modify the gantt chart view in project center (WPA) (MS Project 2010) 0
ProjectServer2003/PWA2003 - Changing Project Ownership 1
Need some PWA help 0
Change Project Owner 2
MS Project. Real progress of the project, % complete 1
Dynamic Naming of Form Button 3

Top