topic Re: CUCM CLI Command in Unified Communications Infrastructure

CUCM CLI Command

michal sabat — Thu, 03 Oct 2024 07:19:08 GMT

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')

Re: CUCM CLI Command

Nithin Eluvathingal — Thu, 03 Oct 2024 09:27:17 GMT

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.?

Re: CUCM CLI Command

michal sabat — Wed, 09 Oct 2024 12:14:41 GMT

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