[cisco-voip] Line Groups

[Collins, Matthew]

Hi Wes,

Thanks for the WebEx to help figure this out,

For the rest of the group the command in 6.1 is


admin:run sql select linegroup.pkid,linegroup.name from linegroup where linegroup.pkid not in (select fklinegroup from routelist where fklinegroup is NOT NULL)



pkid                                 name
==================================== ===================
8164086e-d7e8-05a4-38d2-2c74e02b94cd NYC_ITSupport
9a52907f-ada2-fa6d-4111-71af2dae9fc1 Unused_line_Group_1
f31fed4c-0177-2832-73be-f25494f365ab unused_linegroup_2




On Mar 13, 2012, at 12:52 PM, Collins, Matthew wrote:

Hi Wes,

Thanks for you replying really appreciate your help,.

When I enter run sql select name from linegroup I get the results expected and it list 239 line groups. But when I enter run sql select name from linegroup where linegroup.pkid not in (select fklinegroup from routelist) the results seem to come back blank as I just get

name
===========
admin:


Am I being a idiot and missing something?

As a test I created a new line group and didn't add it to a Hunt list and when I ran the commands again the first one returned 240 groups but again the second command returned none.



_______________________________________________

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.
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 (www.sra.org.uk). 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 www.linklaters.com/regulation for important information on our regulatory position. 
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.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20120314/2c36b968/attachment.html>