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

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

Answer 1

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?!

Regards
Wim

PS: I don't have the impression that this field is stored in the reporting DB...

Answer 2

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

Answer 3

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

Answer 4

Ahhhh yes of course it was Chrstophe's blog. How could I forget :) Thanks Prasanna :)

Marc

---

Marc Soester [MVP] http://marcsoester.blogspot.com

Answer 5

Thank you Wim/Marc/Prasanna,

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

Regards,

José Espases