How to get useful reports from logs generate by SAP application server i.e Netweaver / PI ? what kind of reports we can get from these application logs?

[lalitgoyal87]

How to get useful reports from logs generate by SAP application server i.e Netweaver / PI ?

what kind of reports we can get from these application logs?

[warwickchai99]

We are the developer of such a solution, and the ABAP & Java code is licensed and can only be obtained by contacting us. You can find out contact details here http://www.powerconnect4.com/contact/

[Marinus]

You now have some options. You could use the App on Splunk base which runs on the ABAP stack or you can use our Aramadillo virtual appliance to remotely collect machine data from both the ABAP and J2EE stacks. Check out http://bit.ly/15r1vq5

[sajbutler]

The good thing about SAP is that it logs a lot of information about internal activity and performance. Unfortunately, it is not readily accessible.

A Project was launched in late 2011 called SAPninja, which provides a way of harvesting SAP log and performance data and staging it in a way for ready ingestion by Splunk (and other applications). There's also a Splunk App launched at the same time called Splunk For SAP. Check out this thread for further discussion.

[Marinus]

The short answer is you can't by default. SAP produces a vast array of logs and traces in all kinds of formats, which you can't parse out the box easily. The J2EE stack is the exception where you can find Log4J style logs, which you can parse without much hassle. However most of the action is on the ABAP side 😞 You have two options, write a SAP ABAP app to log the data out so Splunk can eat it or write a connector that deals with the SAP complexity and forwards events to Splunk in a sane format.

[LCM]

Since nobody answered yet, I'll try to give you a possibility - although I don't know SAP at all!

1. First you need to know, what's all (warnings/errors, transactions, logins, etc. etc.) being logged by SAP and where (how many logfiles, locations, etc.) is it being stored in
2. Think of something exciting you want to monitor or report
   • eg. failed user logins on your SAP boxes
   • eg. successful transaction by user per hour
   • eg. billing reports
   • eg. net profits or losses
   • etc. etc.

The variety on reports is so vast, but all it depends on your logfiles. When you figured out what all is in your logfiles and what kind of things you wanna see, than you may be able to ask more specific on how to do reports etc.

Splunk itself can pretty much do ANYTHING with your logfiles what you want/need - but you need to know what you want!

btw: to correct myself - with logfiles, I mean any readable fils, and not only logfiles