Lets Excel : Enhanced Communication Channel search in SAP PI

[sunilchandra007]

1. How many file channels are using file content conversion?

2. How many channels are using OS command?

3. Identify the channels that are using a particular adapter module in module configuration?

4. How many channels are configured with variable substitution?

5. List out the email ids configured in the mail channels along with business component?

There are many more possibilities of such questions.

Have you ever come across these kinds of questions before? If yes, then you know already how tedious it is to answer without properly updated documentation. Even if it is documented, it takes time to figure out the exact details. And what if you don't have any documentation? Don't worry. There is no need to check each and every channel from now on.  Yes, it's possible now with an Excel application in a couple of seconds.

Pre-Requisite for using the application

User must be assigned with following roles in java stack

1. PI <= 7.0 - Api_display

2. PI > = 7.1 - SAP_XI_API_DISPLAY_J2EE

How to use

1. Download the Excel. Open it and enable macro.

2. Press ALT + F11 > Tools > References > Select the required library > click OK > close the window

3. Click Search Screen button on Search sheet  to open the form

4. Click SID label available at left top to System Configuration window

5. Enter the details SID host:port username password > Click Add System

This is a memory extensive step, so wait till it gets completed.

6. Click Back to Filter Screen.

7. Select the SID from the dropdown.

The channel search is ready to use now. Please note that this is kind of local search that works on downloaded channel details.

Also you can play around with search query by checking Run manual query.

Now you have the solution :smile:

*********************************************************************

1. How many file channels are using file content conversion?

SID > AdapterType = File > MessageProtocol = FileCSV > Search

2. How many channels are using OS command?

Run OS Command before message processing 

SID > AdapterType = File > AttributeName = file.preprocess.execute > AttributeValue = % > Search

Run OS Command after message processing 

SID > AdapterType = File > AttributeName = file.execute > AttributeValue = % > Search

Or simply.. SID > AdapterType = File > AttributeName = file%execute > AttributeValue = % > Search

3. Identify the channels that are using a particular adapter module?

SID > ModuleName = selectedValue > Search

4. How many channels are configured with variable substitution?

SID > AttributeName = file.varSubstitution > AttributeValue = 1 > Search

5. List out the email ids configured in the mail channels along with business component?

MailTo  SID > AttributeName = Mail.MailTo > AttributeValue = % > Search

MailCc   SID > AttributeName = Mail.MailCc > AttributeValue = % > Search

or simply  SID > AttributeName = Mail.Mail%  > AttributeValue = % > Search

*********************************************************************

I hope this tool would help you capturing communication channel details easily, increase productivity and improve the way you work. 

At end, special thanks to iliya.kuznetsov2/blog for his blog Simple reporting over PI communications channels that motivated me for this creation.