SQL directory number

Version 1
    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