CALLMANAGER MSSQL DataBases

[webstd.design]

WHERE CAN I READ ABOUT MS SQL DATABASES USED WITH CALLMANAGER?

FOREXAMPLE I WANT TO SELECT ALL PHONES FROM ADM.WEB.PAGE "DEVICE->PHONE" BY SQL QUERY

HOW CAN I DO THIS?

I FOUND ONLY TABLE "NUMPLAN" THAT CONTAINS ALL DIALPLAN, BUT THERE IS ALSO DELETED SAVINGS, AND I WANT TO SELECT ONLY REAL DIAL NUMBERS AND PHONES

[Chad Stachowicz]

Actually,

I used SNMP in all my tools to recover this information! Here are the relevant OID's!!!

my $ccmPhoneIPAddress = '1.3.6.1.4.1.9.9.156.1.2.1.1.15';

my $ccmPhoneRegistered = '1.3.6.1.4.1.9.9.156.1.2.1.1.7';

my $ccmPhoneDescription ='1.3.6.1.4.1.9.9.156.1.2.1.1.4';

my $ccmPhoneType = '1.3.6.1.4.1.9.9.156.1.2.1.1.18';

my $ccmPhoneProductIndex ='1.3.6.1.4.1.9.9.156.1.1.8.1.3';

HTH, please rate useful posts!

Chad

[louis.engelbrecht]

Hi Chad

can you please expand a bit on how you are using snmp to get the ip addresses of your phones?

basically what i want to accomplish is to have live ip address data of all the phones registered in callmanager.

currently i have to manually run a modified devicelistx asp page to insert the data into a sql table.

CCM4.2(3)

[William Bell]

Louis,

Hello. I know you asked Chad, but I will pipe in if that is OK. I haven't look at 4.2(3) but I believe that the CISCO-CCM-MIB is pretty much uniform across versions for the information you are looking for.

The MIB (and dependencies) can be downloaded from Cisco. See: http://www.cisco.com/public/sw-center/netmgmt/cmtk/mibs.shtml

Information on CISCO-CCM-MIB for your version:

http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/service/4_2_3/ccmsrvs/ssappdxa.html

Information you are probably most interested in based on your query is in the ccmPhoneTable (OID: .1.3.6.1.4.1.9.9.156.1.2.1). In particular: ccmPhonePhysicalAddress, ccmPhoneDescription, ccmPhoneInetAddress, ccmPhoneStatus. Note that there is a ccmPhoneIpAddress object but it is obsolete and replaced with InetAddress.

Hope this helps.

Regards,

Bill