Useful CUCM SQL Queries

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

Leave a Reply

Your email address will not be published. Required fields are marked *