[cisco-voip] Pick up groups with no members SQL quire CUCM 10.5

[Florian Kroessbacher]

Hy

i think u only have to following

select name from pickupgroup where pkid not in (select distinct fkpickupgroup from pickupgrouplinemap)
On 18. May 2021, 10:11 +0200, Matthew Collins <mcollins at block.co.uk>, wrote:
> Hi All,
>
> Can someone point me I right direction for a SQL query I can run to show me all pickup groups with no directory number associated with them.
>
> I had a search and can find a command that will return all pickup groups with their members.
>
> run sql select n.dnorpattern, n.description, pg.name as PickupName from numplan n join  pickupgrouplinemap pglm on n.pkid = pglm.fknumplan_line join pickupgroup pg on pglm.fkpickupgroup = pg.pkid
>
>
> I could work backwards from that output, but hoping someone has the knowledge to just show pickup groups with no members.
>
> Thanks in advance.
>
>
>
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20210518/eadafa08/attachment.htm>