Get Project Server List

[Tyler Durden]

Hi,
i'm looking for a simple code to get a list of projects stored on a project
server.
I only need the name and version of the projects.

Thanks in Advance

Tyler

 

[Jim Corbin [MSFT]]

You didn't specify which version of Project Server.

If for Project Server 2003, use the ProjectsVersion method in the PDS (
http://msdn2.microsoft.com/en-us/library/aa193323(office.11).aspx ). The SDK
download includes the PDSTest.NET sample application to easily try PDS
calls.

If for Project Server 2007, use the Project.ReadProjectList method in the
PSI (
http://msdn2.microsoft.com/en-us/library/websvcproject.project.readprojectlist.aspx )
to get the project name and GUID, if the user has admin permissions. If not,
use ReadProjectStatus. Follow that by the ReadProject or other methods if
you need other data. Project Server 2007 doesn't implement project versions,
although some folks add a custom field to emulate that.

--Jim

 

[Rod Gill]

Hi,

Jim's response is good if you have professional developers handy, otherwise
in 2003 use the MSP_VIEW tables in the database and in 2007 use the
mspProject_userview View in the reporting database.

Create a suitable View for your own use if wanted, then read directly from
SQL Server using oledb.

--

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