Extract data from Solution Manager database

[boobboo]

Hi,

I am investigating the possibility of using SQL to extract alert data

from the Oracle database directly.

I have looked in the database to find the tables which would provide

such information, and I have found some promising tables.

But I need to understand how the data is stored in the Solution Manager

system, I see that once the solution manager application is started it

pulls the data from the CCMS alerts on the remote systems. But that

data needs to be stored somewhere. Can you tell me if it is buffered in

an internal table or a structure.

Is it possible to use the SAP tables to produce such a report, or which

BAPI's can I use to extract the data.

Thanks

Chris aka BoobBoo

[Former Member · Accepted solution]

Hi Chris:

If you want to interact with the Alerting data, you should use the XAL External Interface for Alert Management.

You can find the additional information and also the XAL BAPI guide in SAP Service Marketplace under System Monitoring.

Hope this helps!

Federico G. Babelis

NetWeaver Certified Consultant

GAZUM Technologies S.A.

Consulting Services and Software Solutions

http://www.gazum.com

...download FREE Marketplace Manager at: http://www.gazum.com/products