Find all phones a line is on

Version 1

    Subject: RE: Find all phones a line is on
    Replied by: Gordon Ross on 08-10-2011 08:09:56 AM
    SELECT device.name, numplan.dnorpattern FROM numplan, device, devicenumplanmap WHERE device.pkid = devicenumplanmap.fkdevice AND numplan.pkid = devicenumplanmap.fknumplan AND numplan.dnorpattern='12345'

    GTG
    This document was generated from CDN thread

    Created by: MIKE WILCOX on 07-10-2011 04:51:40 PM
    Trying to find all of the phones a DN is on. Can someone help with an AXL request or a executeSQL statement that will return all the phones that have a particular number on it?
     
    This is for version 7.1.3 and we will be going to 8.6.2.
     
    Thanks!
     
    Mike

    Subject: RE: Find all phones a line is on
    Replied by: MIKE WILCOX on 10-10-2011 02:18:40 PM
    SELECT device.name, numplan.dnorpattern FROM numplan, device, devicenumplanmap WHERE device.pkid = devicenumplanmap.fkdevice AND numplan.pkid = devicenumplanmap.fknumplan AND numplan.dnorpattern='12345'

    GTG

    Gordon,
     
    This was spot on...Thanks!
     
    Mike