In Project Server 2013 and Project Server 2016 linking documents to other project site items is not as clear as it used to be back in the 2010 days. Brian Smith has a blog article on this:
However, it's not clear how to report on this items.
I need to create a report (Excel and/or SSRS) to show which tasks have linked documents.
How can I create such report?
Here is an example SQL query those shows documents that are linked to Issue items, this could easily be changed to show documents linked to Tasks on the Task list on the project site:
, D.Title as [Document Title]
, P2.ProjectName as [Related Project Name]
, I.Title as [Issue Title]
, RT.Description as [Relationship Type]
From MSP_WssDocument D
INNER JOIN MSP_WssListItemAssociation LA
ON LA.ListItemUID = D.DocumentUniqueID
INNER JOIN MSP_WssRelationshipType RT
ON RT.RelationshipTypeID = LA.RelationshipTypeID
INNER JOIN MSP_WssIssue I
ON I.IssueUniqueID = LA.RelatedItemUID
INNER JOIN MSP_EpmProject P
ON P.ProjectUID = D.ProjectUID
INNER JOIN MSP_EpmProject P2
ON P2.ProjectUID = LA.RelatedProjectUID
where LA.RelationshipTypeID = '24'
Paul Mather | Twitter |
http://pwmather.wordpress.com | CPS |
MVP | Downloads
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?