Solved: MWI light is still on after mailbox has been deleted

Burney Rogers · ‎10-17-2012

I have ext 2011 and 2174 phone with MWI light is on after the mailbox has been deleted. I suggust the tech to check for 2011 and 2174 alternate extensions in the other mailboxes that are in that partion. Is there away to check other than checking individual mailboxes to check alternate extensions.

Thanks

William Bell · ‎10-17-2012

As is par for the course, Rob and Jonathan have provided very viable options (+5 to those guys). Being the odd ball, I like to go a different path. I would SSH to console of the Publisher node and execute the following command:

admin:run sql update numplandynamic set tklampblinkrate_messagewaiting='1' where fknumplan=(select pkid from numplan where dnorpattern='2011')

Where '2011' is the extension you want to toggle off.

This query assumes you are running CUCM 6.x or later. Haven't checked CUCM 5.x and I know the schema in 4.x and earlier handles this differently.

HTH.

-Bill (http://ucguerrilla.com)

HTH -Bill (b) http://ucguerrilla.com (t) @ucguerrilla

Please remember to rate helpful responses and identify

View solution in original post

Rob Huffman · ‎10-17-2012

Hi Burney,

It's quite common for the lamp to remain lit if there were

new messages when the mailbox was deleted. You can either

re-create mailboxes for 2011 & 2174, leave a new message on each,

check and delete the message before deleting the mailbox or

go to the extension and dial the MWI-OFF number.

If you need to know how to find the MWI-OFF number just let us know

what system you are using for call control.

Cheers!

Rob

"May your heart always be joyful
May your song always be sung" - Bob Dylan

Jonathan Schulenberg · ‎10-17-2012

Another trick is to temporarily add those extensions as additional MWI Destinations on a mailbox that currently has it's MWI off, then force a synchronization of MWIs system-wide. Once the MWI is off on those extensions just delete them from the surrogate mailbox.

Please remember to rate helpful responses and identify helpful or correct answers.

William Bell · ‎10-17-2012

As is par for the course, Rob and Jonathan have provided very viable options (+5 to those guys). Being the odd ball, I like to go a different path. I would SSH to console of the Publisher node and execute the following command:

admin:run sql update numplandynamic set tklampblinkrate_messagewaiting='1' where fknumplan=(select pkid from numplan where dnorpattern='2011')

Where '2011' is the extension you want to toggle off.

This query assumes you are running CUCM 6.x or later. Haven't checked CUCM 5.x and I know the schema in 4.x and earlier handles this differently.

HTH.

-Bill (http://ucguerrilla.com)

HTH -Bill (b) http://ucguerrilla.com (t) @ucguerrilla

Please remember to rate helpful responses and identify

Rob Huffman · ‎10-18-2012

Hey Bill,

I would use your method as well if I had your skillset (which I sadly don't)

+5 to both you and Jonathan for these great tips my friend!

Cheers!

Huff

PS: I'll have to spend more time studying your excellent SQL/queries

blog series

"May your heart always be joyful

May your song always be sung" - Bob Dylan