Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

Bronze

CDR query

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
Silver

Re: CDR query

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.

123
Views
0
Helpful
1
Replies
CreatePlease login to create content