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.