Azure DevOps Release Task SQL table - looking for all servers we copy to

Question

We have azure devops 2019 1.1. I am needing to find a way to identify the servers we copy to across all projects in all releases. Most of the time we just use the copy file task and do something like copy to servenameinetputsite. Is there a table I can look at and see all the tasks in all releases and grab that data?

question from:https://stackoverflow.com/questions/66047929/azure-devops-release-task-sql-table-looking-for-all-servers-we-copy-to

Answer 1

I am afraid that currently there is no such tables with this feature as this is a custom requirement.

As a workaround, if you directly use the specific value as the target folder for the Copy Files task, you could use this Rest API: Definitions - List to list all release definitions and use Rest API: Definitions - Get get single release definition details. And then search the Copy Files task, whose task id is 5bfb729a-a7c8-4a78-a7c3-8d717bb7c13c. And then find the value of TargetFolder argument.

If you use variable as the target folder, you will have to further use Rest API: Releases - List to get a list of releases for single release definition. And then use Rest API: Releases - Get Release to get single release details. And then search the Copy Files task via its task id. And then find the value of TargetFolder argument.

I have to say that this workaround takes lots of work, it is not easier than manually check the releases via web portal.