[cisco-voip] CallManaget 6.1 CLI searching for 911 calls

[Jason Aarons (AM)]

The below was from a post for CCM 7x, but it won't run on 6.1, are there some table/field name changes that would make this work in 6x? or am I typing it wrong (hey it was copy/paste).

admin:run sql car select callingpartynumber,origdevicename,finalcalledpartynumber from tbl_billing_data where finalcalledpartynumber like '%911'
A syntax error has occurred.

admin:run sql car select callingpartynumber,origdevicename,finalcalledpartynumber from tbl_billing_error where finalcalledpartynumber like '%911'
A syntax error has occurred.

admin:show version active
Active Master Version: 6.1.2.1000-13


http://www.gossamer-threads.com/lists/cisco/voip/146910



Jason Aarons
Consultant
Dimension Data
904-338-3245 mobile
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20110831/76ea804e/attachment.html>