We have managed to delete the voicemail message by query the "MailboxObjectId=<>" from table "tbl_Folderitem" .
Though the message is cleared but the mwi status is still on .
Any input would be appreciated.
We are using unity connection v1.2
I gotcha. So, it's not a one-off situation - it's something you want to implement for a purpose. I'll have to think on this one. It may work but I think there may be issues with the sync between CUCM and Unity in either case primarily because your plan is to access SQL directly and delete the message and/or also set the MWI flag. In theory, it may sound like a plan but in function - there are a few steps that occur and set off different processes that handle all of this stuff when a user deletes a message themselves. In other words, some of the service accounts that work in the background MAY not (not 100% positive, just thinking out loud for you) do their "job" because SQL is being accessed directly - bypassing the normal process flow. I'll give some thought and re-post if I can think of something that may be of assistance.
Please rate helpful posts!