8

Lync 2010 VCFG Converter

One of my colleagues approached me a couple of weeks ago about creating a scripted solution to extract the data from a Lync VCFG Voice Configuration File. Traditionally the time and work involved in documenting a Lync voice deployment was a manual process, and I like to automate these things where I can. I’ve been working with VBScript and JavaScript in Windows Environments for a few year now. I had toyed around with Powershell, but this was the first real script that I’ve built. This is also my first chance to work with Powershell integration with Excel and XML data structures. I tried to keep it as clean and simple as possible. So here we go…

  • Export your VCFG from the Lync Control Panel.
  • Place the VCFG in the same folder as the LyncVCFGConverter.ps1 file.
  • Open the Powershell Command Windows and navigate to the directory where you have the files stored.
  • The syntax for running the script is .\LyncVCFGConverter.ps1 ConfigFileName.VCFG
  • The script will automatically start processing the VCFG file and extract the data from it.
  • Upon completion it will save the Excel spreadsheet and open it.
  • The information is separated into the following tabs: Location Profiles, PSTN Usages, PSTN Routes, Voice Policies, and Trunk Configuration

It’s a pretty simple straight forward process, and it includes status updates along the way. I will get some screen shots posted with more information later today.

Download LyncVCFGConverter.ps1