In CUCM 7.1 how can one find the list of forwarded phone numbers and where they are forwarded ?

[hake_1999]

We are upgrading from CUCM 7.1. The new cluster is v9.1 and it was initially configured by restoring an OLD backup of 7.1..

During the upcoming cutover, we want to maintain the most current call forwarding settings for all users/phones.

Where is the list of forwarded phones and related information for each stored in CUCM database?

Is this information stored in one of the tables that can be exported using BAT? If so we could export, normalize to 9.1 and import it.

Getting a new full backup from the live CUCM 7.1 and restoring on  the new CUCM 9.1 is not a viable option due to other reasons.

Thanks in advance for any help.

[Suresh Hudda]

This information saved in table "CallForwardDynamic" but not sure how to get it using BAT. You can try with sql query.

Suresh

[a.janssen]

As an example you could use something like

run sql select np.dnorpattern, np.alertingname, cfd.cfadestination from callforwarddynamic cfd, numplan np where cfd.fknumplan=np.pkid and cfd.cfadestination matches '[0-9]*'

Maybe you have to use something like

run sql ccm select np.dnorpattern, np.alertingname, cfd.cfadestination from callforwarddynamic cfd, numplan np where cfd.fknumplan=np.pkid and cfd.cfadestination matches '[0-9]*'

on CUCM 7.1.

to get the numeric CFA destinations in your cluster.

Regards

Andre