The filtering options on the release pipeline dashboard leave a lot to be desired. As the number of definitions and releases grow, it gets harder and harder to have overall visibility across releases. Currently there isn’t a great reporting solution that can be used to gather such info.
- SSRS, data warehouse and SQL Server Analysis Services cube all went away with Azure DevOps Services.
- Analytics Service is still in public preview and we have no idea how much it’s going to cost.
What does that leave us with? Manually clicking into 100’s of release definitions to figure out where they’re at in the pipeline OR the Azure DevOps Services REST API. As you probably could have guessed, I don’t like to do things manually 🙂
I set up the following PowerShell script to be executed in a release pipeline. The result is an an HTML report that’s sent via email. The report contains a list of releases that have been successfully deployed to a “QA” environment, but not yet deployed to a “Prod” environment. I’ll let the comments do the talking. Feel free to drop a line in the comment section if you have any questions.