07-27-2015 11:49 AM - edited 03-17-2019 03:47 AM
Hi,
On Callmanager the following will give the phones where CFA is set:
run sql select d.name as device, n.dnorpattern, cfd.cfadestination from device as d inner join devicenumplanmap as dmap on dmap.fkdevice=d.pkid inner join numplan as n on dmap.fknumplan=n.pkid inner join callforwarddynamic as cfd on cfd.fknumplan=n.pkid where (cfd.cfadestination!='')
I am looking for the command to get other forwards, like the busy and RNA
Anyone?
JH
Solved! Go to Solution.
07-28-2015 12:28 AM
Hi,
For Call Forward No Answer,
run sql select d.name as device, n.dnorpattern, n.cfnadestination from device as d inner join devicenumplanmap as dmap on dmap.fkdevice=d.pkid inner join numplan as n on dmap.fknumplan=n.pkid where (n.cfnadestination!='')
For Call Forward Busy,
run sql select d.name as device, n.dnorpattern, n.cfbdestination from device as d inner join devicenumplanmap as dmap on dmap.fkdevice=d.pkid inner join numplan as n on dmap.fknumplan=n.pkid where (n.cfbdestination!='')
For Call Forward Unregistered,
run sql select d.name as device, n.dnorpattern, n.cfurdestination from device as d inner join devicenumplanmap as dmap on dmap.fkdevice=d.pkid inner join numplan as n on dmap.fknumplan=n.pkid where (n.cfurdestination!='')
07-27-2015 12:48 PM
what version cucm u are talking about
07-28-2015 12:28 AM
Hi,
For Call Forward No Answer,
run sql select d.name as device, n.dnorpattern, n.cfnadestination from device as d inner join devicenumplanmap as dmap on dmap.fkdevice=d.pkid inner join numplan as n on dmap.fknumplan=n.pkid where (n.cfnadestination!='')
For Call Forward Busy,
run sql select d.name as device, n.dnorpattern, n.cfbdestination from device as d inner join devicenumplanmap as dmap on dmap.fkdevice=d.pkid inner join numplan as n on dmap.fknumplan=n.pkid where (n.cfbdestination!='')
For Call Forward Unregistered,
run sql select d.name as device, n.dnorpattern, n.cfurdestination from device as d inner join devicenumplanmap as dmap on dmap.fkdevice=d.pkid inner join numplan as n on dmap.fknumplan=n.pkid where (n.cfurdestination!='')
07-28-2015 12:49 AM
Thank you so much Mohammed!
Is there information about SQL database of Cisco?
Thanks!
Jan
07-28-2015 01:04 AM
Look for Data Dictionary based on your CUCM version.
Also, this is a good document created by TAC. Worth reading it.
http://www.cisco.com/c/en/us/support/docs/unified-communications/unified-communications-manager-callmanager/117726-technote-cucm-00.html
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: