CUCM SQL Commands

[amansin74]

Hi Guys,

One area in CUCM I have not touched is using SQL.

Could you please suggest documents or books that I should go through to be able to generate my own set of SQL commands for taking out information from CUCM CLI.

Or is there any predefined List of useful SQL Commands for CUCM .

I am not asking any document in SQL itself. But for its use in CUCM.

I would request if anyone of us can make a document on it and share it on this Community.

I would offer any help if possible, but this is one area I dont know almost anything about.

I would also request you to post any useful SQL Commands you know in the reply. That could be helpful for all of us. It will work as a document itself.

Thanks and Regards,

Aman

--

“If you have knowledge, let others light their candles in it.”       

[Nadeem Ahmed]

Hello Aman,

I have attached a ppt on SQL  , this will help you on basic understanding on SQL and i can assure you would be able to make a query after reading.

FROM CUCM prospective what sorts of command, query you are looking for, so that i will try to make a document on this.

Br,

Nadeem

[amansin74]

Hi Nadeem,

Thanks for an awesome tutorial on SQL.

From CUCM prospective, I would like to know what are the Tables that I can use in SQL commands.

I never found any information on this may be because CUCM databases are hidden.

What are the Coulumns and Rows in those CUCM Database Tables. If only we know a few useful Table with the Contents then we will easily be able to form SQL Queries on our own.

An example of useful queries could be:

IP Phone registered after date / time - 4 p.m. 14th Dec. 2013.

I believe with SQL Knowledge, this should also be possible.

But I even dont know the basic SQL commands like -

command to see whether Software Media Resource is being utilized.

or any command that can help in determining DHCP bindings.

mostly Device related queries will be very helpful -

Like IP Phone , gateways and trunks.

or even simpler things - like those that can be seen from CUCM webpage also , but knowing it using SQL is added advantage.

Regards,

Aman

--

“If you have knowledge, let others light their candles in it.”

[Nadeem Ahmed]

thanks for (+5). I will try to make a document on this.

Br,

Nadeem

[amansin74]

Hi Naveen,

Would wait for you document.

Thanks for spending your valuable time on this.

Regards,

Aman

--

“If you have knowledge, let others light their candles in it.”

[Ayodeji Okanlawon]

Amansin,

All CUCM tables are referenced in the CUCM data dictionary. You will need the data dictionary to knwo what tables you need when constructing SQL queries...The link to cucm 8.0 is given below:

http://www.cisco.com/c/dam/en/us/td/docs/voice_ip_comm/cucm/datadict/8_0_1/datadictionary_801.pdf

Now Williams Blog offers very practical insigt into this subject..You have lots of examples here...

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

Please rate all useful posts

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

[amansin74]

Hi Aokanlawon,

Thanks a lot,

CUCM data dictionary seems to be exactly the kind of thing I was looking for.

The Blog is also very useful.

Regards,

Aman.

--

“If you have knowledge, let others light their candles in it.”

[Gustavo Moreschi]

I've checked in the CM data dictionary and Williams blog, but no success. I'm looking for how to list the current "Active Load ID" firmware version using run sql.

Is there way to find out what is actually running a specific firmware version on the phones by sql? Thanks!

[Ruslan Akhmyatzanov]

I've found that in CLI I can get "Active Load ID" firmware version for all phones, registered on that CM:

admin:show risdb query phone

[David Hailey]

Go check out Bill Bell's blog, which has a lot of SQL and DB related info:

www.ucguerrilla.com


Sent from Cisco Technical Support Android App