In this small blog, I will share a script that I have created together with Jeroen Vonk and Dennis Straathof. The script will take all the descriptions of every task, module, and project in your runbook. And put them in a CSV/Excel file or SQL database. The script requires a Building Block (XML) as input. You can create this building block from the console by clicking right-mouse on the runbook and select “Building Blocks -> Create Building Blocks” or you can also do this with PowerShell with the following command:
To create an Excel file from the script, use the -excel parameter. This will require the PSExcel module. If you don’t have this installed the script will install it for you. This does require an internet connection and PowerShell 5.
I hope this was informative. For questions or comments, you can always give a reaction in the comment section or contact me: