cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
4441
Views
0
Helpful
3
Replies

Export List of Directory Numbers, MAC address, End user names

yamikani2g2
Level 1
Level 1

Good day Experts,

 

I would like to pull out the following from the call manager, Phone MAC addresses, Extension numbers and end users names from Call manager in preferably a CSV file?

 

Thanks in advance.
 

3 Replies 3

Adam Pawlowski
VIP Alumni
VIP Alumni

I think this is going to depend on how you have deployed the system , as to if you can make some assumptions about the data you’ll receive. Disclaimer, I am speaking from my limited knowledge of the system.

 

The relationships you’re asking for don’t really exist like that in the UCM. 

 

Directory Numbers themselves are an object that are on their own, and don’t really tether to end users directly except via perhaps the primary extension (set in end user and not necessarily unique) or the directory URI (based on the primary extension for the automatic ones). If the descriptions are templated so they contain some identifying information then you could maybe use that. 

 

Devices can have line appearances of those DNs. Devices can have an owner ID which can be queried directly but not via search or API, which may be set to the user, and thus you can get extensions associated with that user this way. But see above that you won’t know which is theirs if there are multiple unless it matches their primary. There are associated end users with the line appearance for presence which you can get via API, but only through the device. It could also be queried from the DB.

 

The end user object has everything you want if you deployed everything in place though. The primary extension can be there , obviously user info, and controlled devices , if you populate that. It is not the same as a device owner ID though. If you did that then you can dump end users or use the getuser api , and just parse out the device names in whatever format you need. 

 

It is is a puzzle otherwise and not as easy to piece it together without knowing how things were (or weren’t) deployed.

Just to Add here,
Go to Bulk Administration -> Phones -> Export Phones.
1. Specific Details.
2. All details.
Using "Specific Details" option you can try to filter the export based on matching parameters like Device Type, Device Pool, Device Name, Description etc...based on your requirement and the phones you are looking for. Phone format needs to be defined as well, where you can choose the configuration fields that need to export.
"All Details" option lets you export based on Device Type.

- Rohan


You can also use Generate Phone Report:

  • Navigate: Bulk Administration Tool > Phones > Generate Phone Report
  • Use the "Find" to get the set of Phones you want to report on. Click Next.
  • In the "Device Fields" select MAC Address, and possibly "Description" or "Owner" or whatever field indicates the Name
  • In the "Line Fields" select Directory Number, and possibly "Alerting Name" or "Display" or whatever field indicates the Name.
  • Give your report a name at the top and run the job.

You will be able to download the CSV file from Upload/Download Files.

 

Maren