TFS 2015 | TFS 2013
TFS 2017 and later versions no longer support native integration with Microsoft Project Server. If you upgrade to TFS 2017 or want to use a third party option, see Synchronize TFS with Project Server.
As a team lead, you may want to create several work item queries to monitor the status of work items that were submitted to Microsoft Project Server for participation in data synchronization. You can use the queries that are described in this topic to list blocked or rejected work items and then perform the corrective actions to resolve the blocks and rejections.
In addition to the work item fields that appear on the Project Server tab for a work item, you can use several more to find work items.
To perform these procedures, you must be a member of the Readers group or your View work items in this node permission must be set to Allow. For more information, see Permission reference.
Find and Resolve Work Items That Are Blocked from Being Submitted to Project Server
To find work items that were previously submitted to Project Server but are now blocked, you can create the following query. This query finds all work items for which the Project Server Last Submit Status field is set to Failure. You can filter the list by Area or Iteration.
|And||Project Server Last Submit Status||=||Failure|
To resolve the failure condition, review the history of the failed work items to determine the specific error that is keeping them from being submitted. Correct the error, and save the work item. During the next synchronization interval, the corrected work items should be submitted. You can verify that they have been submitted by waiting a few moments and running the query again.
Find Submitted Work Items That the Project Manager Rejected
To find work items that the project manager rejected, you can create the following query. This query finds all work items for which the Project Server Last Review Status field is set to Rejected. You can filter the list by Area or Iteration.
|And||Project Server Last Review Status||=||Rejected|
To resolve the rejected status, review the history of the rejected work items to see the comments that the project manager used to outline the reason for rejection. To resubmit the work item with changes, perform the following sequence of steps:
Update the work item to address the project manager's comments.
On the Project Server tab, change Submit to Project Server to Yes for the appropriate enterprise project plan.
If the team project is mapped to more than one project plan, in Enterprise Project, click the plan that corresponds to the project manager's comments.
Save the work item.
You can verify that an individual work item was successfully submitted by viewing its History or by verifying that the Project Server Last Submitted Date field has been updated or is more recent than the Last Approval Date since a previous rejection.
Find Work Items Where the Work in Team Foundation Differs from that in Project Server
To find work items that contain work values that differ from those in Project Server, you can create the following query. This query finds all work items whose Completed Work does not equal Project Completed Work or whose Remaining Work does not equal Project Remaining Work. You must group each And clause with the Or clause that follows it. The last two clauses filter the work items that contain empty or zero values for work.
To find work items that contain a null or empty string, leave the Value field empty.
|< > [Field]
< > [Field]
|Project Completed Work
Project Remaining Work
Project Completed Work
Project Remaining Work
To compare work values, click Column Options, and add Completed Work, Project Completed Work, Remaining Work, and Project Remaining Work to the list of columns that appear in the results.
You can verify whether an individual work item was successfully submitted by viewing its History or by checking that the Project Server Last Submit Status field is set to Success.
Find Work Items That Are Being Synchronized With Project Server
To find work items that are being synchronized to a specific enterprise project plan, you can create the following query. This query finds all non-closed tasks for a specific plan. You can filter the list by Area or Iteration.
|And||Work Item Type||=||Task|
|And||Project Server Enterprise Project||=||PlanName|
To view which work items have and have not been submitted, click Column Options, and add Project Server Submit to the list of columns that appear in the results. You can filter the query to find only those tasks that have not been submitted by adding a clause with Project Server Submit <> Yes.
By default, Project Server Submit is set to No for each work item that you create. However, any work items that you created before the project plan was mapped to the team project may contain an empty value for the Project Server Submit field.
Fields That Support Queries That Relate to Data Synchronization
When you specify a type of work item to participate in data synchronization, more than 25 fields are added to the work item type and are available to support queries. All fields start with "Project Server. Most fields are read-only. The following table indicates the label of the field on the Project Server tab and the friendly name of the field, which you use to specify it in the Query Editor. For information about more fields that you can use to support queries, see Project Server fields that support data synchronization.
|Label on Project Server tab||Name in Query Editor|
|Enterprise Project||Project Server Enterprise Project|
|Last Approval Date||Project Server Last Reviewed Date|
|Last Approval Status||Project Server Last Review Status|
|Last Submit Status||Project Server Last Submit Status|
|Last Submitted Date||Project Server Last Submitted Date|
|Linked to Project Server||Project Server Is Linked|
|Completed Work||Project Server Completed Work|
|Remaining Work||Project Server Remaining Work|