532 questions
The Rest API approach works for me but the query not working as some of the objects not existing in the database like tbl_Change, tbl_File..etc
Get Changeset List of PRD Branch in AzureDevOps 2022
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 80%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Shubham Kumar
0
Reputation points
Since TFS_Warehouse Database is depreciated in Azure DevOps 2022 , so from where can I get the changeset details of only PRD Branch with changed file details in sql database.
Azure DevOps
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(163.2, 64%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDR%3C/text%3E%3C/svg%3E)
Durga Reshma Malthi 5,650 Reputation points Microsoft External Staff Moderator2025-07-04T09:52:41.8466667+00:00 In Azure DevOps, the TFS_Warehouse database has been deprecated, and the recommended approach for accessing data, including changeset details, is to use the Azure DevOps REST API.
Could you please provide more details on this.
Meanwhile, check the following things:
GET https://dev.azure.com/{organization}/{project}/_apis/git/repositories/{repositoryId}/commits?searchCriteria.itemVersion.version={branchName}&api-version=6.0(or)
GET https://dev.azure.com/{organization}/{project}/_apis/tfvc/changesets?searchCriteria.itemPath={path}&searchCriteria.fromDate={fromDate}&searchCriteria.toDate={toDate}&api-version=6.0You can filter and store this data in your own SQL database.
If you have direct access to the Azure DevOps SQL database, you can query the relevant tables directly. However, this is generally not recommended due to potential changes in the schema and the risk of impacting performance.
Assuming:
- Your collection DB is named something like
AzureDevOps_DefaultCollection - Your project uses TFVC (Team Foundation Version Control)
- The PRD branch is something like
$/YourProject/Main/PRDor similar - This works only for TFVC repositories.
- Refer to this SQL Database.txt
Hope this helps!
Please Let me know if you have any queries.
- Your collection DB is named something like
-
Durga Reshma Malthi 5,650 Reputation points Microsoft External Staff Moderator
2025-07-07T08:10:11.26+00:00 Just checking in to see if you had a chance to review the response provided to your question.
Feel free to reach out if you have any further queries.
-
Durga Reshma Malthi 5,650 Reputation points Microsoft External Staff Moderator
2025-07-08T08:05:26.4666667+00:00 Just checking in to see if you had a chance to review the response provided to your question.
Feel free to reach out if you have any further queries.
Sign in to comment
1 answer
Sort by: Most helpful
-
Shubham Kumar 0 Reputation points
2025-07-08T12:25:29.9566667+00:00 -
Durga Reshma Malthi 5,650 Reputation points Microsoft External Staff Moderator
2025-07-08T13:46:54.9633333+00:00 The Azure DevOps REST API doesn’t expose internal SQL tables like
tbl_Changeortbl_Filethose were part of the old TFS_Warehouse or Collection DB schema, which is no longer recommended or even accessible in many hosted environments.Instead, the REST API gives you structured JSON responses, and you don’t need to query backend tables directly.
To get changesets for a specific branch (like
$/YourProject/PRD):GET https://dev.azure.com/{organization}/{project}/_apis/tfvc/changesets?searchCriteria.itemPath=$/YourProject/PRD&api-version=7.1Then, for each changeset ID returned, get the file-level changes, this second call returns a list of changed files, their paths, and change types (edit, add, delete, etc.).
GET https://dev.azure.com/{organization}/{project}/_apis/tfvc/changesets/{id}/changes?api-version=7.1Hope this helps!
Please Let me know if you have any queries.
-
Durga Reshma Malthi 5,650 Reputation points Microsoft External Staff Moderator
2025-07-09T08:24:52.2833333+00:00 Just checking in to see if you had a chance to review the response provided to your question.
Feel free to reach out if you have any further queries.
Sign in to comment -