Administration XML Developer Forums

« Back to Administration XML Questions

Finding Line Groups witch belong to Hunt Lists

Combination View Flat View Tree View
Threads [ Previous | Next ]
toggle
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

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

...

Works perfect.

Tank you very much,

Marcus