Solution Manager 7.2 performance indicators automatic reports csv

[Former Member]

Hi experts,

got another task from my boss: performance evaluations of our sap client systems.

I have to extract key information out of our Solution Manager. All relevant data can be found in the Early Watch report like DB performance, CPU performance, DB system etc.

For our 100 clients, I would need to click 100 times download the right EWA> extract the relevant data > finally process the data in excel. That should be done like 4 times a year!

My idea would be an automatism, with just one click: export all relevant data to a txt or csv file or something like this. It also can be done for each SAP client seperated in their respective file.
I hope u know what I want. I tried it myself, but Solman is a way too complicated/complex to just google the information for that.
If it is not that complex, I would be happy about a little guide or approach.

Edit: Got a possibility to process the EWR in Excel ( Data > import from Web >URL from the EWR). Now, i just need to know how to configure the SOLman, that he is sending, in addition to the Mail function, the respectiv EWR´s in a proper folder.

Regards

Florian

[Former Member]

Hello Tom,

thank you for your response 😃

I just took all informations from the EWAs now and process it with the help of windows/excel code lines.

Best regards

Florian

[TomCenens]

Hi Florian

I've done such endeavors in the past already and to sum it up, SAP Solution Manager isn't particularly good at doing this. Continue reading below the blog post link (you can find a couple of blogs on the topic where I tried some things out):

https://blogs.sap.com/2015/04/17/bi-reporting-on-sap-solution-manager-data/

You can get all this data into and from SolMan BW infocubes because that's where scenario's like technical monitoring get the data from. However, there is no way to fetch data historically if you would happen to have a gap at some point (the diagnostics agent failed or whatever else happened).

So if the environment runs super stable and agents don't ever fail and connectivity never fails etc (wet dream in other words), then you wouldn't encounter gaps and then you can report on it but then you bump into the next part. The framework in SolMan isn't build to fetch "older" values so you cannot say let's run this extractor again and fetch data from yesterday (although that data is available in the managed SAP system).

The embedded BW doesn't have a lot of functionality to do this properly. You can use Bex Reporting and it's kinda slow if you want to run through a good amount of data and you still end up saving the Excel file (export) to a PDF file to have some kind of report out of it in the end. There is no "mailing" out (publishing) functionality available in the embedded BW in SolMan either.

Alternatively, you send data across to a BW system (or another source that can handle the input) to get a "nicer" report out of it.

Besides that, the cubes and infoprovider fields are difficult to interpret and you'll have to dig through SAP standard queries to try and understand in which way SAP actually calculated a "pretty" simple value and then in the end build your own Z queries because the standard is not really what you want.

So if I had to go and figure out how to get this done properly, I would most likely get a cheap resource, have him or her do this for me and do something else (more interesting) myself in the meantime 🙂

There is a more recent solution SAP Solution Manager "Focused Run" which comes with a cost (additional license required), for large customers and service providers which is build on SAP HANA (only DB it supports) and which is optimized for SAP HANA for monitoring purposes. Perhaps this might be better and perhaps the framework is different. I wouldn't know because it's too big and expensive for me right now to look into it right now.

Best regards

Tom