Query for a listing of usernames and extensions?

[ddemers]

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?

 

[pndscm]

Do a Route Plan report. IF you have Usernames as Descriptions on the phones you'll see the information there.

 

[ddemers]

This gives me way too much information, and doesnt display the 'Display Names' from the Directory numbers.

 

[SuperRaton]

ddemers, can you tell us the sql querie that you used to Display names / Extensions???

 

[ddemers]

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:

http://www.ciscounitytools.com/CodeSamples/SQLQueryExamples.htm

I believe this is one of the scripts I used to use, however the View table in the SQL database no longer exists.

 

[ddemers]

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

 

[whykap]

Do you realizt that this query is for Unity as you see from the link you send us?
So are you looking for Unity info or call manager info?

the route plan report is what you need for call manager as pndscm adviced earlier. it is a csv file so you can always delete the info that is not necessary to you.

 

[ddemers]

Don't I feel like a tool. I always assume CallManager and Unity used the same Database.