CUCM CLI Command

[michal sabat]

Hi.

I'm looking for a CLI command that I could use to list all DNs with a specific call forward.

I have one but it doesn't work for me:

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 n.pkid=dmap.fknumplan inner join callforwarddynamic as cfd on cfd.fknumplan=n.pkid where (cfd.cfadestination = d.pkid inner join numplan as n on n.pkid=dmap.fknumplan inner join callforwarddynamic as cfd on cfd.fknumplan=n.pkid where (cfd.cfadestination = '917035551212')

[Nithin Eluvathingal]

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='099028165'

The above SQL command will list all the extensions who has Call Forward All set to 099028165.

Or do you have any specific conditions like busy, no answer, etc.?

[michal sabat]

It could be great t o check also other redirections like busy or no answer