How to List/search all phones on which call forwarding is set in call manager 8.6 or above

[Waleed Khan]

Hi,

I get a query recently, anyone know how to list/search all those phones on which call forwarding is set in call manager 8.6 or above.

- Waleed

[Manish Gogna]

Hi Waleed,

run sql select d.name as device, n.dnorpattern, cfd.cfadestination from device as d inner join devicenumplanmap as dmap on dmap.fkdevice=d.pkid inner join numplan as n on dmap.fknumplan=n.pkid inner join callforwarddynamic as cfd on cfd.fknumplan=n.pkid where (cfd.cfadestination!='')

Manish

- Do rate helpful posts -

[Waleed Khan]

Hi Manish,

Thanks for reply, I didn't try what you said, I find out a solution via Bulk Administration Tool, I exported all phones, then download, rename the file from test.txt to test.csv then search for forwarding option column in excel file, then I get all the phone on whom forwarding is set.

- Waleed

[Manish Gogna]

If you find that easy compared to running a CLI command then its fine.

Manish