Question Re: Extract data from Solution Manager database in Technology Q&A

Extract data from Solution Manager database

boobboo — Mon, 06 Feb 2006 18:32:42 GMT

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 — Fri, 14 Apr 2006 15:45:43 GMT

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

Former Member — Sat, 15 Apr 2006 13:37:10 GMT

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

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