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

[Scott Voll]

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

output ended up looking like this:

linegroup                         dnorpattern hlog
================================= =========== ====
3rd Floor C                     3274        t
3rd Floor C                     3274        t
3rd Floor C                     3356        t
3rd Floor C                     3035        t
3rd Floor C                     3035        t
3rd Floor H                     8448        f
3rd Floor H                     8442        t
3rd Floor H                     8836        f
3rd Floor H                     8440        t
3rd Floor H                     8407        f
EA                                8231        f
EA                                8832        f
EA                                8832        f
EA                                8164        t
EA                                8164        f




On Tue, Mar 25, 2014 at 11:36 AM, Ryan Ratliff (rratliff) <
rratliff at cisco.com> wrote:

> Check out the devicehlogdynamic table.
>
> -Ryan
>
> On Mar 25, 2014, at 12:07 PM, Scott Voll <svoll.voip at gmail.com> wrote:
>
> is there a CLI SQL string that I can use to see who is "logged in" to
> there hunt group?  We use hunt groups extensively (plus UCCx also) but they
> want a way to see who is logged in at any given time. Right now it's a very
> manual process.
>
> Thanks
>
> scott
>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20140325/4cc26469/attachment.html>