Answered by:
Date when fields were modified

Question
-
We use Project Server 2013 and Project Professional 2013.
We have three projects, each in a file of its own. It isn't convenient to put all the projects into a Master file and using external links doesn't always work after doing Resource Levelling.
Each project owner would like to see when the Finish date or the % Complete of various tasks are modified in the other projects.
The easiest would be if we could see "Date last changed" of the Finish and/or % Complete fields. Can this be done in project server?
Monday, February 6, 2017 8:10 AM
Answers
-
Hello,
Yes you can create an Excel report and make it available in Excel Services for you users to consume. Ensure you have set up the reporting requirements for PWA 2013 for this to work:
https://technet.microsoft.com/en-us/library/ee662106.aspx
Paul Mather | Twitter | http://pwmather.wordpress.com | CPS | MVP | Downloads
- Marked as answer by HFprojects Monday, February 6, 2017 1:43 PM
Monday, February 6, 2017 12:40 PM
All replies
-
Hello,
You can't see when particular fields or properties are modified for a task but you can see when the Tasks are modified using the Project Web App database:
Select Taskname , TaskFinishDate , TaskPercentCompleted , TaskModifiedDate From MSP_EpmTask_UserView
PaulPaul Mather | Twitter | http://pwmather.wordpress.com | CPS | MVP | Downloads
Monday, February 6, 2017 9:51 AM -
Thank you for the reply, Paul.
Is it possible to make this query available through the PWA frontend as a report, as our users don't have access to the PWA database?
Monday, February 6, 2017 12:29 PM -
Hello,
Yes you can create an Excel report and make it available in Excel Services for you users to consume. Ensure you have set up the reporting requirements for PWA 2013 for this to work:
https://technet.microsoft.com/en-us/library/ee662106.aspx
Paul Mather | Twitter | http://pwmather.wordpress.com | CPS | MVP | Downloads
- Marked as answer by HFprojects Monday, February 6, 2017 1:43 PM
Monday, February 6, 2017 12:40 PM