XML payload table

[Former Member]

Hi PI gurus,

i want to know is there any table in PI which contains only message payloads which i can export to a spreedsheet.

Please help.

Thanks,

Regards,

Amarnath

[Former Member]

Dear Amarnath,

With a little effort you can search the same post .

SXMSPMAST is the Integration Engine: Message Queue (Master) table where XML messages resides.

You will get the payload in SXMSPMAST table but sorry to say not in XML format.

     The information will be in raw format in tables , which would not be easy to read.

For fetching data from sxmb_moni standard tables, refer this PDF.......

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/b050ff4f-84c3-2b10-3d99-8f9c44f57...

thanks and regards,

Anup Banerjee

[rajasekhar_reddy14]

SXMSPMAST table where messages were reside.

http://wiki.sdn.sap.com/wiki/display/XI/XI+Tables

[baskar_gopalakrishnan2]

You might want to check this wiki

http://wiki.sdn.sap.com/wiki/display/Snippets/PI+Monitoring+Functionality+-+Fetching+Data+from+SXMB_...