Alexander Vanwynsberghe

"There is nothing impossible to him who will try"

Implementing Kanban with TFS: Introduction

In this blogpost, I want to talk a little bit about how Team Foundation Server can help you to support your Kanban Process. We will use the Practical Kanban Guidance from the ALM Rangers, where I am also a part of the team. I will talk about the the process template requirements and how to get started.

First of all, really short: what is Kanban? Well, Kanban is a method to visualize the development work flow and the work in progress. Kanban has 5 principles:

    • Visualize the workflow
    • Limit WIP
    • Manage the flow of work
    • Make process policies explicit
    • Improve collaboratively

Using these aspects, you can highlight any bottlenecks in the development process. You have a visual overview of the things which are happening in your team, so you can guide it. Perhaps change the process, change the WIP limits, ..

Requirements

As you know, the way TFS supports your development process is defined by a process template. This is a collection of files that together define various process elements of a team project. There are a number of requirements that need to be satisfied to allow teams to get the most out of a Kanban-enabled process template for Team Foundation Server.

1. The process template should make it easy to modify the states in the process flow: Kanban is about continuous improvement. During the life of a project a team may wish to modify their flow, adding or removing states. Therefore the process template should make it easy to add and remove states in the process flow.

 2. The process template should allow Work In Progress limits to be represented and reported on: One of the few fundamental concepts in Kanban is to limit the amount of work in progress (WIP). This means that the process template should allow us to specify a WIP limit for each state in the lifecycle of a card.

3. The process template should allow each state in the process flow to have an In Progress and Done sub-state: The process template should allow for In Progress and Done sub-states and report on WIP limits across the two sub-states.

4. The process template should support arbitrary state transitions: Kanban is not a software development method and does not dictate anything about how a team should implement its process. Therefore a card should be allowed to be moved into any Kanban state from any other Kanban state.

5. The process template should support hosted Team Foundation Server instances: To give teams maximum flexibility, a Kanban-enabled process template should not require project collection administration rights to make changes such as the states in the process flow and WIP limits.

6. The process template should include a Cumulative Flow Diagram Report and a Kanban Board: It has to be easy to see when bottlenecks are occurring, in which state the cards are, what’s the cycle time,..

Microsoft Kanban 1.0

Based on those requirements, the ALM Rangers came up with a brand new process template called: Microsoft Kanban 1.0. This is a flexible process template allowing you to easily adapt your Kanban process on Team Foundation Server. You can download the process template here, including all documentation and guidance you need.

In a next  post, I will explain how the process template actually works and how you can use it.  But first, let’s take a look how you can install this process template. Once you have downloaded the bits (both Team Foundation Server 2010 and 2012 are supported), you need to upload it to Team Foundation Server, so that you can create a new Team Project based on that template.

1. Open Visual Studio (we will use 2012, but it’s quite similar on 2010), go to ‘Team Explorer’, click ‘Settings – Process Template Manager’, there you click ‘Upload’ and locate the folder with the process template. I will use ‘Microsoft Kanban 1.0 – dev11’, because I’m using TFS 2012.

2. After the upload is complete, you should now see ‘Microsoft Kanban 1.0’ in the list of process templates.

3. Now create a new Team Project using this process template. In Team Explorer, go to ‘Projects and My Teams -> New Team Project‘. Complete the wizard and select the Kanban process template:

4. That’s it. You have a Team Project based on the Microsoft Kanban 1.0 process template. If you open your Team Explorer, go to Work Items and you can start creating cards (based on the Card Work Item Type) and model your process (based on the Process Step Work Item Type).

More in-depth information about how to use the process template will follow in a next post. I will also talk about ‘the Global List Synchronizer’, who will be responsible for the synchronization of process steps.

If you have any valuable feedback, just leave a message or start a discussion on the codePlex forum.

Thanks!

TFS 2012 + Ant: Unable to access ant-launcher.jar

