LMDB Export with Host data and SID

[david_fhr]

Hello experts,

I found the possibility to export systemdata from the Solman via the report AI_LMDB_EXEC_REPORTING.
When you execute this with the setting SAP:Host you get a really nice Spreadsheet as a result.

But sadly this spreadsheet doesn't have a SID in it.
Do you know a way how to export all technical data (kernel version, hostname etc.) and the corresponding SID to it?

Thanks in advance!

BR, David Faßhauer

[RolandKramer]

Hello david_fhr

Please check the First Guidance Document - SAP First Guidance – SEM/BW Modelling in SolMan 7.x with MOPz/MP for the correct setup if the individual systems in the SolMan 7.2

In addition, the online Document - SAP MacGyver – Installing SAP SolMan 7.2 might be helpful for you as well.

best regards Roland

[david_song]

Hello,

Could you please try setting SAP: Technical System - Installed Software Components instead of SAP: Host.

With this setting, you will get information like SID on host, installed Software Component Version including SAP KERNEL version, SP level, patch level.

[david_fhr]

Hello david.song ,

thanks for the help so far, but I tried this and the result wasn't that was expected:

There are some columns with empty names and they also have no data in it.
Do you know a way how to fix this?

Thanks in advance!

BR, David Faßhauer

[david_song]

Hello david_fhr,

After checking the contents of the columns with blank headers, it seems those are just sub-information(more details) of the previous column header, so they are not given a new header name. For example ITA Role=PROD, the next column=production system.

The blank header columns seem to be non-crucial information. If you want to exclude them, from menu select Settings->Layout->Change

BR,
David Song