Where do I find the column Task Notes in the Reporting Database? RRS feed

  • Question

  • Hi,

    I'm using Project Server 2010 and I would like to be able to select the information registered in the column Task Notes, I'm able to insert this column in Microsoft Project Professional 2010 (it's name is 'Notes'), but I need to put this information in another report fed by an SQL Query script, and I don't know where to find this information, I've been looking for it in PWA_ProjectServer_Reporting database view MSP_EpmTask_UserView, but I haven't found anything there.

    Do someone know where is located this column in the Reporting Database?

    Thank you for your help,

    José Espases

    Thursday, August 25, 2011 2:58 PM


All replies

  • Hello José,

    At first sight I cannot find the note field in the Reporting database,
    but in the Published database you can find it in the view "dbo.Task" in column [TASK_NOTES].

    Maybe this helps you for now?!


    PS: I don't have the impression that this field is stored in the reporting DB...
    Thursday, August 25, 2011 5:05 PM
  • Jose, Wim is right, the reporting database does not keep the comments of the notes. Sorry to say. You can get the data from the publsih database and I remember there is actually a blog out there somewhere that explains it. I tried to find it, but dont seem to be able to allocate it.
    Marc Soester [MVP] http://marcsoester.blogspot.com
    Thursday, August 25, 2011 10:31 PM
  • jose,

    here is the blog i think Marc is referring to: http://blogs.msdn.com/b/chrisfie/archive/2008/06/04/how-to-display-microsoft-project-task-s-notes-field-in-a-report.aspx

    Prasanna Adavi, PMP, MCTS http://thinkepm.blogspot.com
    Friday, August 26, 2011 2:47 AM
  • Ahhhh yes of course it was Chrstophe's blog. How could I forget :) Thanks Prasanna :)


    Marc Soester [MVP] http://marcsoester.blogspot.com
    Friday, August 26, 2011 3:24 AM
  • Thank you Wim/Marc/Prasanna,

    I read it from the Published DB and it works fine.


    José Espases

    Friday, August 26, 2011 7:26 AM