cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements
Walkthrough Wednesdays
228
Views
0
Helpful
1
Replies
mmusysnet
Beginner

AXL - Query LineGroups for specific DN

I'm trying to figure out if there is a simple approach to locating which LineGroups a particular Directory Number is associated with without a listLineGroup and searching the members, is this possible with SOAP AXL or using SQL or will I have to listLineGroups and expand on the members seperately (or am i trying to simplify an already simple process)

1 REPLY 1
Anthony Holloway
Cisco Employee

You could use SQL via AXL to run the following query:

select n.dnorpattern as dn, l.name as linegroup from linegroupnumplanmap as m left join numplan as n on m.fknumplan = n.pkid left join linegroup as l on m.fklinegroup = l.pkid where n.dnorpattern = ''

Anthony Holloway

Please use the star ratings to help drive great content to the top of searches.

Content for Community-Ad

Spotlight Awards 2021