This document was generated from CDN thread
Created by: Michael Schmidt on 05-03-2013 02:05:23 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
Subject: RE: SQL directory number
Replied by: Michael Schmidt on 07-03-2013 02:41:47 PM
Can anybody help at this issue?
BR
Michael
Subject: RE: SQL directory number
Replied by: Michael Schmidt on 14-03-2013 05:29:46 AM
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
