I recently published a post with a short script that creates an automated Excel file that lists all your Lync users. This file can be used in documentations and to find all your assigned phone numbers.
Getting some feedback from users and colleagues, I updated the script and it can now show all the users, common area phones, analog devices and Response Groups workflows in youe environment.
The Excel file is created with a separate tab for users, common are phones, analog devices and RGS workflows.
A built-in filter into every column will help you find the information you need based on registrar, analog gateway, username, etc.
The file lists the following for each tab:
|Display Name||SIP Address||Registrar Pool||Enterprise Voice||Line URI|
|Display Name||SIP Address||Registrar Pool||Gateway||Line URI|
Common Are Phones:
|Display Name||SIP Address||Registrar Pool||Description||Line URI|
|Display Name||SIP Address||Line URI|
Run the script from your client machine (NOT Your Lync servers), where you have Excel (At Least 2010) and PowerShell version 3.0 and above.
The script will ask you for your Lync Admin credentials and one of your Lync pools’ FQDN:
It will then connect remotely to you server and start Excel. The script is designed to ignore certificate certificates warnings as you might be running this from a none domain-joined machine.
Download the script here.