Tuesday, May 24, 2011

How To Convert a ManagementPack to an Excel document.

Situation:
Your boss wants you to provide him/her with an Excel spreadsheet view of the rules inside a ManagementPack. There are hundreds of them in this ManagementPack and it will take you a solid week to do by hand.
Solution:
Inside the tools folder are two programs that address this issue. One produces the Excel information through automation.  It opens the ManagementPack, converts it to an XML file, opens Excel and populates the sheet with all the details of each area or group.
The other opens the ManagementPack, converts it to an XML file, creates an Excel spreadsheet file and populates it with all the details of each area or group.

3 comments:

  1. How is this helpful? Can you at least give names of those tools?

    ReplyDelete
  2. How is this helpful? Can you at least give names of those tools?

    ReplyDelete
  3. Which tools are you referring to? Are these part of the default install?

    I'm looking for a customisable way to export MPs to Excel. Currently there is only the option to do it via MPViewer, and a select few other PS scripts that export only limited information e.g. overrides

    Thank you.

    ReplyDelete