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

David Kusuda May 16, 2023

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?

1 answer

1 vote
Eduardo Alvarenga
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
May 16, 2023

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.

Thank you,

Eduardo Alvarenga
Atlassian Support APAC

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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
VERSION
8.1.9
TAGS
AUG Leaders

Atlassian Community Events