none
Project Server - 2007 - My tasks - table/view names RRS feed

  • Question

  • We would like to know the view name/table name(s) when user "Saves"   "My Tasks"? Also we are interested to know the table name/view name(s) when user "Submits" tasks.
    Sanjeev
    • Moved by Alexander.BurtonModerator Wednesday, February 23, 2011 10:00 PM Dev Question (From:Project Server - Setup, Upgrade, Administration and Operation)
    Wednesday, February 23, 2011 9:38 PM

Answers

  • Hi Sanjeev,

    this information is stored in dbo.MSP_ASSIGNMENTS_SAVED in Published DB. However, there are 2 reasons for not using: 1st are queries on DB other than Reporting not supported and 2nd is data stored in binary format, so not readable. If you want to read this data, you have to use PSI (Statusing Web Service).

    Regards
    Barbara

    • Marked as answer by Sanjeev S K Thursday, March 3, 2011 5:53 PM
    Thursday, February 24, 2011 6:26 AM
    Moderator

All replies

  • Hi Sanjeev,

    this information is stored in dbo.MSP_ASSIGNMENTS_SAVED in Published DB. However, there are 2 reasons for not using: 1st are queries on DB other than Reporting not supported and 2nd is data stored in binary format, so not readable. If you want to read this data, you have to use PSI (Statusing Web Service).

    Regards
    Barbara

    • Marked as answer by Sanjeev S K Thursday, March 3, 2011 5:53 PM
    Thursday, February 24, 2011 6:26 AM
    Moderator
  • Use MSP_ASSIGNMENT_TRANSACTIONS in the Published database.  Not all of the data is in binary format - you can get things like who submitted, when it was submitted, the state, etc.   Unfortunately the details of the update - eg task start finish hours - are in the binary data. 

    Saved and Submitted updates are both stored in the same table, it's the enums that tell you which is which.

    I referred to this blog post to create a report on this info.

    http://blogs.msdn.com/b/project_programmability/archive/2008/01/03/statusing-transactions-partial-documentation.aspx


    Terrie T - MCTS - PMP - MBA****PMO & Project Server Admin
    Thursday, February 24, 2011 2:22 PM
  • Hi Terrie,

    you are completely correct. Status, dates, ... of updates can be retrieved from this table. But the most interesting part (hours per day) is stored in binary format.

    Regards
    Barbara

     

    Thursday, February 24, 2011 2:36 PM
    Moderator