Video Screencast Help
Search Video Help Close Back
to help
New in the Rewards Catalog: Vouchers for "Symantec Technical Specialist" and "Symantec Certified Specialist" exams.

List Retrieve Queue Membership

Updated: 23 May 2010 | 2 comments
pstage's picture
+1 1 Vote
Login to vote

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.

discussion Filed Under:

Comments

MBHarmon's picture
18
Mar
2009
1 Vote +1
Login to vote

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
23
Mar
2009
0 Votes 0
Login to vote

Thanks!

Thanks!