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