cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
772
Views
0
Helpful
2
Replies

Repeat Calls

MhLove007
Level 1
Level 1

Does anyone have an sql query or know-how to build a query for UCCE for repeat calls. We are trying to build a 7 day, 30 repeat call report. Any help would be appreciated.

2 Replies 2

Senthil Kumar Sankar
Cisco Employee
Cisco Employee

Probably i think you want to retrieve the ANI's where calls have count of 30, the below query will take the distinct ANI's and the Count they hit in the Route Call Detail Table.

SELECT DISTINCT (ANI), count(*) AS count

FROM Route_Call_Detail where DateTime

between '' and '' GROUP BY ANI

Check whether this helps.

Regards,

Senthil

Thank you for the feedback. I will try it out today.

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: