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

Querry CDR for specific Calling number using CLI ?

Is it possible to run a SQL querry for a perticular Calling number  or Called number from Callmanager 7 CLI ? 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super Bronze

Re: Querry CDR for specific Calling number using CLI ?

Hi

You can use the 'like' keyword to enable wildcard matching, and the wildcard character is %

So for example:

All numbers starting with 55212448

run sql select callingpartynumber, originalcalledpartynumber, finalcalledpartynumber,datetimestamporigination from car:tbl_billing_data where originalcalledpartynumber like  '55212448%'

All numbers containing 55212448

run sql select callingpartynumber, originalcalledpartynumber, finalcalledpartynumber,datetimestamporigination from car:tbl_billing_data where originalcalledpartynumber like  '%55212448%'

Regards

Aaron


Please rate helpful posts...

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!
Silver

Re: Querry CDR for specific Calling number using CLI ?

Yup,

Aaron mentioned should work.

Basically if you should focus on the query syntax and see what columns are there to get the output from the tables using sql.

Once you get the hang of that,  you can easily manupilate the queries to get desired results..

HTH

kunal

6 REPLIES
Silver

Re: Querry CDR for specific Calling number using CLI ?

Hello,

try this query from the cli of the publisher:

run sql select callingpartynumber, originalcalledpartynumber, finalcalledpartynumber,
datetimestamporigination from car:tbl_billing_data where originalcalledpartynumber = '911'

basically the feild after where is the one which we are getting the output for, it can calling party, called party, and the '911' means the number(calling or called); if you play around with it, i am sure you will get the hang of it, if you have any specific question, do let me know.

HTH

kunal

Silver

Re: Querry CDR for specific Calling number using CLI ?

Also i am assuming CDR data is woking with out any issues in the cluster.

Regards

Kunal

Community Member

Re: Querry CDR for specific Calling number using CLI ?

Kunal,

Thanks for the reply.. I will test it tomorrow and let you know.

Rav

Community Member

Re: Querry CDR for specific Calling number using CLI ?

Kunal,

It worked just fine for perticular Called number. If I want to list all the calls originated from a perticular site, by its Calling number how should I formulate the querry. Can we list all the calls originated by a DID range begins with +55212448 ?

Thanks in advance,

Rav

Super Bronze

Re: Querry CDR for specific Calling number using CLI ?

Hi

You can use the 'like' keyword to enable wildcard matching, and the wildcard character is %

So for example:

All numbers starting with 55212448

run sql select callingpartynumber, originalcalledpartynumber, finalcalledpartynumber,datetimestamporigination from car:tbl_billing_data where originalcalledpartynumber like  '55212448%'

All numbers containing 55212448

run sql select callingpartynumber, originalcalledpartynumber, finalcalledpartynumber,datetimestamporigination from car:tbl_billing_data where originalcalledpartynumber like  '%55212448%'

Regards

Aaron


Please rate helpful posts...

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!
Silver

Re: Querry CDR for specific Calling number using CLI ?

Yup,

Aaron mentioned should work.

Basically if you should focus on the query syntax and see what columns are there to get the output from the tables using sql.

Once you get the hang of that,  you can easily manupilate the queries to get desired results..

HTH

kunal

540
Views
15
Helpful
6
Replies
CreatePlease to create content