Is there a way to find out who forwards to a directory number without checking every single DN in CUCM?
we are running the Linux Version 22.214.171.12400-11.
On the iSDX when we list an extension we can see the 'forwarded from' information which is great if you want to remove one of the extensions from the list of forwards to the number you are looking at.
Have a look at the data dictionary which is available here: http://developer.cisco.com/web/axl/docs
The dictionary describes the tables in the db. For some reason, probably performance related, the cfa is put in a table of its own. All other fwd destinations are in the table numplan. Making a query against a single table is quite simple, for example "run sql select cfbdestination from numplan where dnorpattern = '12345', or the other way around "run sql select dnorpattern from numplan where cfbdestination = '7007'. You can also query for more than one value, for example "run sql select cfnadestination,cfbdestination where dnorpattern = '12345'" Dumping data to the CLI is not very effective since you'd have to cut and paste, so if this is something you want to automate i would recommend using the AXL interface to make the query with the executeSQLQuery method
. That would of course mean a bit of programming :-)
I see what you mean, but I just ran this query for 2,300 phones to find which ones were forwarding to 7007. I went through the whole report in about 5 minutes. So not too bad :)