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.

New Member

why I can't see sql query results when I use CLI in CUCM 7

Dear all,

    I use the following command in CUCM 7 with CLI , and tried to get the call log with the speicifed calling number 88556859,

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

    but I get no results from the output ,following is the output:

admin:run sql select callingpartynumber, originalcalledpartynumber, finalcalledpartynumber,datetimestamporigination from car:tbl_bil
ling_data where callingpartynumber like  '88556859'
callingpartynumber originalcalledpartynumber finalcalledpartynumber datetimestamporigination
================== ========================= ====================== ========================

     can any one tell me why there is no any output , the command looks no error, thank you very much!

1 REPLY
Cisco Employee

why I can't see sql query results when I use CLI in CUCM 7

Because even if the query is correct what you're looking for cannot be found in the DB.

There are no entries for callingpartynumber like   '88556859' in your DB

HTH

java

If this helps, please rate

www.cisco.com/go/pdihelpdesk

HTH

java

if this helps, please rate

www.cisco.com/go/pdi
234
Views
0
Helpful
1
Replies
CreatePlease to create content