cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
2381
Views
10
Helpful
4
Replies

CUCM SQl CLI command

j.huizinga
Level 6
Level 6

Hi,

 

On Callmanager the following will give the phones where CFA is set:

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

I am looking for the command to get other forwards, like the busy and RNA

 

Anyone?

 

JH

1 Accepted Solution

Accepted Solutions

Hi,

 

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

View solution in original post

4 Replies 4

Tagir Temirgaliyev
Spotlight
Spotlight

what version cucm u are talking about

Hi,

 

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

j.huizinga
Level 6
Level 6

Thank you so much Mohammed!

Is there information about SQL database of Cisco?

 

Thanks!

 

Jan

Look for Data Dictionary based on your CUCM version.

 

Also, this is a good document created by TAC. Worth reading it.

 

http://www.cisco.com/c/en/us/support/docs/unified-communications/unified-communications-manager-callmanager/117726-technote-cucm-00.html

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: