Category Archives: 4390

How can I temporarily suspend TFS event notification mails?

There is no built-in command to achieve this.


You can turn off all e-mail alerts in the TFS Admin Console by unchecking the "Enable Email Alerts" checkbox.

Thanks Rich for making me aware of the typo!

Alternatively you could also remove disable SMTP settings via command line:

%ProgramFiles%\TFSConfig ConfigureMail  /Enabled:False|True

(Special thanks to Jim Lamb, Microsoft, for making me aware of the command line, and Martin Kulov and Tiago Pascoal for the idea to just disable the SMTP settings.)


  • 03/28/2011: Changed the command line parameters from using the SMTP settings (/FromEmailAddress:EmailAddress /SmtpHost:SMTPHostName) to just use "/Enabled:True|False" (Thanks to Rich Hundhausen for making me aware, Thanks to Jim again for providing the undocumented parameter).

Who created that TFS event subscription?

In TFS you can use Project Alerts or Alerts Explorer to edit your subscriptions. You will not see subscriptions created by others.

To see all subscriptions you could have a look at the tbl_EventSubscription table in the collection database (Caution: Do not make any changes to the TFS DBs!).

I am getting mails from TFS - who created that subscriptions?

To find out which user identity is hidden behind the GUID in the "SubscriberId" column, you can use the following SQL statement

SELECT  es.Id,
FROM    tbl_EventSubscription es
JOIN    [Tfs_Configuration].[dbo].tbl_security_identity_cache sic
ON      sic.tf_id = es.SubscriberId
WHERE   es.Id = 123

where 123 is the Subscription ID (see "Id" column in the screenshot above).

(Thanks to Patrick Carnahan from Microsoft for helping me out with this and providing the SQL statement above)

Trouble installing SharePoint 2010 Prerequisites because it cannot configure IIS on Windows Server 2008 R2?


The prerequisites installation fails with errors configuring IIS.


  1. Make sure to install all available Windows Updates.
  2. Try to manually install the required IIS features by executing the following command:

start /w pkgmgr /iu:IIS-WebServerRole;IIS-WebServer;IIS-CommonHttpFeatures; IIS-StaticContent;IIS-DefaultDocument;IIS-DirectoryBrowsing;IIS-HttpErrors; IIS-ApplicationDevelopment;IIS-ASPNET;IIS-NetFxExtensibility; IIS-ISAPIExtensions;IIS-ISAPIFilter;IIS-HealthAndDiagnostics; IIS-HttpLogging;IIS-LoggingLibraries;IIS-RequestMonitor;IIS-HttpTracing;IIS-CustomLogging;IIS-ManagementScriptingTools; IIS-Security;IIS-BasicAuthentication;IIS-WindowsAuthentication;IIS-DigestAuthentication; IIS-RequestFiltering;IIS-Performance;IIS-HttpCompressionStatic;IIS-HttpCompressionDynamic; IIS-WebServerManagementTools;IIS-ManagementConsole;IIS-IIS6ManagementCompatibility; IIS-Metabase;IIS-WMICompatibility;WAS-WindowsActivationService;WAS-ProcessModel; WAS-NetFxEnvironment;WAS-ConfigurationAPI;WCF-HTTP-Activation; WCF-NonHTTP-Activation

For more details visit this page:

How to add a project portal and reports to a Team Project?

Enalbe SharePoint Dashboards and Reports with TFS 2010You created the team project without a project portal and/or without reports? Or maybe you upgraded your TFS to 2010 and did not migrate the reports/portals as well and want to create new, fresh ones?

The TFS 2010 Power Tools are your friend:

  • tfpt addprojectportal – Create a project portal for an existing Team Project that doesn’t currently have one.
  • tfpt addprojectreports – Create (or overwrite) the reports for an existing Team Project.

Execute it on the command line (you will nedd to "run as admin"):

tfpt addprojectportal /server:MYTFS\DefaultCollection /teamproject
:TeamProject /processtemplate:"MSF for Agile Software Development v5.0"
All provided settings are valid.
Log file has been created at "C:\Users\Neno\AppData\Local\Temp\TeamProject
.log". Check the log for detailed results.

TF255357: The following query was not found: Product Planning

If you add a project portal to your team project (i.e. by running tfpt addprojectportal) you might receive the error message

TF255357: The following query was not found: Product Planning. Download the process template, open it, and verify that the query exists.


The site template expects certain work item queries to exist (e.g. product planning).


  • On upgraded team projects, create the missing work item queries (you can copy/paste them from other MSF/Agile 5.0 projects).
  • If you removed/renamed the default queries, undo that.

(Thanks to Rich Day for the post and the solution for this issue.)

Using TFS to develop custom SharePoint applications (revised)

TFS and MOSS - a great team?The first article is created during a real world customer engagement and answers dozens of frequently asked questions and how-tos in a real world context vs. theoretical discussions. The 2nd package addresses very common questions around setting up and using TFS features for a MOSS development project.

VSTS Rangers – SharePoint Server Custom Application Development: Document Workflow Management Project
Read about the real-world design, construction, and deployment of a custom SharePoint Server 2007 application to a mid-market enterprise customer using Team Foundation Server as an ALM platform.

VSTS Rangers – Using Team Foundation Server to Develop Custom SharePoint Products and Technologies Applications
Learn how to use TFS to support your SharePoint application development, and provide an integrated development environment and single source code repository for process activities, integrated progress reporting, and team roles.

Additionally to the existing guidance from Patterns & Practices the two teams worked together to align these stories:

patterns & practices: SharePoint Guidance

The SharePoint Guidance contains a sample implementation of an intranet application based on SharePoint Server 2007 that demonstrates solutions to many ALM challenges.

Setup up an e-mail notification on other user’s check-ins

  1. Open Alerts Editor (required TFS Power Tools to be installed locally).

    Alerts is part of TFS Power Tools by Microsoft

  2. Create new alert.

    Create a new alert to be notified by e-mail when something happens on the server.

  3. Choose “Check-In of a specific file happens”:

     A check-in alert gets fired when someone check-ins. 

  4. Enter a name for the alert subscription, the destination e-mail address, desired team project name ($/Teamproject), if applicable, as well as your account name (to be excluded).

    The Alert Definition Editor

  5. The “Filter Expression” (2nd tab) looks now similar to:

    ‘Artifacts/Artifact[starts-with(translate(@ServerItem, "ABCDEFGHIJKLMNOPQRSTUVWXYZ", "abcdefghijklmnopqrstuvwxyz"), "$/playground")]‘ <> null AND "Committer" <> ‘TFS\neno

Using TFS to develop custom SharePoint applications

Using Team Foundation Server to Develop Custom SharePoint Products and Technologies Applications

Summary: Use Microsoft Visual Studio 2008 Team Foundation Server to support SharePoint application development, and provide an integrated development environment and single source code repository for process activities, integrated progress reporting, and team roles. (12 printed pages)

Author: Microsoft Corporation, September 2008


Updated: revised versino of this blog post.