Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Users might experience few discrepancies in Search results. We are working on this on our side. We apologize for the inconvenience it may have caused.
New Member

Number of repeated calls from one customer during the day...

Hello everyone,


Can someone help me in the following request: I need to extract from UCCE, number of repeated calls from customers during one day, or a week or a month?


How many times one customer/ani repeated during the day....


Some query would be nice, or hint or a directions where to look...


Thank you


Vlad

1 ACCEPTED SOLUTION

Accepted Solutions
New Member

Number of repeated calls from one customer during the day...

Hi,

This you can get by running the below query on the ICM DB.

select count (*) as amt,ANI from Route_Call_Detail

where DateTime > '2013-02-28 00:00:00.000'

and DateTime < '2013-02-28 23:59:59.000'

group by ANI

Regards

Sandeep

2 REPLIES
New Member

Number of repeated calls from one customer during the day...

Hi,

This you can get by running the below query on the ICM DB.

select count (*) as amt,ANI from Route_Call_Detail

where DateTime > '2013-02-28 00:00:00.000'

and DateTime < '2013-02-28 23:59:59.000'

group by ANI

Regards

Sandeep

New Member

Number of repeated calls from one customer during the day...

You ROCK Sandeep!!

Thank you mate!!

200
Views
0
Helpful
2
Replies
CreatePlease to create content