CuCM SQL table for shared lines

[ravi.pandey]

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

[Nithin Eluvathingal]

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

2.12.0.0

[Elliot Dierksen · Accepted solution]

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