I’m all about automating documentation, you might think it’s because I like writing documentation. Nope, like most others I loathe having to gather a produce documentation but I recognize it’s value and the reasoning for it. And I’ve been saved by it more than once.
That being said if I can automate it I will find a way. Having previously produced my Lync environment documentation scripts, I found I was missing information on a crucial Lync component; the Lync voice gateway. I primarily encounter a lot of AudioCodes gateways and they’re the ones I have the most experience with, so I chose to start with them.
I’m not opposed to expanding this to include Sonus, AcmePacket, or any of the other guys out there. I just don’t have any hardware or config files from those guys to use as reference.
This PowerShell script will take a standard AudioCodes voice gateway INI configuration file and convert it into an Excel workbook with formatted tables and column headers. The standard format for the INI config file can be tough to read, and hard to piece together. My goal here was to be able to quickly process the INI files into a format that makes more sense, is logically easier to follow, and easier to read; something like a spreadsheet.
I have included a couple screenshot examples for reference, but overall it is pretty straightforward to use. The command-line syntax is ‘New-ACConfigReport.ps1 Example_Config_Filename.ini’ This will automatically start Excel and start populating the data in the spreadsheet. By default the spreadsheet is saved into the same folder and uses the same base file name as the specified INI file. The above ‘Example_Config_Filename.ini’ becomes ‘Example_Config_Filename.xlsx’
I have tested this with Mediant 1000 and Mediant 3000 gateways, but it should hold up just fine as the format is pretty standard. There is some manual work afterwards in sorting the worksheet order, removing unnecessary worksheets, and adjusting some of the sorting but this should get you 98% of the way there.
You can download the script from the TechNet Gallery at the link below.