OData services. Read cloud agents for Power BI rep...

AshleyDhevalall · ‎06-18-2020

Good day all

I have been using the following endpoints to retrieve data from Azure Devops

https://analytics.dev.azure.com/{org}/_odata/v3.0-preview/Pipelines

{
        ProjectSK: 5f03fcfd-0000-0000-000-c45092c395dc,
        PipelineSK: 1277,
        PipelineId: 4,
        PipelineName: BackOffice,
        PipelineVersion: 2,
        PipelineProcessType: Yaml
}

https://analytics.dev.azure.com/{org}/_odata/v3.0-preview/PipelineRuns

{
		ProjectSK: 5f03fcfd-0000-0000-0000-c45092c395dc,
		PipelineRunSK: 877,
		PipelineRunId: 94,
		PipelineId: 19,
		PipelineSK: 50,
		BranchSK: 503224,
		RunNumber: 5.23.6.13094-AzurePipelines,
		RunNumberRevision: 1,
		RunReason: Schedule,
		RunOutcome: Succeed,
		QueuedDate: 2019-12-14T00:00:00+02:00,
		QueuedDateSK: 20191214,
		StartedDate: 2019-12-14T00:00:15+02:00,
		StartedDateSK: 20191214,
		CompletedDate: 2019-12-14T00:09:01+02:00,
		CompletedDateSK: 20191214,
		RunDurationSeconds: 526.326,
		QueueDurationSeconds: 14.651,
		TotalDurationSeconds: 540.977,
		SucceededCount: 1,
		PartiallySucceededCount: 0,
		FailedCount: 0,
		CanceledCount: 0
    }

Can we retrieve the associated agent pool that executed the pipeline run using the existing odata feeds?

We have a requirement to display the capacity of the Cloud agents on a Power BI dashboard.

I am able to retrieve this information using

https://dev.azure.com/{org}/_apis/distributedtask/pools/9/jobrequests.

However this end point only returns 500 entries on each request and requires me to persist the information in a database to maintain history 😞

Any assistance would be highly appreciated.

Anonymous · ‎08-11-2021

Did you find a solution to this? I have the same scenario.

Anonymous · ‎06-19-2020

Hi @AshleyDhevalall ,

Sorry,I cant reproduce your senario and I cant find the related document to explain why this happen,so pls create a support ticket via below link and our relevant personnel will help to handle it.
https://powerbi.microsoft.com/en-us/support/

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

AshleyDhevalall · ‎06-21-2020

Good day Support My company has a requirement to display the usage of Azure Cloud Agents on PowerBI.

A colleague has advised me that Microsoft does not provide an out of box solution for this type of reporting. He further advised me to make use of the OData feeds available from Azure Devops and then use PowerBI to render the reports.

After looking into the OData feeds I have noticed that there is no way to retrieve the PoolId that executed the Pipeline Run.

I would like to display on a timeline the usage of the Cloud Agents for the last 2 weeks.

None of the OData endpoints allow us to retrieve this information.

There is an Azure Devops rest api call that allows us to retrieve the Pool Id per job request. This way we can retrieve information related to that specific Cloud Agent Pool. However when making use the rest api call, it does not return historical data as the OData feeds do.

The rest api call returns 500 entries and when making this call repeatedly the list of 500 entries keep updating to reflect the current state of the job requests being executed.

When using this approach it would require me to persist the data in order to filter out new records (currently executing) and maintain some sort of history.

Currently the analytics end point for Pipelines and PipelineRuns on Azure Devops do not contain this information and is still in preview.

Could we request that the agent pool id be included in this OData end point to support this requirement.