08-10-2010 07:50 PM - edited 03-19-2019 01:23 AM
Dear Expert,
The setup is using Cisco Unity 7.0 Build 7.0(2). Currently, I'm experiencing one of my user, who is the non-UNITY subscriber DN (e.g. DN 8409) has its MWI and envelope icons turned on.
I'm suspecting mis-configuration on the Unity that someone has accidentally included this DN 8409 on a UNITY subscriber MWI extensions.
What/how is the best way to search for this mis-config?
Thank you for reading this question and appreciate your reply.
.wan
Solved! Go to Solution.
08-10-2010 08:13 PM
Hi Wan,
I put together this query; give it a shot using Data Link Explorer from the Tools Depot under Diagnostic Tools. Once launched click View>Query Builder and paste it in, or you can just use SQL Query Analyzer from Enterprise Manager.
SELECT parentalias, mwiextension FROM notificationmwi WHERE mwiextension = '8409'
This will display the alias that would have 8409 configured as an MWI extension
Hope that helps,
Brad
08-17-2010 03:13 AM
Sounds like whoever ran it most likely ran it on the 'masterdb' from SQL Query Analyzer instead of running it on the UnityDB (Unity's database). Make sure it's ran on the UnityDB, an easy way to confirm it's done on the UnityDB is to run the query in Data Link Explorer as I initially explained if it wasn't tried already.
08-10-2010 08:13 PM
Hi Wan,
I put together this query; give it a shot using Data Link Explorer from the Tools Depot under Diagnostic Tools. Once launched click View>Query Builder and paste it in, or you can just use SQL Query Analyzer from Enterprise Manager.
SELECT parentalias, mwiextension FROM notificationmwi WHERE mwiextension = '8409'
This will display the alias that would have 8409 configured as an MWI extension
Hope that helps,
Brad
08-10-2010 08:24 PM
Hello Brad,
Very appreciate your response. As I only have Web access to the Unity, I'll bring this steps to the Unity Admin, who has access to the OS level.
Thank you very much.
.wan
08-17-2010 02:46 AM
Hello Brad,
After running the query, we got the following error:
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'notificationmwi'.
Do you have further comment?
Thank you,
.wan
08-17-2010 03:13 AM
Sounds like whoever ran it most likely ran it on the 'masterdb' from SQL Query Analyzer instead of running it on the UnityDB (Unity's database). Make sure it's ran on the UnityDB, an easy way to confirm it's done on the UnityDB is to run the query in Data Link Explorer as I initially explained if it wasn't tried already.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide