TFS query (in Visual Studio) to get all check-ins

Question

Hi,

I'm trying to get a list of all check-ins (limited / ordered by date) via the TFS query editor in Visual Studio Team Explorer.

I can make a query that lists all bugs, sprint backlog item or product backlog item, but I can't find the actual check-in. Is it's possible or should I make (SQL) queries directly on the database.

Ideas?

Answer 1

Just open the Team Explorer window, expand the TFS project, and double-click the Source Control node there.

Then you can simply right-click a project or directory in TFS source control and select View History, then you'll get all the commits.

Answer 2

I didn't realize how easy it was to copy it into a spreadsheet and make some filtering. Thanks a lot!

Answer 3

Check out TFS Sidekick from Attrice. It is a very nice and free tool that I use regularly. It has a history sidekick that allows you to query changesets by user on the source tree node that you select on the left handside of the UI. You can sort the results by date. You can also right click on a changeset to see the details such the files and the workitems.

Answer 4

You can view the history of a file or folder by right clicking on the file/folder in the solution explorer or source control explorer windows and then copy/paste the contents of the history if you want it somewhere else.

More interestingly in the use-case that you seem to be talking about, you can actually pull all this type of information in from the TFS Data Warehouse and do your own reporting on it in Excel. Take a look at the following blog post I did on this topic for more information:

Getting Started with the TFS Data Warehouse

Answer 5

select distinct top 100 c.CreationDate,c.Comment,u.DisplayName, v.Fullpath
from tbl_changeset as c
 join tbl_identity as u on u.Identityid = c.OwnerId
 join dbo.tbl_Version as v on v.Versionfrom = c.ChangeSetId 
Order by c.CreationDate desc

Here is sql report I made to view recent changes.