Finding Line Groups witch belong to Hunt Lists

Version 1
    This document was generated from CDN thread

    Created by: MARCUS STOLZENBERG on 05-10-2011 07:11:26 AM
    Hi,
     
    I am running CUCM 4.2.x
     
    Now I look for some information about Huntlists und Linegroups.
     
    I have no problem to find all my Huntlists
    I have no problem to find all my Line Groups
     

     
    But I did not find a solution to find all Line Groups who belong to a Huntlist (with Line Groupe order information)
     
    Best regards,
    Marcus

    Subject: RE: Finding Line Groups witch belong to Hunt Lists
    Replied by: MARCUS STOLZENBERG on 05-10-2011 07:55:08 AM
    ...

    Works perfect.

    Tank you very much,

    Marcus

    Subject: Re: New Message from MARCUS STOLZENBERG in Administration XML (AXL) - Admin
    Replied by: Sascha Monteiro on 05-10-2011 07:33:30 AM
    haven't looked in detail, but try this;
    run sql select d.name as dname,l.name as lname, r.selectionorder from routelist r join device d on (d.pkid = r.fkdevice) join linegroup l on (l.pkid = r.fklinegroup)

    add your where clause if required