CUCM Shared Lines by Count

QueryStash

CUCM Shared Lines by Count

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

1SELECT numplan.dnorpattern,
2       routepartition.NAME,
3       Count(*)
4FROM   numplan,
5       devicenumplanmap,
6       routepartition
7WHERE  numplan.fkroutepartition = routepartition.pkid
8       AND numplan.pkid = devicenumplanmap.fknumplan
9GROUP  BY 1,
10          2
11HAVING Count(*) > 1
12ORDER  BY 1,
13          2

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

Public

cucm

Jeremy Worden

Created: Jan 18th 2023

QueryStash

Made with ❤️ by @Yekalb

Twitter Facebook Email

Resources

Blog Pricing Your First Query Search Your Stash

Examples

Merge Statements Persistent Functions Spike Detection QUALIFY Statement BigQuery ML Models

Stay up to date