Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

New Member

CUCM SQL Commands

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.”       

“If you have knowledge, let others light their candles in it.”
  • IP Telephony
Everyone's tags (4)
9 REPLIES
Cisco Employee

Re: CUCM SQL Commands

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

Br, Nadeem Please rate all useful post.
New Member

Re: CUCM SQL Commands

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.”

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

Re: CUCM SQL Commands

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

Br,

Nadeem

Br, Nadeem Please rate all useful post.
New Member

Re: CUCM SQL Commands

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.”

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

CUCM SQL Commands

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"

Please rate all useful posts "The essence of christianity is not the enthronement but the obliteration of self --William Barclay"
New Member

Re: CUCM SQL Commands

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.”

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

I've checked in the CM data

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!

I've found that in CLI I can

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

 

Re:CUCM SQL Commands

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

1525
Views
10
Helpful
9
Replies