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

[Wes Sisk]

Database name is specified differently in CM6.x:

admin:show version active
Active Master Version: 6.1.5.10000-10

Active Version Installed Software Options: 
localeinstaller
cm-locale-fr_FR-6.1.3.3000-1.cop
ciscocm.removeVIR.cop

admin:run sql select callingpartynumber,origdevicename,finalcalledpartynumber from car:tbl_billing_data where finalcalledpartynumber like '%911'
callingpartynumber origdevicename finalcalledpartynumber 
================== ============== ====================== 

Regards,
Wes

On Aug 31, 2011, at 10:43 AM, Jason Aarons (AM) wrote:

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
 
_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20110831/cae29058/attachment.html>