There are times when you need to know who are the users that are logged in to TFS, there are many reasons why you need this information starting from troubleshooting and ends with usage statistics.

In this blog I will answer another question that I am been asked all the time: “Why the hell do I need the TfsActivityLogging database?”

Here is why, in order for you to get the list of users logged in to TFS and the Log in history do the following:

Step 1: Open the SQL Server Management Studio (With Administrative rights)

Step 2: Connect to the SQL Server of the TFS

Step 3: Browse to the TfsActivityLogging database

Step 4: Query the tbl_Command table

Now you can see all the users that are logged in and the log in history and you know the answer to the big question: “Why the hell do I need the TfsActivityLogging database?”

Have Fun!!!