CAR CCM 6 Issues

Answered Question
Sep 10th, 2008
User Badges:

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.

Correct Answer by Jaime Valencia about 8 years 7 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
User Badges:
  • Cisco Employee,
  • Hall of Fame,

    2011

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
User Badges:

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
User Badges:
  • Cisco Employee,
  • Hall of Fame,

    2011

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
User Badges:

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