<html><head><base href="x-msg://106/"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>Start from the 6.1 data dictionary:</div><div><a href="http://www.cisco.com/en/US/customer/products/sw/voicesw/ps556/products_programming_reference_guides_list.html#anchor7">http://www.cisco.com/en/US/customer/products/sw/voicesw/ps556/products_programming_reference_guides_list.html#anchor7</a></div><div><br></div><div>The general construct is</div><div>hunt pilot->hunt list -> line group -> DN</div><div><br></div><div>so an example starting at the bottom of the chain. You want linegroups that are not used by any huntlist. unfortunately this is where a bit of old knowledge is required. The hunt pilot/hunt list/line group feature was copied from the route point/route list/route group feature. thus the underlying data storage is the same. In database terms this means</div><div>routelist->linegroup</div><div><br></div><div>So:</div><div>admin:run sql select name from linegroup<br>name <br>=========== <br>lg_1 <br>lg_2_unused </div><div><br>admin:run sql select name from linegroup where linegroup.pkid not in (select fklinegroup from routelist)<br>name <br>=========== <br>lg_2_unused <br><br></div><div><br></div><div>and keep building out from there.</div><div><br></div><div>/wes</div><div><br><div><div>On Mar 13, 2012, at 10:37 AM, Collins, Matthew wrote:</div><br class="Apple-interchange-newline"><div bgcolor="white" lang="EN-GB" link="blue" vlink="purple"><div class="WordSection1" style="page: WordSection1; "><div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="color: rgb(79, 129, 189); ">Hi All,<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="color: rgb(79, 129, 189); "><o:p> </o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="color: rgb(79, 129, 189); ">Is there a way to check if a line group is being used by a hunt list at all without going through all the hunt lists. There is no decency records available from the drop down. We are preparing for a upgrade and want to delete as much redundant config as possible.<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="color: rgb(79, 129, 189); "><o:p> </o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="color: rgb(79, 129, 189); ">This is on CUCM 6.1.3<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="color: rgb(79, 129, 189); "><o:p> </o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="color: rgb(79, 129, 189); ">Matt<o:p></o:p></span></div></div><div style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 0pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span><font size="1" face="arial,helvetica,sans-serif">_______________________________________________</font></span></div><p><span><font size="1" face="arial,helvetica,sans-serif">Any business communication, sent by or on behalf of Linklaters LLP or one of its affiliated firms or other entities (together "Linklaters"), is confidential and may be privileged or otherwise protected. If you receive it in error please inform us and then delete it from your system. You should not copy it or disclose its contents to anyone. Messages sent to and from Linklaters may be monitored to ensure compliance with internal policies and to protect our business. Emails are not secure and cannot be guaranteed to be error free. Anyone who communicates with us by email is taken to accept these risks.</font></span></p><p><span><font size="1" face="arial,helvetica,sans-serif">Linklaters LLP is a limited liability partnership registered in England and Wales with registered number OC326345. It is a law firm authorised and regulated by the Solicitors Regulation Authority (</font><a href="http://www.sra.org.uk/" target="_blank" style="color: blue; text-decoration: underline; "><font color="#0000ff" size="1" face="arial,helvetica,sans-serif">www.sra.org.uk</font></a><font size="1" face="arial,helvetica,sans-serif">). The term partner in relation to Linklaters LLP is used to refer to a member of Linklaters LLP or an employee or consultant of Linklaters LLP or any of its affiliated firms or entities with equivalent standing and qualifications. Please refer to<span class="Apple-converted-space"> </span></font><a href="http://www.linklaters.com/regulation" target="_blank" style="color: blue; text-decoration: underline; "><font color="#0000ff" size="1" face="arial,helvetica,sans-serif">www.linklaters.com/regulation</font></a><font size="1" face="arial,helvetica,sans-serif"><span class="Apple-converted-space"> </span>for important information on our regulatory position.</font></span></p><p><span><font size="1" face="arial,helvetica,sans-serif">A list of Linklaters LLP members together with a list of those non-members who are designated as partners and their professional qualifications, may be inspected at our registered office, One Silk Street, London EC2Y 8HQ and such persons are either solicitors, registered foreign lawyers or European lawyers.</font></span></p><p>_______________________________________________<br>cisco-voip mailing list<br><a href="mailto:cisco-voip@puck.nether.net" style="color: blue; text-decoration: underline; ">cisco-voip@puck.nether.net</a><br><a href="https://puck.nether.net/mailman/listinfo/cisco-voip" style="color: blue; text-decoration: underline; ">https://puck.nether.net/mailman/listinfo/cisco-voip</a><br></p></div></div><br></div></body></html>