List Support Groups and 'Unpicked' notification to
Hello,
I am trying to create a query report showing who receives the Unpicked notification for each group. I tried the query below, but it's not giving the correct results.
select distinct queuename "Support Group", au.First_Name "Unpicked Notification" from queuedefinition qd
Left Join queueEscalation qe on qd.queueid = qe.queueid
Left Join aaaUser au on qe.escalatetoid = au.user_id
I'm not quite sure what I'm missing. Any help is appreciated.
Thanks,
Sheila
I am trying to create a query report showing who receives the Unpicked notification for each group. I tried the query below, but it's not giving the correct results.
select distinct queuename "Support Group", au.First_Name "Unpicked Notification" from queuedefinition qd
Left Join queueEscalation qe on qd.queueid = qe.queueid
Left Join aaaUser au on qe.escalatetoid = au.user_id
I'm not quite sure what I'm missing. Any help is appreciated.
Thanks,
Sheila