Sorry for the delay in responding. Local timezone is EST and you probably sent this follow up as my head hit the pillow.
1. When i tried to run this command on another server, it prompts "The specified table (callforwarddynamic) is not in the database.". Does it mean it can't find any call forwarding?
No, this means that you have a different CUCM version on the other server. With each version of CUCM, the database schema changes. With 6.0, the way that call forwarding information was tracked in the databse changed and the "callforwarddynamic" table was added to the database. Prior to 6.0, this data was tracked directly in the numplan database. The following is a sample query that you should be able to use on databases prior to 6.x. In this query we are looking at all patterns where the call forward destination is either long distance or international (assumes that "9" is the off net access code and the dial plan is NANP).
select n.dNorPattern as pattern,rp.name as routePartition, n.cFADestination as ForwardDestination
from NumPlan as n
where ((n.cFADestination like '91%') or (n.cFADestination like '9011%'))
5.x: (NOTE, I haven't tested this query out on a 5.x system. But the 5.x database schema (at least as it relates to this topic) suggests it should accept the above query. Most of my customers bypassed this version altogether so the window of time where I worked on this rev. is relatively short in comparison to 4x/6x/7x.)
2. Related to Qn 1, how do i search based on device profile? or even just directory number?
Good question. Which server are we talking about for these query variants? I ask because on 6.x/7x, the query I provided in the original thread will pick up phones and device profiles. Now, as you have noticed if a number is not assigned to a device then the query I provided won't catch it. This is because I am doing an "inner join" to map devices to directory numbers and if there isn't a record in the foreign table then the query skips it. To poll all directory numbers in the numplan, you can use the following query:
select n.dnorpattern, cfd.cfadestination
from Numplan as n inner join callforwarddynamic as cfd on cfd.fkNumplan=n.pkid
where (cfd.cfadestination != '')
Your "where" clause could also specify the target destination: where (cfd.cfadestination = '917035551212')
Your "where" clause could also be used to show target destinations by class (e.g. long distance/international): where ((cfd.cfadestination like '91%') or (cfd.cfadestination like '9011%'))
Note, the examples assume that "9" is your off net access code and that the devices are using the NANP.
There are multiple variations on this theme and aside from the schema change that occurred with 6.0, the query structures are similar between pre- and post- 6.x systems.
On the system you are having trouble with try the query I provided in response to question #1. If that doesn't work, then please let me know which versions of CUCM you are trying this on.
HTH.
Regards,
Bill
Please remember to rate helpful posts.