Today, I was was trying to create a build definition to run an Ant build from a Java project in Eclipse. First of all, I installed the brand new Team Explorer Everywhere for TFS 2012 RC (which looks really good!). Next step was to install the Build Extensions (to support Ant and Maven 2/3 builds). The installation went perfect, no problems at all.

Next step is to install Winant to support Ant builds on a Windows operating system. I also installed the Java SDK (including the JRE, otherwise you cannot run Eclipse). When all this was finished, I created my build definition like I normally do (I made a blog post about this a while ago).

Only.. there was a quite strange behavior when I queued my build. It only took 2 seconds. According to the build output, the Java project was successfully built, but the build was red. When I looked at the logs, I found this error:

Error: Unable to access jarfile C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\v10.0\BuildExtensions\apache-ant\lib\ant-launcher.jar

This is strange, but on the other hand correct because ant-launcher.jar doesn’t exist on that location.

Solution: When you install the Java SDK and Winant, it creates 2 environment variables. The thing is that it creates ‘User’ variables, and not ‘System’ variables. So what you have to do is create 2 system variables and append the bin paths to the ‘path’ system variable. In my case:

“ANT_HOME = C:\Program Files (x86)\WinAnt”

“JAVA_HOME = C:\Program Files\Java\jdk1.7.0_04”

“Path = …………………;JAVA_HOME%bin;ANT_HOME%bin;”

Next, restart you build service (to catch the new added system variables) and queue your build. As you can see: Issue solved :-)

TF400409: You do not have licensing rights

Today, I updated my TFS 11 machine to the recently released TFS 2012 RC version. More information about this release can be found on the the great blogpost by Brian Harry. Updating an existing TFS 11 setup is really easy, just uninstall the Application Tier and perform the installation of TFS 2012. When the setup is ready, you can follow the -upgrade- path to convert your existing databases and settings to TFS 2012. This went perfectly without any issues. Great job Microsoft!

So far so good. Although this is not the goal of this post. I want to share you something I was struggling with. When I looked at the homepage of my web access, I had this 2 red dialogs:

This behavior is really strange, because I did install the full version, nothing special, just a standard upgrade. I also found out that I didn’t have a ‘Backlog’ in the activities menu on the right, allthough I had this on the TFS 11 version (and on the TFS preview version). When I browsed to this page manually by going to http://tfsserver:8080/tfs/DefaultCollection/TeamProject/Team/_backlogs, I had this same permission error:

After some research, I figured out that you now have the possibility to define ‘Web Access Permissions‘ in this version of TFS. By default (meaning after the upgrade), this is set to ‘Limited‘ = no advanced features like the backlog etc. To activate this, just go to the Admin Control Panel, select ‘web access‘ and select ‘Full‘. Then click on ‘Set as default web access‘. You can also play with those settings by adding users to specific permissions. As you want…

That’s it, issue solved!

 

ALM Rangers Practical Kanban Guidance RC

Yesterday, together with the Visual Studio and Team Foundation Server 2012 RC release, the ALM Rangers have also SIMultaneously SHIPped their guidance as RC. As I’m really proud to have been involved in the ALM Rangers team, I can tell you that we also shipped the RC version of the Practical Kanban Guidance.

The Practical Kanban Guidance offers teams that are new to Kanban and teams that are using a manual, paper or whiteboard-based Kanban board, guidance and tool support for Kanban in Team Foundation Server 2010 and Team Foundation Server 2012. The guidance also describes how Team Foundation Server can capture metrics and other information that can be used to track and continuously improve a team’s software delivery process.

You can check it on the CodePlex project. If you have any suggestions for improvements, remarks, bugs,… just let us know! Your feedback is really valuable.

Enjoy the release!

Event 5586 after installing SP1 on SharePoint 2010

When I was at a customer recently, I found a strange error in the Event Viewer:

Event 5586:

Unknown SQL Exception 2812 occurred. Additional error information from SQL Server is included below.

Could not find stored procedure “proc_UpdateStatisticsNVP”.

