Alert configuration - interface based

[Former Member]

Hi,

I have the below requirement - Please help.

There has to be a report or mail to be generated with the count of messages that have been processed in XI per day.

The count has to be grouped by the Business service & Business system names.

We need this report to analysis on load that XI received in production system.

Regards,

Subbu

[Former Member]

Hi Subbu,

Below are some of the tables where you get the data for the messages.

Transaction Codes - (SE11, SE 16)

SXMSPMAS XI Messages - Master

SXMSPHIST XI Messages - Master History table

SXMSPEMAS Integration Engine: Enhanced Message Queue (Master)

SXMSPVERS Integration Engine: Message Version

SXMSPERROR XML Message Broker: Message Queue (Incorrect Entries)

SMPPMAP3 Mapping Runtime: Mapping

SMPPREL3 Mapping Runtime: Mapping Relation

SMPPSPLIT XI Mapping: Merge and Split

SXMSPFRAWH Integration Engine - Header Table for Raw Data for Performance Evaluation

SXMSPFRAWD Integration Engine: Data Table for Raw Data for Performance

Adapter Engine Tables -

Schema Name - SAPSR3DB

XI_AF_MSG AF XI Message

XI_AF_MSG_AUDIT audit log entries

If runing on PI 7.1, table names are as follows -

BC_MSG AF PI 7.1 Message

BC_MSG_AUDIT PI 7.1 audit log entries (**)

Thanks,

[Former Member]

Hi,

go to Runtime Workbench --> Performance Monitoring

Fabio