For Call Forward No Answer:
run sql select d.name as device, n.dnorpattern, n.cfnadestination from device as d inner join devicenumplanmap as dmap on dmap.fkdevice=d.pkid inner join numplan as n on dmap.fknumplan=n.pkid where (n.cfnadestination!=”)
For Call Forward Busy:
run sql select d.name as device, n.dnorpattern, n.cfbdestination from device as d inner join devicenumplanmap as dmap on dmap.fkdevice=d.pkid inner join numplan as n on dmap.fknumplan=n.pkid where (n.cfbdestination!=”)
For Call Forward Unregistered:
run sql select d.name as device, n.dnorpattern, n.cfurdestination from device as d inner join devicenumplanmap as dmap on dmap.fkdevice=d.pkid inner join numplan as n on dmap.fknumplan=n.pkid where (n.cfurdestination!=”)