Options for extracting tests 'minutes taken in total' over time

[paulm29]

I'd like to extract the 'minutes taken in total' for Tests from a specific job in a specific build. 

Ideally, this could be done by the REST API, but I don't see the option for this, only buildDurationDescription, which is different.

URLs tried: http://bamboodev/rest/api/latest/result/HOME-NH2EPHC-JOB1-latest?expand=testResults.allTests and http://bamboodev/rest/api/latest/result/HOME-NH2EPHC-latest?expand=stages.stage.results.result.testResults

- where JOB1 is the Default Job and HOME-NH2EPHC is the build key. 

I dug up this old thread, but the option suggested, "analyze the test result xml files stored on the Bambo server in the "builds" directory" doesn't seem feasible in my environment: https://community.atlassian.com/t5/Bamboo-questions/Is-there-a-way-to-get-at-the-test-running-time-data-in-Bamboo/qaq-p/152047

What are my other options? Are there suitable plugins, or is there something I have missed?

It would be great to get a history of test times for a build/job, but one step at a time...

Thanks

[Daniel Santos · Accepted solution]

Hi @paulm29

I don't know any plugin used for this, but I don't know a lot of Bamboo plugins anyway.

As you already know, Bamboo REST API does not provide such information for tests.

In order to help you moving forward, I built the following query that may be useful to you. You might need to adjust it to your purpose, but at least you have a start.

SELECT TCL.TEST_CLASS_NAME
     , TCA.TEST_CASE_NAME
     , B.FULL_KEY
     , TCA.FIRST_BUILD_NUM
     , TCA.LAST_BUILD_NUM
     , TCA.AVG_DURATION
FROM TEST_CASE TCA
JOIN TEST_CLASS TCL ON TCA.TEST_CLASS_ID=TCL.TEST_CLASS_ID
JOIN BUILD B ON TCL.MASTER_JOB_ID=B.BUILD_ID

I also created a feature request for this:

• [BAM-20580] Provide a way to retrieve tests duration programmatically

I hope that helps.