Repeat Calls

[MhLove007]

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.

[Senthil Kumar Sankar]

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

[MhLove007]

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