thx for reply.. so this should work if i have a newer version of callmanager?
Trying to get the phone ip based on phone no (line pattern).Guess i have to do this in several steps. Cant see how this can be done with traditional axl queries? Is there another way to access the callmanager database?
You can do direct SQL queries to SQL server on the CallManager via ODBC. Its safe enough for read-only access, although not everybody is comfortable with this approach. That will allow you to get the device name associated with the line pattern. Then you'll have to resolve the IP address using devicelistx, which is a real pain, but looks like the only way to do it.
Actually, I've been meaning to explore using DHCP queries to get IP addresses, but haven't got around to it yet ...
There's one thing to be aware of: With CCM 5.0 you can forget the direct DB access (we'll have to see if we'll still find a way to access Linux and do what we want with it), so if you're using ODBC now, and the client upgrades in half a year (CCM 3.3 rather old), you have to restart from scratch.
Did you notice in the AXL programming guide for 5.0, under new and chaged information, there is an executeSQLUpdate method now. It also *doesn't* say that executeSQLQuery has been deprecated, so hopefully migrating apps that use SQL queries won't be too difficult.
re: CCM 5.0 - I believe that executeSQLQuery is meant for read-only queries (ie select statements) while executeSQLUpdate is meant for read/write (ie update statements). I recall reading that in the docs.
Of course, with 5.0's internals effectively isolated from developers you can't just examine the database directly (well, not easily anyway) so you have to rely on Cisco's documentation to understand the internal DB table structure. The core internal structure hasn't changed significantly (imo) over the versions, but now it's more difficult to figure that out...
The short answer is that you don't.... That isn't entirely true while at
the same time it kind of is, but for the most part you don't configure
the softkeys. You enable or disable them via TCL. Here is the long
answer. Be sure to read the whole thing or e...
Topology: IP Phone > Switches > Microsoft NPS setup to forward 802.1x
proxy to > ISE 2.1 patch 3 Authentication: EAP-TLS using Cisco MIC SANs
Phone Models 802.1X support? 802.1x flavor Addtl Comment EAP-MD5 EAP-TLS
Cisco 3905 Y Y N Cisco 6911 Y Y N Cisco ...
This document describe how DST changes and how time changes are
implemented in DST. Daylight Saving Time (DST) is the practice of
setting the clocks forward 1 hour from standard time during the summer
months, and back again in the fall, in order to make b...