NICE query for Unrecorded calls

[9885776408]

Hi,

I want to know unrecorded calls for last 3 months , how do i get it ? I am using the NICE 8.9 version , Thanks in advance.

 

[AlmostMe]

How good are you're SQL Skills?

you can do it in query but if you have lots of failed recordings it will be a nightmare. Easiest way to do it using query is to set recorded = N in your expressions filter. Query will only show maximum of 999 calls though or 500 by default if you haven't increased this option.

 

[9885776408]

I am not good at SQL , But can we get it from SQL , If it is please let me know how to get it ?

 

[AlmostMe]

My SQL Skills aren't exactly that wonderful and I cannot remember how to use the count option don't have a test system to play with to check the SQL but that's what the online help is for. You will need to write something along the lines of:


select * from nice_cls_calls_0001 where recorded = 'n'
count on recorded

the final value of nice_cls_calls_0001 will depend on how many months of current recording you have and how far back you want to go, you will need to find out what current table calls are writing to and do 3 separate queries for each required table.

Good luck

 

[biglebowski]

select count(*) from nice_cls_calls_0001 where recorded ='n'

When I was born I was so suprised I didn't talk for 18 months

 

[AlmostMe]

thanks for the correction