Accessing enterprise custome fields (2007) using a SQL query

[SharkTracker]

Does anyone have a simple sqL query that shows how to access an enterprise
custom field in the Reporting database. I have tried to follows some of the
SQL queries in some of the views but can not seem to get it to work.

 

[Gokul]

Does anyone have a simple sqL query that shows how to access an enterprise
custom field in the Reporting database. I have tried to follows some of the
SQL queries in some of the views but can not seem to get it to work.

Hi Sharktracker,

Browse the tables from the Reporting database, MSP_EPMProject ; you
should be able to get the custom fields.

Best Regards,
Gokul Rajan

 

[Jonathan Sofer [MVP]]

All custom fields are nicely laid out for you in the reporting database at
the end of the ...UserViews.

So for Project, Resources, Tasks and Assignment level custom fields use the
following views in the reporting database:

SELECT *
FROM MSP_EpmProject_UserView

SELECT *
FROM MSP_EpmResource_UserView

SELECT *
FROM MSP_EpmTask_UserView

SELECT *
FROM MSP_EpmAssignment_UserView