This problem is caused by updating SharePoint 2010 to SP1. This update will try to execute this stored procedure, but it’s not there. If you go to location: “C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\SQL” you’ll see a file called “STOREUP.SQL”. This file will call this stored procedure. For one or another reason, the creation of the stored procedure fails when installing SP1. If you look at the file called “STORE.SQL”, you will see that there is a create statement for this stored procedure. Strange..

Ok, now that we know what the error is, we have to fix it. The first thing you have to do is to find out which databases do not have this stored procedure. You can do this by executing the following statement:

This will return you the databases without the “proc_UpdateStatisticsNVP” procedure. The next step is to create this stored procedure by using the following script:

proc_UpdateStatisticsNVP

That’s all you have to do! Be sure that you execute this script on the right database. Use the drop down in SQL Management Studio, or start the script with “USE [DBName]”.

Microsoft Feedback Client using TFS11

bg

When your team is developing software, it is really important to capture feedback from the project stakeholders like end-users and the product owners. This way, you can ensure that the progress that the team is making is on track to meet the requirements that the stakeholders have in mind. In the next version of Team Foundation Server, there is a new tool called ‘Microsoft Feedback Manager’. I mentioned this in a previous post, but now I will handle this subject a little bit more in depth using the brand new TFS11 beta.

 You can start the Feedback tools in two ways. The first way is ‘voluntary‘, where you decide to gather some feedback without being asked. The second way is ‘on request‘, where you got a request to give your feedback about a particular part or feature of an application. To start a ‘voluntary‘ feedback session, go to Start -> All Programs  -> Microsoft Visual Studio 11 -> Microsoft Feedback Client. The first thing you have to do is connect to your Team Project. After you select the Team Project, the feedback client is running on the left side of the screen:

There you see in the Instructions that you’re running the tool in ‘voluntary’ mode. In this mode, you don’t have any instructions available about the feedback session. The other way to start the feedback client is by making use of the ‘Request Feedback’ link on the TFS11 Web Access.

In the “Request Feedback” screen, you select the Stakeholder(s) you want to invite. You also provide some information about the product/application and what you expect as feedback. This can be anything related to a particular feature or about a general thing

When you click on ‘Send’, you should receive an email with the request for a Feedback session. In this email, there is link which will open the Feedback Client. The first time you do this, you’ll get a dialog asking you to open the Feedback client

When the Feedback client is started, you now see that the ‘Application‘ and ‘Instructions‘ have the same content as you provided in the previous dialog on the Web Interface

When you click ‘Next‘, you’re ready to gather some feedback. Do what you have to do (described in the instructions) and enter as much feedback as you can. The Feedback client has support for audio, video, screenshots and attachments. Using this functionality, you can create rich feedback to the developers. When you make a Feedback Request, you can also request multiple feedback items. In the Feedback Client tool, you will see multiple items to gather feedback for.

The last step is to Publish your feedback. Just click on ‘Next‘ and you will see a summary of the feedback you provided. You will also see the location where the feedback will be stored.

Now your feedback is submitted to TFS. The person who requested the Feedback can check your session. You can do this using the TFS Web interface. Go to the ‘Work Items‘ section of you Team Project, select ‘Shared Queries‘ and open the ‘Feedback Requests‘. There you will see you feedback request and the actual feedback session.

One of the nice things is that you automatically get the System Information which can be very useful for Web Application, because it will also show you the browser version and some additional information. Actually, this information is linked to your Feedback Response Work Item.

Now you have an idea what the possibilities of what the Feedback Client can do for your. It’s really a powerful tool to help you collection all information you want from your stakeholders. It’s nicely integrated in the Visual Studio 11 suite and it looks slick in the new metro-style. Thanks for reading!

Cloning Microsoft Test Manager 11 Test Suites

tcm_img

