12-30-2008 10:17 AM - edited 03-15-2019 03:16 PM
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
12-30-2008 11:28 AM
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
12-31-2008 07:03 AM
Thanks for the info, it was very helpful.
12-30-2008 11:34 AM
Hi Chris,
There are helpful references from these great NetPros;
From Brad and Randy;
From Ginger;
Hope this helps!
Rob
12-30-2008 11:43 AM
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
12-30-2008 11:50 AM
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
12-31-2008 07:05 AM
Thanks to everyone that responded to the question, the info was extremely helpful.
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: