List Retrieve Queue Membership

pstage's picture

I'm looking for a basic report that will show a listing of all queues along with workers assigned to them. Can someone point me in the right direction for this please? I realize you can see this if you drill into each specific worker by looking at the "retrieve queue". But, I would like to have the retrieve queue listed, with membership of each queue below.

MBHarmon's picture

I know someone else posted

I know someone else posted this before, but instead of looking for it I'll just post the one I wrote that should meet your needs.

Select worker_id as 'ID', worker_name as 'Name', queue_name as 'Queue' 
from HD_worker_view as hd 
Where hd.worker_status = 'a' 
 

- Matt

pstage's picture

Thanks!

Thanks!