azure-devops-exporter icon indicating copy to clipboard operation
azure-devops-exporter copied to clipboard

Grafana dashboard

Open ghost opened this issue 3 years ago • 5 comments

Few people have raised issue for grafana dashboard but it doesn't addressed clearly. Would you please clarify on this point. Do you have any grafana json for this project? It'll be really helpful to entire community on top of fetching data into prometheus. Or direct us to right link/doc.

ghost avatar Oct 27 '21 20:10 ghost

I'm using Azure DevOps only at work, that's why it always a little bit difficult.

how about this dashboard? https://gist.github.com/mblaschke/ef86524d9350d45143cbbc5d2da674b1

mblaschke avatar Oct 28 '21 14:10 mblaschke

@mblaschke this is a great example.

I have created one more graph using max by(name) (max_over_time(azure_devops_build_job{result="succeeded", type="duration"}[$__interval])) / 60 which shows the longest jobs based on duration. However, I'd like to somehow join it with the buildName, so that it would be easy to find which build the job belongs to. Any idea how I could do that?

Shaked avatar Sep 13 '22 15:09 Shaked

you could join it with azure_devops_build_info based on projectID and buildID

mblaschke avatar Sep 17 '22 20:09 mblaschke

@mblaschke thank you for your contribution. Its a good starting point! kudos! ;)

brunoscota avatar May 09 '23 15:05 brunoscota

@Shaked In response to your question, the query would be something like: topk(1,((max_over_time(azure_devops_build_job{result="succeeded", type="duration"}[$__interval])) / 60 * on (buildID) group_left(buildName) azure_devops_build_info)) by (name)

Hope this helps.

kirannhegde avatar Aug 11 '23 12:08 kirannhegde