Where is the stakeholdher column?

[ryan_kelly]

A user has two reports where one is looking at the demand table and the other is looking at the projects table.  The user wants to add the stakeholder column to the list reports, but it's not available in the list when you modify columns.  How can I add the stakeholder column to reports that look at demands or projects?

[Namita Mishra · Accepted solution]

Hi @ryan_kelly ,

Thanks for contacting community.

Project stakeholder information is stored in pm_m2m_project_stakeholder 

Demand stakeholder information is stored in dmn_m2m_demand_stakeholder.

You can use these tables to get the report as shown in below screenshots.

Project Stakeholders 

Demand Stakeholders

 

Hope this solves the query. If it does, please mark it as correct answer.

Happy SPM Journey!!

Namita Mishra

[ryan_kelly]

Thank you! I'm new to this. Appreciate your help.