Tuesday, June 23, 2015

Team Foundation Server–Print the list of active TFS users

Today I got a request to print the list of active TFS users. I first tried to get this information through the Team Foundation Sidekicks, but unfortunately I didn’t found an easy way to extract the list of users from this otherwise great tool.

In the end I used a different approach:

  • Open SQL Server Management Studio
  • Connect to your TFS Database instance
  • Execute the following query for every collection database:

1 comment:

Kevin Price said...


I was wondering if you have an idea what this would need to be updated to support TFS 2017 and higher? I'm guessing things have changed since it is unable to find one of the columns.