/
KB : Retrieving changeset data from the internal database

KB : Retrieving changeset data from the internal database

Owned by Avinash Bhagawati
Nov 21, 2023

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

Related content