Project Server 2010: How to access task text fields like "text1" via SQL? RRS feed

  • Question

  • Hallo,

    for a report in the reporting service I am retrieving task information via SQL.

    So fare I have failed to find the values for the build-in task text fields/attributes like "text1" .
    Can anyone tell me in which table I can find these values?


    Thursday, May 24, 2012 11:11 AM

All replies

  • Hi pmruk--

    If you have the Task level enterprise custom text field created & you assign the text, save/publish the project . The reporting database view will be updated for MSP_EpmTask_UserView & add the custom field as a column. It will be easy for you to query the reporting database. You can downlaod the project 2010 SDK for reporting database schema.

    --Suppose the Task level enterprise custom field name is Schedule Status
    select projectuid, TaskUid, [Schedule Status] 
    from  dbo.MSP_EpmTask_UserView

    Local fields like Text1, 2 etc are not stored in projects erver reporting database.

    Does that help?

    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Amit Khare |EPM Consultant| Blog:

    Thursday, May 24, 2012 11:42 AM