« Back to Administration XML Questions

SQL directory number

Combination View Flat View Tree View
Threads [ Previous | Next ]
SQL directory number
Answer
3/5/13 8:05 PM
Hi all,
I need a SQL query which display these information:

- all directory numbers
- partition
- description
- Associated Devices (phone or device profile)
- Call Pickup Group


 
Can anybody help me in this case?
BR
Michael
Flag

RE: SQL directory number
Answer
3/7/13 8:41 PM as a reply to Michael Schmidt.
Can anybody help at this issue?
 
BR
Michael
Flag

RE: SQL directory number
Answer
3/14/13 10:30 AM as a reply to Michael Schmidt.
Sorry for asking again. Can anybody help in this case or is there no chance to get these data via SQL?
With this SQL I can export all DN assigned to Pickup Groups but not all DN without Pickup Group and the partition and the assigned phone
 
select n.dnorpattern, n.description, pg.name from numplan n join  pickupgrouplinemap pglm on n.pkid = pglm.fknumplan_line join pickupgroup pg on pglm.fkpickupgroup = pg.pkid
 
BR Michael
Flag