I would like to create a report from our TFS database which selects all source code repository names and commit history for these repositories. We are using git and it is integrated with TFS, but I am not sure how to access commit history from the TFS database.
I'd like to create something like this
Repository 1 - Name Commit 1- author - date Commit 2- author - date Commit 3- author - date Repository 2 - Name Commit 1- author - date Commit 2- author - date Commit 3- author - date
I was reading this document:
Though that's not quite what I want, it got me started. Looking at the schema I found these tables:
DimChangeset (changeset data) DimFile (individual files changed) DimPerson (user data) DimTeamProject (Teams project)
That seems to cover most of what I need, however I am not seeing where to get the repository names that are within the teams projects. Any suggestions? The repository names are in the TFS UI, so I assume they are stored in the database somewhere.