It’s pretty common that over time, customers with “substantial” TFS implementations get to a point where they want to figure out who is actually using their TFS Server. This can be to audit use for security, or even to ensure that they’re compliant from a Client Access License perspective.
One of the ways that this can be accomplished is through the use of Excel.
First, some caveats:
- You need to have the rights to connect the databases mentioned below. This might involve increasing permissions for your user account on the SQL Server.
- The “log” is a rolling log, and does not have a complete history. You can repeat this procedure over a desired period of time to increase your accuracy
Start Excel, and go to the Data tab:
Select “From Other Sources”, and pick From SQL Server:
Type in the name of the SQL Server that TFS is using, and click Next…
Pick the “TFS_Configuration” database, and the table named “Command”, then click next:
Click Next once more, and then insert the data as a Table, and click OK:
You should see all of the details of every connection to TFS in a spreadsheet, which includes a bunch of details, like user alias, activities, and the “agent” .
This can help you with understanding users connecting, and even which "clients” they might be using when connecting.