With the next version of Microsoft Test Manager, MTM11, there is a possibility to clone test suites across plans. This is something which can be very helpful if you’re working on multiple releases. This way, you can clone an existing Test Suite from a previous release, and just change the necessary things related to the new release. When you clone a test suite, the new suite will contain the copies of all test cases in the source suite. However it will not retain all historical data like the previous test runs, the related bugs, old results. It provides a clean starting point.

Getting started

This feature is available through the command line utility tcm.exe. You can start this utility using the ‘Developer Command Prompt‘ from Visual Studio 11 (beta). Start->All Programs->Microsoft Visual Studio 11->Visual Studio Tools. Enter ‘tcm‘ to see the list of available commands:

We will continue with the ‘tcm suites’ command. This command will provide us all operations related to Test Suites, like listing and cloning. The first thing you can do is get a list of all available Test Suites using the ‘tcm suites /list’ command. This will give you a list of Suites with an ID and a Name. This ID is useful to know when you want to clone from one Suite to another Suite. For each command you want to execute, you have to provide the URL of your Team Project Collection and the Team Project Name you want to work with. In my case (using the great HOL VM from Brian Keller), the command is:

tcm suites /list /collection:http://vsalm:8080/tfs/DefaultCollection /teamproject:FabrikamFiber

In this example above, I have “TestPlan1” containing the ‘A Demo Suite‘ test suite. What I want to do is clone this test suite into “TestPlan2“. So I want Id 3 to be cloned in Id 2. To do this, just use this command:

tcm suites /clone /suiteid:3 /destinationsuiteid:2 /collection:http://vsalm:8080/tfs/DefaultCollection /teamproject:FabrikamFiber

When this command is executed, the clone operation is ongoing. This command returns an operation Id back. This Id is an identifier of the actual clone process. In some cases, a test plan/test suite can contain a large number of test cases, resulting in an operation which can take a serious amount of time. In my case, it’s only a small one. What you can do to follow the process of the clone operation is executing the following command:

tcm suites /clone /status:2 /collection:http://vsalm:8080/tfs/DefaultCollection /teamproject:FabrikamFiber

As you can see, the operation ‘2‘ has succeeded. You also have some information about the clone operation like the number of test cases cloned and the cloned shared steps.

Each clone operation is stored in the TFS_DefaultCollection (or TFS_YourTPC) database. You can get an overview using table ‘tbl_CloneOperation’ where you have the same information as in the screenshot above.

This is a nice (hidden) feature in the new improved version of Microsoft Test Manager 11. I hope they will include this command in the interface so you don’t have to use the commandline version of the tool. Thanks for reading!

TFS 11 Beta Build Service on Windows Azure

front

With the new upcoming version of TFS, you will have to possibility to have your own TFS instance running on Windows Azure, called “TFS Preview”. One of the cool things about this is the fact that you’re not responsible anymore for the TFS infrastructure. You don’t have to invest in some decent hardware, everything you want is there for your, on Windows Azure.

The one thing you need to have ‘on premise’ is a build server, as TFS Preview does not give you any options to use a cloud-based build server. Which is in fact understandable, because a build server can generate lots of load and needs to be monitored precisely. But, shouldn’t it be cool to have ‘everything’ in the cloud? Well, actually you can: TFS Build Service on Windows Azure using the VM Role

In this post, I’ll take you trough the steps to setup your own build service and host it on Windows Azure.

1. Azure account

Because you will be hosting your build service on Azure, I suppose you already have your an Azure account. If not, you might already have access using your MSDN subscription (there is some good information on this blog post). The next thing you have to do is signup for the VM role beta program. You can do this on windows.azure.com and then select “Beta Programs”.

2. Base VM Role Image setup

