Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
New Member

Voicemail Profile Reporting

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?

2 ACCEPTED SOLUTIONS

Accepted Solutions

You could run something like

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'

run sql select np.dnorpattern

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

5 REPLIES
Cisco Employee

Use BAT to export line info

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

HTH

java

if this helps, please rate

www.cisco.com/go/pdi

You could run something like

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'

New Member

This is exactly what I was

This is exactly what I was looking for! Thanks!

New Member

Is there any chance you could

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

run sql select np.dnorpattern

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

130
Views
10
Helpful
5
Replies
CreatePlease to create content