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]

Chris - did you ever find a BAPI for Solution Manager; how did your interface with the database go?