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

CAR CCM 6 Issues

We have recently upgraded to CCM Ver 6 running the new cisco linux os platform. Previous to this upgrade, we used to have direct access t the MS SQL database and I could view the tables and figure out what is wrong. My first question is, is there a way to access the database (which I think maybe an instance of informix)?

Specifically, my problem is that CAR Department reports are not accurately reporting usage. I have a case open with TAC but am not getting far and we're playing more phone tag than we are doing troubleshooting.

Any insight on the database access or the reporting problems would be appreciated.

1 ACCEPTED SOLUTION

Accepted Solutions
Cisco Employee

Re: CAR CCM 6 Issues

yes, only thru CLI and limited to QRYs

run sql

http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/cucos/6_1_1/cucos/iptpappa.html#wp1052698

download the data dictionary to know the informix DB layout

Programming Guides

http://www.cisco.com/en/US/products/sw/voicesw/ps556/products_programming_reference_guides_list.html

your TAC CSE should already know how to do this

HTH

java

if this helps, please rate

HTH

java

if this helps, please rate

www.cisco.com/go/pdi
4 REPLIES
Cisco Employee

Re: CAR CCM 6 Issues

yes, only thru CLI and limited to QRYs

run sql

http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/cucos/6_1_1/cucos/iptpappa.html#wp1052698

download the data dictionary to know the informix DB layout

Programming Guides

http://www.cisco.com/en/US/products/sw/voicesw/ps556/products_programming_reference_guides_list.html

your TAC CSE should already know how to do this

HTH

java

if this helps, please rate

HTH

java

if this helps, please rate

www.cisco.com/go/pdi
New Member

Re: CAR CCM 6 Issues

Thanks for the info - I found that the CLI is not limited to only perofrming a query. In fact, in my case, I was able to update all my records that were missing user_id's using the following CLI

The command to update the data is:

run sql update car:tbl_billing_data set user_id='johndoe' where callingpartynumber=1000

Where user_id and callingpartynumber corresponds to my internal user's and their extensions.

Cisco Employee

Re: CAR CCM 6 Issues

guess our concept of QRY are not the same

for me a QRY is any SQL statement and not limited to search records, anyway i'm glad you were able to add the info you were missing

HTH

java

if this helps, please rate

HTH

java

if this helps, please rate

www.cisco.com/go/pdi
New Member

Re: CAR CCM 6 Issues

You're right, I totally read your initial post as meaning QRY was the equiv. of just a select statement. Re-reading and understanding what I know now, your post along with links was exactly what I was looking for - my patience was just not there to review it with a critical eye. Thanks again, I've rated your post.

201
Views
0
Helpful
4
Replies
CreatePlease login to create content