How to: Create Service Connections Dashboard on Azure DevOps{Organization}/_odata/v4.0-preview
  • After connection, was selected Projects table:
  • Here it was necessary to list all Service Connections for each project. To do this was created a Custom Column that invokes Endpoints Get Service Endpoints, according to the following command:
= VSTS.Contents("" & Organization & "/" & [ProjectName] & "/_apis/serviceendpoint/endpoints?api-version=6.0-preview.4")
  • From the API execution, was created a new table EndPoints:
  • After creating all tables, this model is presented:
  • After that, it’s possible to create a report
  • Project Name(1) = filter Team Projects;
  • Connection Type (2) = filter Connection types (git, azure, sonar, etc.);
  • Service Connection (3) = filter respective Service Connection Name;
  • Project Name(4) = lists the Team Project on which the service connection was created;
  • Service Connection(5) = lists the Service Connections for the respective Team Project;
  • Connection type(6) = lists Connection type (git, azure, sonar, etc.) for the respective Service Connection.




Tech Solution Architect Manager na Accenture

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Mind-mapping Micro-services Design Patterns — Part 2

Website Video Production in Merrymeet | ShowReel #Website #Video #Production #Merrymeet

Improving the Benefit to Cost Ratio in App Development Projects

Day 7- Building the Obstacle Course

Event driven video transcoding using Google App Engine, Cloud PubSub and Cloud Data Store

Redis based NLP pipeline: end to end from JSON to Knowledge Graph

A Note from the UIST 2021 PC Chairs

A 2x2 diagram with four quadrants. The upper-right quadrant represents “novel functionality, novel techniques’’ and contains a unicorn image. The upper-left represents “novel functionality, known techniques” and contains the projects Zensors and ERICA. The lower-right represents “known functionality, novel techniques” and contains the projects XDStudio and TappCloud. The lower-left represents “known functionality, known techniques” and contains projects the “Web on The Wall Reloaded’’ and Rico.

Unlock the Secrets of Cloud Adoption

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Vinicius Moura

Vinicius Moura

Tech Solution Architect Manager na Accenture

More from Medium

How to: Team Projects, Fields, and Picklists Mapping on Azure DevOps

💪Azure Bicep Language - Build a WordPress environment using Bicep modules

Private linking an Azure Container App Environment

Ultimate Guide to Connecting to Office 365 Outlook using Azure Logic Apps