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.