Generating daily reports

[#1]

Dear all,

I've to find out how to automate generating reports of MessageProcessing. Initially the data provided by the RWB Performance Monitoring would be fine. I can drill down it to every sender/receiver interface and select the data on a daily basis. But I don't want to "click" every day on theses buttons.

Has anyone a suggestion how I can automate this or how to access the relevant DB-Tables to generate a report?

Kind regards, Stefan

[jrlopez · Accepted solution]

Hi Stefan,

these links may help you:

[Exposing the XI monitoring functionality as a Web Service|https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/909760cb-0ec8-2a10-4a96-ee8417acfbc9]

[Finding the PI message with the NF-e Access Key|https://wiki.sdn.sap.com/wiki/x/zIDmAQ]

[Interesting ABAP tables in XI|https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/8032] [original link is broken] [original link is broken] [original link is broken];

[PI Monitoring Functionality - Fetching Data from SXMB_MONI Standard Tables - Part I|https://wiki.sdn.sap.com/wiki/x/w4MQB]

Regards,

Josu00E9 Rau00FAl Lu00F3pez

[Former Member]

Hi Stefan Schumacher,

If a weekly report would serve your purpose then, I suggest configure Early Watch Alert Report (EWA) for your environment.

This report gives you comprehensive overview of messages processes per Buisness Interface with details like, Sender, Receiver, Number of messages, Total Processing Time and Average Processing Time etc.

Apart from this specific requirement, a lot about your system you can view through this EWA.

I hope this will help your requirement.

Regards

Sekhar