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.
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.