How to find out all extensions that has set call fwd to a specific number?

[eddchen]

Hi guys,

We have a need to find out all numbers that has set call fwd to a specfic number, is there a way to find it easily from CUCM? we are using version 8.

[Dennis Mink · Accepted solution]

the way to do this is to use BULK Administration in CUCM. got to BULK administration>Phones>Export Phones>All details.

This will create a CSV file,  chuck that into Excell and do a search for the call forward specific number you are interested in.  This will then tell you what extensions and MAC addresses it is active on. 

Easy

=============================
Please remember to rate useful posts, by clicking on the stars below. 

=============================

[tacl75]

or alternatively you can export the phones into csv as well.


Sent from Cisco Technical Support Android App

[Aman Soi]

Hi,

You can also refer tis URL for running a SQL query provided by Mr. William Bell.

http://www.ucguerrilla.com/2012/04/cucm-sql-queries-listing-call-forward.html

regds,

aman

[Ayodeji Okanlawon]

You can also use sql query to achieve this..This is the query you need. Just change the number to the number you want. I find this easier that using BAT and exporting all data

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 n.pkid=dmap.fknumplan inner join callforwarddynamic as cfd on cfd.fknumplan=n.pkid where (cfd.cfadestination = '917035551212')

Please rate all useful posts

"opportunity is a haughty goddess who waste no time with those who are unprepared"