Readout Software Component Versions from Database

[hewlett_packard4]

Hi Folks,

in order to generate a summary of all installed Software Compoment Version from each System in our

really complex Landscape - I want to use some kind of script which uses SQL to readout this data from

the Database of each SAP System. In particular I need all informations which is visible in TX:SPAM.

The other alternative way, would be to export some how this information from the SLD in a human readable format,

which is unfortunately not possible - as of now.

Can you please provide some SQL Statements or at least the corresponding tables (Oracle) which might help you to gather

this info?

regards

Benny

[Former Member]

I suppose there are a lot of ways how to achieve your goal.

One would be to look at table CVERS in sqlplus, for SAP versions.

For Oracle version look at view V$VERSION.

regards

[hewlett_packard4]

Hi,,

cvers looks good but this one is unforunately not available on J2EE Stacks

[Former Member]

Hello Benny,

you are right; I hadn't been aware of this difference.

I just looked around a bit. It seems table BC_COMPVERS should be what you are looking for in Java Systems.

Also have a look at BC_SCVERSION.

hope this helps