Message count in PI

[Former Member]

I want the number of messages flowing thru PI each day, we have over 600k msg flowing each day so when using the performance monitoring screen we get a time out, is there any other way to get the count? or can I get the count by going into the database tables, does anyone know which field to look for?

Thanks

[Former Member]

Hi,

You can check your message count in the above specified database tables

and also in Engine Monitoring of the Adapter Engine.

[Former Member]

Reduce the time range of the report and try. If you are pulling the number of messages processed per day for 14 days, try with 7 days twice for different weeks.

[Former Member]

Check the table : SXMSPMAST2

you would be able to find the number of messages per day..

[baskar_gopalakrishnan2]

Have you seen these links?