SQL CDR reporting in CUCM ver 8

[GarageLand42]

I was able to run this SQL statement in ver 7, but it does not work in version 8

run sql select * from car:tbl_billing_data where originalcalledpartynumber like '%2966' 

  in CUCM ver 8, I recieve the following error

"Database not found or no system permissions"

[Jaime Valencia · Accepted solution]

The syntax for the qry has changed, it must look like this:

run sql car select * from tbl_billing_data where originalcalledpartynumber like '%2966' 

HTH

java

If this helps, please rate

www.cisco.com/go/pdihelpdesk

[GarageLand42]

Awesome,  that worked.