This 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: Lync users:
|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.
The latest version also lists Dial-in conferencing numbers and Exchange UM contacts.