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.par...@lboro.ac.uk>wrote: > On 25 Mar 2014, at 19:54, Scott Voll <svoll.v...@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@puck.nether.net > https://puck.nether.net/mailman/listinfo/cisco-voip > >
_______________________________________________ cisco-voip mailing list cisco-voip@puck.nether.net https://puck.nether.net/mailman/listinfo/cisco-voip