What SQL (preferably Oracle) query can I use to find offline Bamboo remote agents

[David Kusuda]

I am interested in an SQL query that can be used to find all offline remote agents. I have a query that gets agent information from the QUEUE table and I tried using the LAST_STOP_TIME field != NULL to identify offline agents, but that does not appear to be the correct.

Is there a query that I can use to identify offline remote agents?

[Eduardo Alvarenga]

Hello @David Kusuda

Try the SQL from the following page or use it as an inspiration. You may need to adapt it to the Oracle format.

• Generating Bamboo Agents counts from the database

Thank you,

Eduardo Alvarenga
Atlassian Support APAC

--please don't forget to Accept the answer if the reply is helpful--