[cisco-voip] MWI on

[Anthony Holloway]

I just ran this in my lab.  The SQL query is as follows:

select vw_subscriber.Alias, vw_notificationmwi.mwiextension from
vw_subscriber left join vw_notificationmwi on vw_subscriber.ObjectId =
vw_notificationmwi.SubscriberObjectId where vw_notificationmwi.mwiextension
= '+16125551212'

or if you want a partial search and match:

select vw_subscriber.Alias, vw_notificationmwi.mwiextension from
vw_subscriber left join vw_notificationmwi on vw_subscriber.ObjectId =
vw_notificationmwi.SubscriberObjectId where vw_notificationmwi.mwiextension
like '%5551212%'

The results will be a two column table containing the subscriber alias and
the matched MWI extension.


On Tue, Sep 10, 2013 at 3:12 PM, Sandy Lee <Sandy.Lee at dti.ulaval.ca> wrote:

> Oups, too late! I ran the search, It gave me 3 matches and went through
> their config and no one sends anything to my troubled extension.****
>
> ** **
>
> The MWI’s aren’t reachable by the phones, we had to change the CSS of the
> phone to turn it off. ****
>
> ** **
>
> Will try with User data dump.****
>
> ** **
>
> Thanks.****
>
> ** **
>
> ** **
>
> *From:* avholloway at gmail.com [mailto:avholloway at gmail.com] *On Behalf Of *Anthony
> Holloway
> *Sent:* 10 septembre 2013 16:03
> *To:* Sandy Lee
> *Cc:* cisco-voip at puck.nether.net
> *Subject:* Re: [cisco-voip] MWI on****
>
> ** **
>
> I was just watching the training video for CUDLI and at 9:30 in the video
> the man himself starts talking about searching with CUDLI and explicitly
> says not to do it on a production environment.****
>
> Video:http://ciscounitytools.com/TOI/CUDLI/CUDLI3.html****
>
> ** **
>
> On Tue, Sep 10, 2013 at 2:50 PM, Anthony Holloway <
> avholloway+cisco-voip at gmail.com> wrote:****
>
> Hi Sandy,****
>
> Alternate extensions are not used for MWI.  There's a special section for
> MWI extensions.  By default the MWI extension is inherited from the primary
> extension, but you can over ride it, or create new ones.****
>
>
> Did you see that you can perform a search in CUDLI?****
>
> *Searching for Data*
> Selecting the File | “Find value in current DB tables” option allows you
> to enter any string and it will search every column on every row in every
> table in the currently loaded database for either a full or partial string
> match based on what you enter.  As matches are found that table and row are
> loaded for you to view and you can select to continue searching from that
> point or stopping.****
>
> Source:
> http://ciscounitytools.com/Applications/CxN/CUDLI/Help/CUDLI.htm#_Toc346289230
> ****
>
> You should be able to just perform a search for your interesting phone
> number, and withing a few minutes (hopefully seconds), you should see all
> matches.****
>
> ** **
>
> On Tue, Sep 10, 2013 at 2:30 PM, Sandy Lee <Sandy.Lee at dti.ulaval.ca>
> wrote:****
>
> Hi everyone,****
>
>  ****
>
> I have a user which doesn’t have a voicemail, the extension does not exist
> on Unity Connection, and the voice mail profile is set to “No voicemail” in
> UCM, but the MWI is on. We checked in Alternate extensions, but no one
> seems to use that extension. ****
>
>  ****
>
> Can someone help me with CUDLI or anything else, I think I might be able
> to look into maybe some notifications that another user might have put in
> the wrong extension, but I really don’t know which table to look into.****
>
>  ****
>
> Thanks for your help.****
>
>  ****
>
> Sandy.****
>
> ** **
>
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip****
>
> ** **
>
> ** **
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20130910/cb1522ba/attachment.html>