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

CDR query

aamercado
Level 4
Level 4

Hi

CM 4.1 - In CDR, how do I find the call volume for CTI routepoint per month (ie CTI RP is 34300 and I am looking in in January and February compared to prior months)

1 Reply 1

Zin.Karzazi
Level 5
Level 5

select * from CallDetailRecord

where originalCalledPartyNumber='34300'

AND dateTimeOrigination>= 1162335600

AND dateTimeOrigination<= 1164927540

Use Epoch time converter to convert the Date you want:

http://www.esqsoft.com/javascript_examples/date-to-epoch.htm

Hope this helps.

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: