[cisco-voip] CUC and Exchange Online migration

[Anthony Holloway]

RE: SQL to Check for VMPs

! Get a list of VMPs
run sql select name from voicemessagingprofile order by name asc
name
====================
Direct2VoiceMail
NoVoiceMail
Voicemail

! Get a summary of assignment
run sql select v.name, count(v.name) as count from voicemessagingprofile as
v left join numplan as n on v.pkid = n.fkvoicemessagingprofile group by
v.name order by count(v.name) desc
name                 count
==================== =====
Voicemail            43
NoVoiceMail          10
Direct2VoiceMail     1

! Get a detailed report of assignment
admin:run sql select n.dnorpattern, v.name from numplan as n left join
voicemessagingprofile as v on n.fkvoicemessagingprofile = v.pkid order by
v.name asc
dnorpattern                name
========================== ====================
*XXXX                      Direct2VoiceMail
2007                       NoVoiceMail
4055                       Voicemail
...output truncated...


On Tue, Mar 27, 2018 at 2:23 AM James Andrewartha via cisco-voip <
cisco-voip at puck.nether.net> wrote:

> Hi voipers,
>
> We're about to move all voicemail from Exchange 2013 on-prem to CUC, and
> then migrate to Exchange Online. We have the Unified Messaging from CUC
> to Exchange 2013 working fine, I found one post that said that things
> will just work(tm) when we start moving users to Exchange Online, is
> that correct or would I need to set up a separate Unified Messaging
> Service for it?
>
> Also is there an SQL query I can run in CUCM to determine which DNs have
> a custom Voice Mail Profile set?
>
> Thanks,
>
> --
> James Andrewartha
> Network & Projects Engineer
> Christ Church Grammar School
> Claremont, Western Australia
> Ph. (08) 9442 1757
> Mob. 0424 160 877
> _______________________________________________
> 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/20180327/1eb82098/attachment.html>