Enterprise Project Types in the Project Server 2010 Reporting Database

Recently I was asked where the Enterprise Project Types are stored in the Project Server Database, as my colleague couldn’t see them in the expected MSP_EpmProject_UserView location within the Reporting Database. The data in question actually sits in the MSP_EpmEnterpriseProjectType table.

Here is a query I wrote which will bring them out;

SELECT
MSP_EpmProject_UserView.ProjectName,
MSP_EpmEnterpriseProjectType.EnterpriseProjectTypeName

FROM
MSP_EpmProject_UserView
INNER JOIN
MSP_EpmEnterpriseProjectType ON MSP_EpmProject_UserView.EnterpriseProjectTypeUID = MSP_EpmEnterpriseProjectType.EnterpriseProjectTypeUID

2 comments

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s