The next thing you have to do is create your VM Role Image, which you will use to upload on Windows Azure. In fact, this virtual image will be configured like an on-premise build service. This image contain an operation system (off course) and a TFS 11 build controller with one (or more) build agents.

  • To get started, open Hyper-V manager on a Windows 2008 (R2) machine, and select the option to create a new Virtual Machine.
  • Follow the wizard, and set the amount of memory to 2048 MB. Also be sure to select the ‘Virtual Network’ connection.
  • Create a new virtual disk called “baseimage.vhd” and set the size to 30GB (when you select this size, you can deploy the VM in a “small” role, take a look at the pricing for more info)
  • Finish the wizard, boot your new virtual machine and install your operation system (windows 2008R2 for example).
  • There is a special requirement for a valid VM Role image. You have to allocate the entire virtual hard disk file to a single partition where you install the operating system. To avoid creating a recovery partition during the installation, follow these steps:
    1. Choose the Custom (advanced) installation type to select the partition where you will install Windows.
    2. Press Shift + F10 to open a command prompt during GUI-mode setup.
    3. At the command prompt, enter the following commands:
      1. diskpart
      2. select disk 0
      3. create partition primary
      4. exit
    4. Close the command prompt window.
    5. Install Windows in the newly created partition.

3. TFS 11 Build Controller

  • Next step is to install the TFS build controller on the VM, but do NOT configure it yet. We will configure it when the VM role is online on Windows Azure.
  • To do this, run the TFS 11 beta installation (you can download the beta using MSDN or this link.)

  • When the installation is finished, close the Configuration screen.
Tip: When you are planning to build more than some ‘basic’ applications, be sure to also install Visual Studio!

 

4. Windows Azure VM Role Integration Components

The next part is the installation of the VM Role Integration Components. The integration components must be installed on the machine before base image is uploaded to the Azure. The integration components start each time the OS starts. It handles the integration between the role instance and Azure environment. Follow these steps:

  1. In the Virtual Machine Connection window, in the Media menu, point to DVD Drive and then select Insert Disk. In the Open dialog, browse to the location of the ISO file for the VM Role Integration Components, wavmroleic.iso, and then click Open. The wavmroleic.iso is located at ‘C:\Program Files\Windows Azure SDK\v1.6\iso\’
  2. In the Operating System Configuration step, enter an Administrator Password, confirm it, and then click Next.
  3. Follow the wizard and once the installation of the components has finished, you will be prompted to restart the system. Click Yes to continue.
  4. Wait for the system to restart and log in to the guest machine once again. Now, inside the VM, open the Start menu, type %windir%\system32\sysprep\sysprep.exe and then press Enter to launch the System Preparation Tool. Set the System Cleanup Action to“Enter System Out-of-Box Experience (OOBE)”, check the option labeled Generalize, set the Shutdown Options to Shutdown, and then press OK. This tool will prepare the image by cleaning up various user and machine settings and log files, as well as removing any hardware-dependent information.
  5. Wait for the system to completely shutdown. Your image is now ready for deployment.

 

5. Uploading the VM to Windows Azure

Now we have a VM image ready for deployment.  Next step is to upload this image. To do this, we will use the ‘csupload‘ command from the Windows Azure Command Prompt. Follow this steps:

  1. Open the Windows Azure SDK Command Prompt as administrator
  2. Type the following command to link the context to your current subscription:
    • csupload Add-VMImage -Connection “SubscriptionId=[SubscriptionId]; CertificateThumbprint=[ThumbPrint]” -Description “TFS Build Service” -LiteralPath “C:\baseimage.vhd” -Name baseimage.vhd -Location “West-Europe”
      • The subscription id can be found on the management portal in the property grid, when you select your subscription.
      • The certificate thumbprint is a private certificate that is installed on the local machine and that is linked to the management certificates on the Azure portal.  Uou can easily copy the thumbprint from the property grid in the Azure Portal
      • Be sure to change the LiteralPath to the location of where your VHD is located.
      • The location (data center) needs to be defined where the storage will be created. You can use friendly names like “West-Europe”
  3. Now the upload will start. The first step in the process is the preparation
  4. After preparation, it will start uploading. When the upload starts, you can see your new vhd on the Windows Azure portal as ‘Pending’
  5. Wait for the upload to complete. This can take several hours, depending on the upload speed of your Internet Connection. When finished, you should see:

6. Creating the Service Model

