This post demonstrate a way to semi-auto to extract ESR objects into one big XML document, then programmatically parse the xml and create ESR object listing documentation in excel format. This is an easy way to have good overview of all relevant ESR objects in one excel sheet.

 

The steps:

1. Go to http://<<hostname:>><<port>>/rep/support/SimpleQuery
Choose “all software components”, tick “Show request XML” and “Show response XML”. Response XML will be used as source to generate excel documentation.esr_simple_query_01

 

2. Select all result attributes. The script coded in such way that only work properly if all fields is selected.
esr_simple_query_03

 

3. Choose “Operation Mapping”. This simple query will query all other ESR objects that have relationship with the Operation mapping listed. Click “Refresh depended values”.
esr_simple_query_02

 

4. An huge HTML table will generated with many table and columns. However, all the data in html table is actually come from below “Response XML” at the bottom of response html page. Copy all response XML, saved to a file. Example “ESR.xml”.
esr_simple_query_04

5. Execute below Powershell code in Powershell editor. Change the “ESR.xml” to the path you desired. Default is “C:\TEST\ESR.xml”.

 

6. The output of script is CSV file. Open the csv file using excel, create pivot table based on all columns and arrange it the way you like it. The end result is an excel documentation contain all ESR object relevant to each Operation Mapping.esr_simple_query_excel

Keep on learning! 🙂

SAP PI ESR Simple Query Documentation using Powershell
Tagged on:         

2 thoughts on “SAP PI ESR Simple Query Documentation using Powershell

  • September 22, 2017 at 1:39 am
    Permalink

    Awesome! Never heard about this hidden tool. Really helpful, thank you!

    Reply
    • September 25, 2017 at 7:46 pm
      Permalink

      You’re welcome, Phil. 🙂

      Reply

Leave a Reply

Your email address will not be published.

Time limit is exhausted. Please reload CAPTCHA.