On a side note. I don't understand why this information not easily accessible. From my point of view a phone system should have a easy way of getting a list of numbers...
Sorry just venting ;)
SELECT vw_Subscriber.Alias, vw_DTMFAccessID.DTMFAccessID AS 'Extension', vw_DTMFAccessID.IsPrimaryID
FROM vw_Subscriber INNER JOIN vw_DTMFAccessID
ON vw_DTMFAccessID.ParentObjectID=vw_Subscriber.SubscriberObjectId
WHERE vw_Subscriber.SubscriberType IN ('1','3')
Reference...
I used to be able to run a sql querie for Display names / Extensions that I used to construct a directory list. With a recent upgrade (or someone removing it) the SQL View I used to query against is gone. How else can I get a list of extensions?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.