After completing the previous step, you now have a VM image deployed to your Windows Azure account. In this task, we will create a service model and configure it to reference this image.

  1. In Visual Studio, create a new Windows Azure Project. In the New Windows Azure Project dialog, click OK without adding any roles. You will create a Virtual Machine role in the following steps.
  2. When the solution is created, right-click the Solution folder and select New Virtual Machine Role. This option is ONLY available when you are in the VM Role beta program. When your request was accepted, you should have received an email with a link to enable the VM Role option in Visual Studio. If you lost this mail, you can use this link (32bit or 64bit), it’s a small change to the Windows Register.
  3. You should see a the properties of the new VM Role. In the ‘Virtual Hard Disk‘ section, select your Azure subscription and select the the image we have just uploaded
  4. In the ‘Endpoints’ section of the wizard, add a port for the build-controller. A TFS Build Controller uses 9191
  5. Save your settings and close the window. Next step is to publish your VMRole and meanwhile enable Remote Desktop. You can do this by right-click on the solution, and select ‘Publish’.  In this window, follow the Wizard and enable ‘Remote Desktop’.
  6. Now you can Publish this solution. You can follow the status of your deployment using the Windows Azure Activity Log screen.

  7.  The roles take the following statuses
    • Initializing
    • Waiting for host
    • Setting up Windows for first use
    • Starting Windows
    • Starting Traffic
    • Ready
  8. When finished you can see your Hosted Service using the Azure Portal. Now you can also connect to the VM using Remote Desktop. Click on the Remote Desktop icon and log in using your account (defined in the Remote Desktop Setup process).

7. Configure your Build Service

Last step is to configure your brand new Build Service. When you are logged-in on the VM using Remote Desktop, launch the TFS Build Controller configuration.

  1. Click on “Configure Team Foundation Build Service” and then click the Start Wizard button at the bottom.
  2. On the Project Collection screen, identify your team project collection/account on the hosted service.  You can’t type here so just click the Browse button and add your TFS preview/Hosted TFS account. In my case, I already have a build controller running, but I’ll add another one
  3.  Next step is to configure the Build Service. In my case, I already have a build controller, but I will replace it with a new one (the original one is offline). You can also decide to use this machine as a ‘Scale out’ system for an existing Build Service. This existing one will use this new machine as extra agent capacity.
  4. In the next step, you can configure which account will run the Build Service. This can be network service, or a specific account within your Active Directory (if you use Azure Connect with AD integration). This depends on the installation type. In my case, I’ll just use the network service.
  5. In the ‘Advanced‘ section, you can define your hosted TFS  Service Service Account. Leave this by default. You can also change/manage this using the Administration section of your Hosted TFS account, in my case:
  6. Verify and confirm the Configuration Settings
  7. Configuration completed
  8. That’s it, now your Build Service is up and running, on Windows Azure. Now you can tweak this by adding some agents,… You can manage the Build Controller using Visual Studio 11 (or 2010) by going to the ‘Builds‘ section of your Team Explorer, and click on ‘Actions‘.

8. Conclusion

Now we have our TFS11 Build Service up and running on Windows Azure. Now you can create Build Definitions and queue builds (a failing build in my case)

Good luck with your Build Service and enjoy it!
Thanks for reading.

TFS Extensions for SharePoint, manual installation

When I was at a customer last week, I had a situation that SharePoint Foundation 2010 was installed as a local instance on the TFS application tier. The TFS extensions for SharePoint were already installed using the TFS installation. Now the SharePoint Foundation 2010 instance had to be changed to a farm installation. So the SharePoint Content and Configuration databases had to be located on a data tier (SQL Server 2008 R2). After the re-install of SharePoint Foundation 2010 in a farm mode, the TFS extensions for SharePoint had to be installed again.

When I went to the Team Foundation Administration Console, the ‘Extensions for SharePoint Products’ were still there (as it was previously connected to our local SharePoint Foundation 2010 instance). The problem was that the TFS extensions were not available anymore on our new SharePoint instance. When I click on the ‘Extensions for SharePoint products’, I got the error:

