How to access workload data without ST03N usage

[#1]

Hello everybody,

I want to generate a scipt which is automatically gathering monthly some specific information from ST03N. But seems that is not possible just with simple SQL, isn't it?

Which table do I have to search for? I am using 2004s and one told me that it is not table MONI anymore. DBA_TABLES contains a table that is called SAPWLMONI, is that the right one?

Maybe you know a report or an interface on how to read from the workload table? As far as I know it is in RAW format and needs to be uncompressed.

Thank you in advance for all your questions.

Best Regards

Waldemar B.

[Former Member]

Hello Waldemar,

> I want to generate a scipt which is automatically gathering monthly some specific information from ST03N. But seems that is not possible just with simple SQL, isn't it?

Correct.

> Which table do I have to search for? I am using 2004s and one told me that it is not table MONI anymore. DBA_TABLES contains a table that is called SAPWLMONI, is that the right one?

Until release 6x the workload data was stored in table MONI, since 7x table SWNCMONI is used. Table SAPWLMONI mentioned by you is used by an improved workload collector mechanism for releases before 7x.

> Maybe you know a report or an interface on how to read from the workload table?

There exists a blog of an SAP Developer: [How to read ST03N datasets from DB in NW2004|https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/6102] [original link is broken] [original link is broken] [original link is broken]; which should contain valuable information.

> As far as I know it is in RAW format and needs to be uncompressed.

Correct. Because of this you need the function modules mentioned in the blog to extract the data.

Regards, Michael