cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
272
Views
0
Helpful
1
Replies

AXL - Query LineGroups for specific DN

mmusysnet
Beginner
Beginner

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
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.

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community:

Recognize Your Peers