Getting a quick list of TFS 2010 users

by garyg 16. November 2011 22:13

I know there are some cool tools out there for this, but I wanted to share my “quick and dirty” query I use to get a list of TFS users, you'll need to adjust the USE statement to your collection db:

 

   1:  USE Tfs_DefaultCollection 
   2:  GO 
   3:   
   4:  select distinct IdentityName as [Recent Users] 
   5:  from tbl_Command with (nolock) 

You'll need to use with caution on a heavily loaded server since it runs against the transactional DB but an occasional run would be fine.

Tags:

About the author

   
Gary Gauvin is a 20+ year Information Technologies industry leader, currently working as the Director of Application Lifecycle Management for CD-Adapco, a leading developer of CFD/CAE solutions. Working in both enterprise environments and small businesses, Gary enjoys bringing ROI to the organizations he works with through strategic management and getting hands-on wherever practical. Among other qualifications, Gary holds a Bachelor of Science in Information Technologies, an MBA, a PMP (Project Management Professional) certification, and PSM (Professional Scrum Master) certification.  Gary has also been recognized as a Microsoft Most Valuable Professional.

LinkedIn Profile: http://www.linkedin.com/in/garypgauvin

(Note: Comments on this blog are moderated for content and relevancy)


 

Month List

Page List