“TF249063: The following Web service is not available: http://abc:17012/_vti_bin/TeamFoundationIntegrationService.asmx. This Web service is used for the Team Foundation Server Extensions for SharePoint Products”

That’s correct, that TFS integration service asmx was not available anymore. The first thing I did was an un-install from the extensions (using the TFS installation media). Then I did a re-install of the extensions, but without any result. I hoped those steps could solve my problem, but they didn’t.. Time for the next step.

stsadm to the rescue

To resolve the issue, you have to install the TFS extensions manually to the SharePoint solutions store, and then deploy them. To do this, you need the stsadm tool from SharePoint. That’s the command-line administration tool from SharePoint. You have to add 3 .wsp files to your SharePoint farm.

  1. Go to the directory: C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\bin\
  2. Open a command window (Shift + right-click -> Open Command Window here)
  3. Be sure that you run the command window with a user who has the right credentials (SharePoint Farm Administrator and have rights to the Central Admin Content Database on SQL server)
  4. Run the following commands:
    1. stsadm -o addsolution -filename “C:\Program Files\Microsoft Team Foundation Server 2010\Tools\Templates\Microsoft.TeamFoundation.SharePoint.wsp”
    2. stsadm -o addsolution -filename “C:\Program Files\Microsoft Team Foundation Server 2010\Tools\Templates\ TswaWebPartCollection.wsp”
    3. stsadm -o addsolution -filename “C:\Program Files\Microsoft Team Foundation Server 2010\Tools\Templates\Microsoft.TeamFoundation.SharePoint.Dashboards.wsp”
  5. Open your SharePoint Central Administration (http://server:17012 or something equal)
  6. Go to system settings and click ‘Manage farm solutions’
  7. You should see the 3 TFS wsp files
  8. Click on the first one, and click ‘Deploy Solution’
  9. Deploy the solution by clicking ‘Ok’
  10. When you deployed the 3 solutions, you should see
  11. All you have to do now is grant access for your TFS instance to SharePoint using the TFS Administration console.

That did the trick for me. Thanks for reading!

Add reporting to a Team Project using Powertools

Last week, I had the following situation at a customer: There was a dual-tier TFS 2010 installation without reporting and analysis services. The customer did already create some Team Projects, and now they wanted to activate the reporting and analysis functionality. Ok, no problem at all. First installing the SQL Server 2008 R2 reporting and analysis functionality on the application tier and then link the reporting and analysis services to the data tier (where all database are stored, so the services do run on the application tier, and the data is stored on the data tier).

After the installation of the services, we wanted to upgrade our existing team projects to make use of the reporting functionality. There is a way to do this manually, like described in this post, but this is really hard. You have to download your process template, create the correct mapping on your reporting server, upload ‘all’ reports (for each team project), divide them in correct folders,..

There is a better way, use the TFS Power Tools. Just install the Power Tools on your application tier, and open a command prompt. If you enter ‘tfpt’, you should see a list of all the commands you can use with the Power Tools.

One of the cool features you have is ‘addprojectreports’. This will add or overwrite all reports of a team project with the reports from your selected process template. In our case, the team project does not have any reports (yet), so we want to add the ‘ MSF for Agile Software Development v5.0’ reports. We can simply do this using the command:

All you have to do is supply your TFS instance, the team project name and the process template name you want the reports from. After executing this command, you have your reporting linked to your team project. Note: Be sure that your team project collection has a folder on the report server (http://your_reportserver/Reports) like ‘TfsReports/DefaultCollection”, and that you link this folder to your reports section of your team project collection in the TFS administration Console.

To make use of your reporting, all you have to do is rebuild your analysis cube using the administration console ‘Start Rebuild’ button in the reporting section. Have fun!

(You can also use the Power Tools to create a SharePoint  project portal using the command: tfpt addprojectportal)

Pages:123