KB : 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. This might be useful for customers who need a report of this kind.

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