UCCX 10 SQL to find Queue's Contents

[Daniel Maxwell]

I was wondering if anyone had a SQL script they could share that would list all of the originating DN's currently waiting in a given queue?

I'm working with UCCX 10 Premium...

Thank you,
Daniel

[Gergely Szabo]

Hi, no, unfortunately, there's no SQL access to that information. G.
 

[Aaron Harrison]

Just to second Gergely (+5), as no one likes a negative :-)

UCCX doesn't make that available in SQL or elsewhere.

If you really want to, you could try and make it available yourself by logging calls as they enter and exit the CSQs (from DB steps in your script) in your own DB. 

Aaron

[Daniel Maxwell]

Thanks for the replies guys!

Aaron that's actually the exact route I went... I make a RESTful call to a web service when a call comes in and and then again when it's handled. I also catch on the ContactInactiveException...

So far it's working great!

Thanks again,
Daniel

[Aaron Harrison]

Good work :-)

You don't need us!