cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
282
Views
10
Helpful
2
Replies

CuCM SQL table for shared lines

ravi.pandey
Beginner
Beginner

is there a table with a particular field that can tell if the DN is a shared line?

1 Accepted Solution

Accepted Solutions

This will find DN's assigned to more than 1 device. You can then research the devices.

run sql select numplan.dnorpattern, routepartition.name, count(*) from numplan, devicenumplanmap, routepartition where numplan.fkroutepartition = routepartition.pkid and numplan.pkid = devicenumplanmap.fknumplan group by 1, 2 having count(*) > 1 order by 1,2

View solution in original post

2 Replies 2

When running an SQL query to find the extension, if there is two devices with the same extension and  Partition, its a shared line. AFAIK there is no specific field which says its a shared line.

run sql select d.name,d.description,n.dnorpattern as DN,rp.name as partition 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 routepartition as rp on n.fkroutepartition=rp.pkid where d.tkclass=1 order by d.name

 



Response Signature


This will find DN's assigned to more than 1 device. You can then research the devices.

run sql select numplan.dnorpattern, routepartition.name, count(*) from numplan, devicenumplanmap, routepartition where numplan.fkroutepartition = routepartition.pkid and numplan.pkid = devicenumplanmap.fknumplan group by 1, 2 having count(*) > 1 order by 1,2
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: