[cisco-voip] another CM database question

[Erick Wellnitz]

To give a little mor einformation, what I have done so far is retreive the
PKID from the dnorpattern table for the DN range I need.  Then I pul the
pkid and description from the device table, then use the PKID to track down
any speed dials and teh position of the speed dial.

I'm sure this could be more efficient to reduce processing and make it
faster.

Any help is appreciated!

On Tue, Dec 11, 2012 at 10:01 AM, Erick Wellnitz <ewellnitzvoip at gmail.com>wrote:

> Okay, I have another one for you CM Database gurus.  :)
>
> I have a need to find out prior to migration who has speed dials set up.
> My problem lies in the fact we have a large portion of our user base who
> only have device profiles and no way to identify them as belonging to a
> certain site except through the DN associated.
>
> I have no problem taking some SQL and dumping it into my perl scripts
> which use AXL but I really stink at anything but basic SQL queries.
>
> Thanks in advance
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20121211/7f930a05/attachment.html>