Retrieving changeset data from the internal database
The query below will return a list of Jira issue keys and the related TFS changesets by joining information from the issuehits and tfschangesets tables.
First, you'll need to access the database as explained here.
Then, you'll need to run the query below:
Query
SELECT DISTINCT issuekey, repositoryguid, tfschangeset_id, tfsid, date, author, Cast(comment AS NVARCHAR(100)) Comments FROM issuehits ih INNER JOIN tfschangesets tcs ON ih.repositoryguid = tcs.tfsrepository_guid ORDER BY ih.issuekey