(Have a look at the newer, smarter, prettier, fancier version of this script here.)
This script isn’t big news, but it’s very handy and easy to use.
It allows you to remotely connect to one of your pools and create an Excel sheet, populated with the following:
| Display Name | SIP Address | Registrar Pool | Enterprise Voice | Line URI |
It’s basically a list you can hand to your customers and colleagues so they can keep track of changes.
Additionally, it helps spot Enterprise Voice enabled users that don’t have a Line URI or it’s misconfigured.
When you run the script it’ll ask your for your Credentials – You must Have appropriate Lync permissions:
It will then ask you for the FQDN of your Lync server or pool and will attempt to connect:
When connected, the script will immediately start creating the Excel file:
You can scroll up and down the Excel file but do not click anywhere on the spreadsheet. This causes the automated build to crash, and you’ll have to restart the script.
When completed, the script will notify you and close the remote PowerShell session it initiated.
The pace is approx. a second per line, so if you have 5000 users this is the time to go and grab a cup of coffee.
The script can be downloaded here.
Updated October 7, 2014: Version 2.0 checks for your PS version. This script will only run on PS 3.0 or higher.
Very handy.
it is not working on my 2010 Enterprise, any ideas?
Hi kalam3adi,
Make sure you’re running this from a computer that has Microsoft Excel installed on it.
I tried it from my laptop on the same domain, got errors through the powershell despite I have Excel installed!
Tried from the front end, Yes it has no Excel installed but it almost returned the same error as from my laptop.
What’s the error message you’re getting?
I will copy and paste the errors when I get to the office in about 10 hours 🙂
I just tried to run and here’s what I get
File D:\Users\xxxx\Desktop\LyncUsersExcel.ps1 cannot be loaded. The file D:\Users\xxxx\Desktop\LyncUsersExcel.p
s1 is not digitally signed. The script will not execute on the system. Please see “get-help about_signing” for more det
ails..
At line:1 char:45
+ D:\Users\abdelham\Desktop\LyncUsersExcel.ps1 <<<<
+ CategoryInfo : NotSpecified: (:) [], PSSecurityException
+ FullyQualifiedErrorId : RuntimeException
found the file was blocked by explorer as protection
when unblocked I ran the script and here’s what I got
Missing property name after reference operator.
At D:\Users\xxxx\Desktop\LyncUsersExcel.ps1:23 char:43
+ Write-Host Connecting to Pool $LyncServer. <<<< .. -ForegroundColor Yellow
+ CategoryInfo : ParserError: (.:String) [], ParentContainsErrorRecordException
+ FullyQualifiedErrorId : MissingPropertyName
Hi kalam3adi,
Mu guess is that you’re using an old(er) version of PowerShell. This script runs on PS 3 and 4.
You can run $PSVersionTable on your machine to determine the version you’re using.
Thanks for your feedback!
Yes it old
2.0
any idea how to get it working???
You’ll have to update PowerShell:
http://technet.microsoft.com/en-us/library/hh847837.aspx
OK
Upgrading the powershell worked well, however I still have some errors
pool1.xx.xx.xx failed with the following error message : The server
certificate on the destination computer (pool1.xx.xx.xx:443) has the following errors:
The SSL certificate could not be checked for revocation. The server used to check for revocation might be unreachable. For more information, see the
about_Remote_Troubleshooting Help topic
one thing that I must mention, I have 2 FE servers and one backend.
The pool spans the 2 servers.
is that going to make a difference???