Cucm SQL을 통해 착신전환( Call Forward All ) 설정 전화 찾기

   

run sql select n.dnorpattern, cfd.cfadestination, cfd.cfavoicemailenabled

from numplan as n

inner join callforwarddynamic as cfd on cfd.fknumplan=n.pkid

where dnorpattern like '8499%' order by n.dnorpattern

8499~ 에 해당하는 착신전화 검색

   

run sql select d.name,d.description,n.dnorpattern as DN 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.dnorpattern like '80396%'

   

80396~ 에 해당하는 MAC / Description / DN

where d.name like 'SEPA0CF5B8XXXXX' 를 사용하면 MAC으로 검색가능

   

참고 사이트 : http://www.ucguerrilla.com/search/label/CUCM%20SQL%20Query\

   

   

run sql select n.dnorpattern, cfd.cfadestination from numplan as n inner join callforwarddynamic as cfd on cfd.fknumplan=n.pkid where CHAR_LENGTH(cfadestination) > 1 and dnorpattern like '84996%' order by n.dnorpattern

   

착신전환 전화 확인

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

   

출처: <http://www.netcraftsmen.net/component/content/article/70-unified-communications/715-running-sql-queries-on-cucm-6x7x-using-axl-soap-toolkit-part-1.html>

   

   

   

   

   

run sql select d.name,d.description,dmap.numplanindex, n.dnorpattern 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 CHAR_LENGTH(cfadestination) > 1 and dnorpattern like '8%' order by n.dnorpattern

   

착신전환 걸린 8로 시작하는 장비의 e164mask(External Phone number mask) 에 대한 쿼리