[cisco-voip] CLI command to pull hunt groups?

[Erik Goppel]

Gary,

Please share on the list, or unicast to me, if you would?
Thanks,

Erik  Goppel


On Thu, Mar 27, 2014 at 10:53 AM, Gary Parker <G.J.Parker at lboro.ac.uk>wrote:

> On 25 Mar 2014, at 19:54, Scott Voll <svoll.voip at gmail.com> wrote:
>
> > Thanks for getting me going in the right direction Ryan.
> >
> > Found this great blog:
> > http://www.ucguerrilla.com/2012/03/cucm-sql-queries-series.html
> >
> > Command worked great for us:
> >
> > run sql select lg.name as LineGroup, n.dnorpattern, dhd.hlog from
> linegroup as lg inner join linegroupnumplanmap as lgmap on
> lgmap.fklinegroup=lg.pkid inner join numplan as n on lgmap.fknumplan =
> n.pkid inner join devicenumplanmap as dmap on dmap.fknumplan=n.pkid inner
> join device as d on dmap.fkdevice=d.pkid inner join devicehlogdynamic as
> dhd on dhd.fkdevice=d.pkid order by lg. name
>
> We ran up a quick CGI script to display this sort of information for hunt
> groups on our system so that managers can see their respective groups'
> status. Screen shot here:
>
> http://delphium.lboro.ac.uk/Hunt_Group.jpg
>
> It also shows if the DN in question is logged in via Extension Mobility or
> not (more for my benefit than the managers').
>
> I'd be happy to share the code if anyone's interested.
>
> ---
> /-Gary Parker----------------------------------f--\
> |     Unified Communications Service Manager      |
> n       Loughborough University IT Services       |
> |     Tel: +441509635635  Mob: +447989172258      o
> |     http://delphium.lboro.ac.uk/pubkey.txt      |
> \r----------------------------------------------d-/
>
> _______________________________________________
> 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/20140327/bc432ddb/attachment.html>