cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
353
Views
0
Helpful
1
Replies

How Many Times does the Customer called the call center

luai
Beginner
Beginner

Hi ALL

We Have IPCC 7.1.3 With CVP 3.1 and CCM 4.2.3 ,we need to Get ANI for each Customers called the callcenter more than one time per day.

1 Reply 1

geoff
Advocate
Advocate

Query the Route_Call_Detail table on the HDS after hours. You need to use the DateTime or DbDateTime in your WHERE clause. You can find on-line easy advice on how to structure a SQL query that will only find duplicated ANIs.

Regards,

Geoff

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: