All tasks updated last week RRS feed

  • Question

  • Is there a way in Project Server 2010 to see all tasks that were updated last week?
    Wednesday, August 1, 2012 12:03 PM

All replies

  • Hi there--

    You may need to create a report & use the SQL query from Reporting database task user view. Please see a sample code. You can join with Project user view to get the Project Name & additional data.

    SELECT  [ProjectUID]
    FROM [MSP_EpmTask_UserView]
    Where TaskModifiedDate >= dateadd(day,datediff(day,0,GetDate())- 7,0)

    Hope that helps.

    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Amit Khare |EPM Consultant| Blog:

    Wednesday, August 1, 2012 12:12 PM
  • HFprojects --
    An alternate approach to Amit�??s excellent answer would be to create a Business Intelligence Center report using the Projects and Assignments template.  To create the PivotTable in the report, add the following fields to the Row Labels drop area:
    • ProjectName
    • TaskName
    • TaskModifiedDate
    If needed, you might also want to add the ResourceName field as well.  Click the Design tab to display the Design ribbon with the PivotTable Tools applied.  In the Layout section of the Design ribbon, click the Report Layout pick list button and select the Show in Tabular Form item.  Click the AutoFilter pick list button in the TaskModifiedDate column header, select the Date Fields item, and then select the This Week item on the flyout menu.  You now have a report that automatically shows any task updated during the current week, as per your reporting requirements.  Hope this helps.

    Dale A. Howard [MVP]
    VP of Educational Services
    "We write the books on Project Server"

    Wednesday, August 1, 2012 12:33 PM
  • Does that mean we can't get it as a view in PWA?
    Wednesday, August 1, 2012 12:48 PM