locating a unity voicemail alternate extension

[clsnyder10]

I am trying to locate an extension which is an alternate extension in unity but do not know the primary extension to the box. Is there a way to locate the alternate without clicking on every box and then clicking on alternate extension? thanks

[Chris Deren]

You can run the following SQL query against the UnityDb database:

select dbo.Subscriber.Alias from dbo.Subscriber, dbo.DtmfAccessId

where DtmfAccessId = 'XXXX'and ParentObjectId = SubscriberObjectId;

where XXXX is the alternate extension. This will return the corresponding alias.

HTH,

Chris

[clsnyder10]

Thanks for the info, it was very helpful.

[Rob Huffman]

Hi Chris,

There are helpful references from these great NetPros;

From Brad and Randy;

http://forum.cisco.com/eforum/servlet/NetProf?page=netprof&forum=Unified%20Communications%20and%20Video&topic=Unified%20Communications%20Applications&CommCmd=MB%3Fcmd%3Dpass_through%26location%3Doutline%40%5E1%40%40.2cc210d7

From Ginger;

http://forum.cisco.com/eforum/servlet/NetProf?page=netprof&forum=Unified%20Communications%20and%20Video&topic=Unified%20Communications%20Applications&CommCmd=MB%3Fcmd%3Dpass_through%26location%3Doutline%40%5E1%40%40.2cc1298b/0#selected_message

Hope this helps!

Rob

[Chris Deren]

Rob,

Again great job with research, but these ways force you to still look through the output, my query returns the alias immediately, so I guess you save couple of minutes :-)

Chris

[Rob Huffman]

Hey Chris,

Happy Holidays buddy! This does look like an excellent method. Anything that saves time and narrows these searches down is a great thing in my books. +5 points for this Chris.

Cheers!

Rob

[clsnyder10]

Thanks to everyone that responded to the question, the info was extremely helpful.