You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
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?
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.
Atlassian Support APAC
--please don't forget to Accept the answer if the reply is helpful--
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.