Export Directory Number and Voicemail Profile using BAT

[kbeelwar]

Hi,

I want a list of DN with their individual voicemail profile

how can I get this in excel sheet?                  

[Leo Salcie Tejeda]

Hi Kada,

Go to Bulk administration-> Export Phones->All Details.

You will export all lines assign to each phone so look for the VoicemailProfile tab, that will show you which Voicemail profile is assigned..

Please remember to rate useful posts clicking on the stars below.
Favor calificar todos las respuestas útiles dando click en las estrellas de mas abajo.
___________________________________________
LinkedIn Profile: do.linkedin.com/in/leosalcie

[kbeelwar]

This just gives the phone associated extension but misses the device profile extensions.

we use the device profile extensively.

Is there a way to get both?

Thanks for helping!

[Leo Salcie Tejeda]

(Remember to rate useful post )

There's no way to get both on the same export file but you can export Device Profile. Follow this procedure:

Step 1

Choose one of the following options:             Choose                        Bulk                               Administration > User Device                               Profiles > Export User Device                               Profiles > Specific Details.                       The                        Find and List User Device Profiles To Export                       window displays. Choose                        Bulk                               Administration > User Device                               Profiles > Export User Device                               Profiles > All Details.                       The                        Export User Device Profiles Configuration                       window displays.

Step 2

For                  All Details option, choose the type of device                 or specific model from the                  Device Type drop-down list box. Skip to                  Step 4.

Step 3

For                  Specific Details option, you can customize the                 export file and set any of the following detail options:             Choose                        Device Type and                        Device Protocol from the drop-down list                       boxes. In the first                        Find a User Device Profile drop-down list                       box, choose from the following options:                                             Profile Name Profile                               Description In the second drop-down list box, choose from the following                       options:                                             begins with contains is exactly ends with is empty is not empty In the search field box, enter the value that you want to                       locate, such as a specific profile name or profile description. You can click the                        Search Within Results check box and choose                                              AND or                        OR to add multiple filters and repeat                        3.b through                        3.d to further define your query. Click                        Find. The search results display. Click                        Next. Choose file format from the                        File Format drop-down list box.

Step 4

In the                  File Name field, enter the file name that you                 want to use.

Step 5

In the                  Job Information area, enter the Job description.

Step 6

Choose an export method. Do one of the following:              Click                        Run Immediately to export user device                       profiles immediately. Click                        Run Later to export user device profiles                       at a later time.

Step 7

Click                  Submit to create a job for exporting user                 device profiles.               Use the Job Scheduler option in the                  Bulk Administration main menu to schedule and/or                 activate this job.

Please remember to rate useful posts clicking on the stars below.
Favor calificar todos las respuestas útiles dando click en las estrellas de mas abajo.
___________________________________________
LinkedIn Profile: do.linkedin.com/in/leosalcie

[Dennis Mink]

Why dont you use dependency records?  go to your voice mail profile and right top select "dependency records:  and that will give you all  extension that use it. be it UDP's or not.


=============================
Please remember to rate useful posts, by clicking on the stars below. 

=============================

[Aaron Harrison]

Hi

Run this from the server CLI in putty - log it to text.

run sql select first 10  d.name,d.description,n.dnorpattern,n.description as linedescription,n.cfbdestination,n.cfbintdestination,n.cfbvoicemailenabled,n.cfnadestination,n.cfnaintdestination,n.cfnavoicemailenabled,vm.name,e.userid from numplan n join devicenumplanmap dnm on n.pkid = dnm.fknumplan join device d on d.pkid = dnm.fkdevice left join voicemessagingprofile vm on n.fkvoicemessagingprofile = vm.pkid left join enduserdevicemap edm on d.pkid = edm.fkdevice left join enduser e on edm.fkenduser = e.pkid  order by d.name

You can then import the resulting data into Excel.

Regards

Aaron