none
Project Priority in SQL database (Project Server 2010) RRS feed

  • Question

  • Hello,

    Where can we found the Project Priority in the SQL Server database for 2010 version?

    Thanks and regards

    Tuesday, January 19, 2016 6:37 PM

Answers

  • Hi,

    The Project Priority field is available in the 

    [dbo]

    .[MSP_EpmTask_UserView]

    And the project priority can be gathered from the following query :

    SELECT TaskName, TaskPriority
      FROM [ProjectServer_Reporting].[dbo].[MSP_EpmTask_UserView] where TaskIsProjectSummary = 1

    Thanks,

    A

    • Proposed as answer by Abhijit Wadagole Tuesday, January 19, 2016 7:57 PM
    • Marked as answer by WLID1966 Tuesday, January 19, 2016 8:36 PM
    Tuesday, January 19, 2016 7:57 PM

All replies

  • Hi,

    The Project Priority field is available in the 

    [dbo]

    .[MSP_EpmTask_UserView]

    And the project priority can be gathered from the following query :

    SELECT TaskName, TaskPriority
      FROM [ProjectServer_Reporting].[dbo].[MSP_EpmTask_UserView] where TaskIsProjectSummary = 1

    Thanks,

    A

    • Proposed as answer by Abhijit Wadagole Tuesday, January 19, 2016 7:57 PM
    • Marked as answer by WLID1966 Tuesday, January 19, 2016 8:36 PM
    Tuesday, January 19, 2016 7:57 PM
  • Great!

    Thanks a lot

    Tuesday, January 19, 2016 8:37 PM