Prepare a report from sxmb_moni messages

[Former Member]

Hi All

We need to send a daily report(Excel) to our client for an interface, which contains MessageID,date,timestamp of the message which appeared in SXMB_MONI and 3 more values(complex structure) of payload data for each successful and failure message in PI.

If some one have an idea on this please give helpful answer.

[Former Member]

Hi Nagaraju,

You can prepare an XSLT mapping as it easier to embed HTML content here. In  this XSLT mapping get the details you need and put it into a tabular format. You should be able to achieve this for a particular interface.

You can also make use of the below links to create a mail format and use mail adapter to send thru the email

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/9e6c7911-0d01-0010-1aa3-8e1bb1551...

Regards,

Sriram

[Former Member]

Hi Nagraj,

Choose the option export to Excel in SXMB_MONI page by selecting required interface, report covers message id ,time stamp and date.Could you please give more information on populating of payload values(Specifically any one of the field value).

Regards,

Anusha Penneru

[Former Member]

Hi Anusha,

Our requirement is getting three different field values from the payload(Complex Structure) for each message(successful or failed in PI) of an interface.I am unable to share the payload because of privacy rules.

[Harish]

Hi,

Did you check the below blog

regards,

Harish

[Former Member]

Hi Harish,

The requirement is for particular interface and we need payload values to populate in the Excel report along with MessageID,Date and Timestamp for successful and failure messages.