Getting data from our CUCM 8

[j.kruijt]

Hello,

I like to get some information about extracting data from the CUCM for custom report facilities. We do have some special reports that are not present in any reporting tool we have got from Cisco.

I would be helped if I could copy the database files to a extend location, in order to setup a new database server with those files. Is there anybody who has experience with that process?

Regards,

J.

[Leo Salcie Tejeda]

Hi John,

Unfortunently, In CUCM 8.X we don't have access to Database anymore. What kind of report you are looking for?

I recommend to read this article:http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/service/8_6_1/car/car.html

Regards

Please remember to rate useful posts clicking on the stars below.
Favor calificar todos las respuestas útiles dando click en las estrellas de mas abajo.
___________________________________________
LinkedIn Profile: do.linkedin.com/in/leosalcie

[j.kruijt]

Hi Leosalci,

Do you mean (can you confirm) that in 7.x we did have access to the database?

Regards,

john

[Leo Salcie Tejeda]

No, From version 5.X to 9.X access is rescrited (Informix Database).

Regards

Please remember to rate useful posts clicking on the stars below.
Favor calificar todos las respuestas útiles dando click en las estrellas de mas abajo.
___________________________________________
LinkedIn Profile: do.linkedin.com/in/leosalcie

[j.kruijt]

ThX!

Do you know a way to copy the database files (as in a back-up) and install them on another server where a Informix dabase server is active?

[Leo Salcie Tejeda]

Of course. Please read this arctile, just follow the steps to make and recover the backup:http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/drs/8_5_1/drsag851.html

Please remember to rate useful posts clicking on the stars below.
Favor calificar todos las respuestas útiles dando click en las estrellas de mas abajo.
___________________________________________
LinkedIn Profile: do.linkedin.com/in/leosalcie

[Jaime Valencia]

If you mean you just want to pull the info from the Informix DB, using informix tools to restore in another Infomrix instance, no, that's not possible.

Best you can use are the run sql commands or AXL to get info.

HTH

java

if this helps, please rate

www.cisco.com/go/pdihelpdesk

[j.kruijt]

@Jaime: Thanks for your repons. Can you help me a bit with the run SQL commands. I do know how, within a Windows environment, but accessing the informix database with run SQL commands I have never done.

@leosalcie: I believe Jaime just told it isn't possible?

[Rob Huffman]

Hi John,

In addition to the great help from Leo & Java (+5 guys!)

I'll just point to this great 18 - part SQL reference series by the ucguerilla himself

Bill Bell

http://www.ucguerrilla.com/search/label/CUCM%20SQL%20Query

Cheers!

Rob

"go easy...step lightly...stay free " 

- The Clash

[j.kruijt]

@Rob: Thanks for your help. I think someone who knows operating systems other then Windows, can help himself with that.

I only have enough experience with Windows (Oracle and SQL-server) to do something like that. It isn't the sql part I need the help. When I need to access the DB2 database in the OS of the CCUM, I need some help doing that. Can you tell me some more about starting a "SQL Enterprise Manager" (Windows like) on the CCUM server?

[Ayodeji Okanlawon]

Jon,

There is no SQL enterprise manager in Linux version of cucm. If you are familiar with SQL commands, then you be able to run queries against tables in the cucm. What you need is the cucm data dictionary. It will show you what tables you have and from there using SQL commands you can generate your queries..

The link below refers to where you can get the cucm data dictionary

http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/docguide/7_1_2/dg712.html#wp42371


Sent from Cisco Technical Support Android App

[j.kruijt]

@aokanlawon: Thanks for the help. I surtainly need a data dictionary. But, I also need a way to access the CUCM server from the Windows environment. Is there something like a RDP or so? I can handle the command prompt in LINUX but need to access it from the network. Or can I send in any other way (SQL) commands to the LINUX environment?

[Ayodeji Okanlawon]

You can ssh into CUCM fron a windows box...You will need a ssh client like putty. When you ssh in, you will be directed to the OS adming page..looks like a dos prompt and from there you can run your queries

Please rate all useful posts

"opportunity is a haughty goddess who waste no time with those who are unprepared"

[j.kruijt]

@aokanlawon: ThX again. I'm going to try that.