Is there a way that you can run reports in Bamboo that report on build plans with agent details?

[Matt Armstrong]

We are looking for a way to report on project build plans that can include details such as the agents IP address', server details etc. 

We want to be able to report in Bamboo and include details from the agents such as there IP address, Host name, etc.

Does anyone have or know of any mechanism that can report on agent server details out of Bamboo?

[Daniel Santos · Accepted solution]

Hi @Matt Armstrong,

Bamboo does not have this type of report. What think you could do is:

1. Parsing the build results to extract any information you need from the agents that is available in the build log
2. Use the following query to get the agent name and hostname|ip from the Bamboo DB:

   SELECT BR.BUILD_KEY PLAN_JOB ,
    COUNT(BR.BUILD_KEY) N_BUILDS,
    Q.AGENT_TYPE,
    Q.TITLE,
    Q.AGENT_DESCRIPTION
   FROM BUILDRESULTSUMMARY BR
   JOIN QUEUE AS Q
   ON BR.BUILD_AGENT_ID=Q.QUEUE_ID
   GROUP BY BR.BUILD_KEY, Q.QUEUE_ID
   ORDER BY PLAN_JOB, N_BUILDS

   This will give you the number of times a give JOB used a give agent. It may solve your problem if you only want the agent name, hostname|ip.

I hope that helps.