CUCM Reports - Forwarding Destinations

[nic.bardea]

Does CUCM V12 have a report available to show me all DID's that are being forwarded from within the Director number configuration and within Remote Destination or Remote Destination Profile? 

System version: 12.0.1.21900-7

[Roger Kallberg]

There is nothing out of the box AFAIK. You have a few different options at hand, you can either do a SQL query, write your own program or script to use AXL or do an export of all the directory numbers and put the CSV file into Excel to be able to filter on this specific value.

[Nithin Eluvathingal]

I assume that you are trying to see the call forward setting on  each extensions.  if yes,  you can try below Sql Query from CLI.  If not Could you please explain a little more. 

admin:run sql select n.dnorpattern, cfd.cfadestination, cfd.cfavoicemailenabled from numplan as n inner join callforwarddynamic as cfd on cfd.fknumplan=n.pkid order by n.dnorpattern

[Jaime Valencia]

There are no native reports for that, your options are to use SQL queries to get the information, Nithin provided one and the question has been asked before many times, a search can provide other options, or you can create your own using the CUCM data dictionary as reference for the tables and fields.

The easier alternative is to use BAT to dump the line information and then you can look at the call forward fields there.