PowerShell script to export #Lync tbxml to Visio and Excel

Update June 28 - Want to see what happens when your personal blog recieves professional editing? See this post on Next Hop - http://blogs.technet.com/b/nexthop/archive/2012/06/28/how-to-create-visio-and-excel-output-from-a-tbxml-file.aspx

I encountered a customer deployment in Office365 Dedicated where I needed to gain clarity on their deployed Lync topology. It was rather easy to ask the team for the Topology Builder output – tbxml but reading that in raw text is not preferred and while I installed the Topology Builder and could view it, that too is not what I wanted to see.

I did a quick search and found a blog that read as exactly what I wanted: Making sense of a TBXML

To resolve the unsigned script I recalled I needed to change a “permission” and ultimately found the syntax here  Be mindful to Start PowerShell using ‘Run as Administrator’

Set-Executionpolicy -ExecutionPolicy Unrestricted

Trying to run the script immediately resulted in lots of errors and no exported content. I grabbed Office 2010, Visio 2010 and the Visio Templates as required and found success.

Here are screen shots of the Excel


Lync Sites and Servers tab, more content exists than what is shown



Management Info tab



Services tab, more content exists than what is shown


Visio Screen Shot



This was a great hour or two diversion from my normal project management duties and glad the script delivered what it promised.