CAR CCM 6 Issues

Answered Question
Sep 10th, 2008

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.

I have this problem too.
0 votes
Correct Answer by Jaime Valencia about 8 years 2 months ago

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

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
Loading.
Correct Answer
Jaime Valencia Wed, 09/10/2008 - 18:03

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

rjrii Sun, 09/14/2008 - 10:16

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.

Jaime Valencia Sun, 09/14/2008 - 14:44

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

rjrii Sun, 09/14/2008 - 15:45

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.

Actions

This Discussion