CM8.5 find all DNs that are CFA forwarded and to what number

[Roman Rodichev]

Hello,

is there a way in CM8.5 with BAT or with SQL to find all DNs that are CFA forwarded and to what number, regardless if DN is unassigned, assigned to a phone or assigned to a route-point.

Thanks!

[William Bell · Accepted solution]

Roman,

SQL query:

admin:run sql select n.dnorpattern,cfd.cfadestination,cfd.cfavoicemailenabled from numplan as n inner join callforwarddynamic as cfd on cfd.fknumplan=n.pkid where ((cfd.cfadestination != '') or (cfd.cfavoicemailenabled='t'))

HTH.

Regards,

Bill

[Roman Rodichev]

Thanks Bill