This forum is closed. Thank you for your contributions.

Sign in

Microsoft.com

Microsoft

Remove From My Forums

Query Team Discussion Notes

Question
0

Sign in to vote

I am trying to query the team discussion notes from our Project Server 2010 sites, all projects. Can anyone point me in the right direction for finding the correct db and tables to retrieve the team discussion notes, the subject of the note, the date of the note and the user that created the note and last the project that the notes pertain to. I am new to project server and would like to write a sql query that I can run to gather all of the notes from every project site. Any assistance would be greatly appreciated. Thanks

Tuesday, February 10, 2015 4:59 PM

Answers

0

Sign in to vote
Hello,

It is not supported to query the database that stores that data. That data is stored in the SharePoint content database. To programmatically access that data you need to use the SharePoint APIs - web services / CSOM /JSOM / REST.

The answer is still the same from when you asked this question last year:

https://social.technet.microsoft.com/Forums/windowsserver/en-US/276aef6f-79e3-45b9-8345-d8d1296949e2/sql-query-to-gather-team-discussion-notes?forum=projectserver2010general

Paul
Paul Mather | Twitter | http://pwmather.wordpress.com | CPS | MVP | Downloads
- Marked as answer by PWMatherMVP Wednesday, April 6, 2016 10:32 AM
Tuesday, February 10, 2015 5:42 PM

All replies

0

Sign in to vote
Hello,

It is not supported to query the database that stores that data. That data is stored in the SharePoint content database. To programmatically access that data you need to use the SharePoint APIs - web services / CSOM /JSOM / REST.

The answer is still the same from when you asked this question last year:

https://social.technet.microsoft.com/Forums/windowsserver/en-US/276aef6f-79e3-45b9-8345-d8d1296949e2/sql-query-to-gather-team-discussion-notes?forum=projectserver2010general

Paul
Paul Mather | Twitter | http://pwmather.wordpress.com | CPS | MVP | Downloads
- Marked as answer by PWMatherMVP Wednesday, April 6, 2016 10:32 AM
Tuesday, February 10, 2015 5:42 PM
0

Sign in to vote
Sorry for the second post. Forgot I put that out there. I am not a developer and am still looking to get that data out. Would you please explain what I might need to look for in a contractor to get this for us if possible? Thanks
- Edited by Circa62 Tuesday, February 10, 2015 6:06 PM
Tuesday, February 10, 2015 6:01 PM