CUCM/Call Manager find what number is forwarding to another number

[joamcd]

I have a number that's receiving calls forwarded to it that it should not receive. Is there any way to see what number is forwarding calls to another number? To be clear, I don't have the number that is forwarding the calls, just the receiving number.

Thanks!

[Leonardo Santana]

Hi,

Try this command via CLI

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

See if you find is there is any DN forwarding calls to this number.

[Maren Mahoney]

You can use Generate Phone Reports to generate a list of all phones and all Forward All Destinations.

1. Navigate to Bulk Administration > Phones > Generate Phone Reports
2. On the Find and List Phone screen, leave the search criteria blank to select all phones
3. Click Next
4. Give your Report/File a Name
5. In the Device Fields select "Device Name" and "Description"
6. In the Line Fields select "Forward All Destination" (which will automatically also select Directory Number)
7. Run your report.

As the report says, whatever search you use to generate the Find and List Phones will only show so many, but the final report will have all found devices (even if it is more than 1000)

You may want to include other Forward XXX Destinations such as Forward Busy Destination and Forward Unregistered Destination.

Let us know how it goes.

Maren 

[Mark]

Hi,
Another way to check is from CDR, you can search using the "receiving number" and it will show the original called number.

Regards,

Mark

[Roger Kallberg]

If you want to find the number that has a CFA to a specific number you can use this.

run sql select cfddyn.cfadestination, n.dnorpattern, pt.name from callforwarddynamic as cfddyn join numplan as n on cfddyn.fknumplan=n.pkid join routepartition as pt on n.fkroutepartition=pt.pkid where cfddyn.cfadestination='911200'

[Nithin Eluvathingal]

This SQL command lists the CFA destinations configured for all the DNs in the system, as well as the CF voicemail state.

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

[VoIP Engineer]

Another option would be to use a call reporting package (essentially using the CDRs).   VoIP Detective is free, and can report on what phone is forwarding calls to you, assuming it's all on the same cluster.

https://www.voipdetective.com/cucm-reporting/

[Nayid Solarte]

If CDR collection is enable in CUCM, you can see the original calling and called numbers, plus the redirecting number (the DN that forwarded the call).

Fields to check:

origCalledPartyNumber → the number that was originally dialed.

finalCalledPartyNumber→ the number that eventually received the call (your “receiving number”).

redirectingNumber → the number that forwarded the call.

and as well I would gather logs to see more details in RTMT