Voicemail Profile Reporting

[jasonfaraone]

I'm currently working on an environment where we still have some legacy users running on Unity. I'd like to migrate these users to Unity Connection, but I'm not sure which users are still using the legacy Unity voicemail profile. Is there some sort of report or query I can use to build a list of users still configured for our old voicemail environment?

[Jaime Valencia]

Use BAT to export line info and sort on the VM profile field.

[Brian Meade · Accepted solution]

You could run something like this from CLI:

run sql select np.dnorpattern,np.description,vmp.name from numplan as np left join voicemessagingprofile as vmp on np.fkvoicemessagingprofile=vmp.pkid

You can also filter for just a specific VM profile name:

run sql select np.dnorpattern,np.description,vmp.name from numplan as np left join voicemessagingprofile as vmp on np.fkvoicemessagingprofile=vmp.pkid where vmp.name = 'VoicemailProfileName'

[jasonfaraone]

This is exactly what I was looking for! Thanks!

[jasonfaraone]

Is there any chance you could expand the query to include the DN partition? The second one, in which you could filter by VMP.

[Brian Meade · Accepted solution]

run sql select np.dnorpattern as directorynumber,rp.name as Partition,np.description,vmp.name as voicemailprofile from numplan as np left join voicemessagingprofile as vmp on np.fkvoicemessagingprofile=vmp.pkid left join routepartition as rp on np.fkroutepartition=rp.pkid where vmp.name = 'VoicemailProfileName'

I'd suggest learning to use the CUCM data dictionary and learning some SQL as this can be a powerful tool for a lot of things- http://www.cisco.com/c/dam/en/us/td/docs/voice_ip_comm/cucm/datadict/8_0_1/datadictionary_801.pdf