Exporting Specific UCM dB tables - is this possible

[dgauthier]

Question.  Is there a way to export specific UCM Data Dictionary tables from the UCM Publisher?  Or am I forced to export the entire dB for analysis?  If I am forced to get the entire dB...the DRS backup is my only means? 

From a CLI perspective, I currently do not see a CLI method of extracting dB tables...perhaps I am wrong...but not convinced. 

Looking for suggestions...thx.

[Gordon Ross]

The DRS backup is encrypted, so you can't use that to get a DB dump.

What exactly are you trying to accomplish? Have you looked at the bulk export, which can export lots of CUCM's config as CSVs?

GTG

[dgauthier]

Gordon,

I am looking for UCM Data Dictionary, e.g. devices, enduser, etc.  There are SQL queries that I need to run, extract and create a Metadata dB.  I do not want to run one or two SQL queries...I need the UCM data local vs 'on the Pub'.

so I am looking for ways to get the UCM Pub dB...specific tables would be optimal.

David

[George Thomas]

Is AXL a possibility?

[Carlo Poggiarelli]

Hi David

Here is the DB dictionary where are specified all CUCM tables.

http://www.cisco.com/c/dam/en/us/td/docs/voice_ip_comm/cucm/datadict/9_1_1/datadictionary_911.pdf

To query CUCM db you can use integrated AXL Sql toolkit.

In the below link, our friend William Bell explains how to use it.

http://www.netcraftsmen.net/blogs/entry/running-sql-queries-on-cucm-6x-7x-using-axl-soap-toolkit-part-2.html

HTH

Regards

Carlo