To check SAP Application log statistics you can use the program "SBAL_STATISTICS," you can utilize the reporting capabilities it provides for analyzing and obtaining detailed statistical information about application logs generated by various applications within SAP. This program serves as a useful tool for effectively monitoring and managing log entries.
Based on the findings from the SBAL_STATISTICS report, administrators may decide to clean up old logs, adjust logging levels, or take corrective actions on applications based on the insights derived from the statistics of application logs.
Accessing the Program
You can access the program through Tcode "SA38", as shown below
Click on execute and select the statistic collection option as per requirement.
STATISTIC COLLECTIONS
TIME CREATION:
get the number of logs for every month in a year, how many logs are in each month
CLIENTS :
get the number of logs for every client, how many logs are in each client
OBJECTS, Subobject, messages :
detailed overview based on OBJECT and SUBOBJECT of logs
columns:
- OBJECT, SUBOJECT (defined in TCODE SLG0)
- MIN DATE - the oldest creation date ( highlighted field is older than 180 days)
- MAX DATE - the latest creation date ( highlighted field is older than 180 days)
- Logs Cnt - number of logs
- MsgCnt All - number of messages
- MsgCnt E, W, I, S, A - number of message with type Error, Warning, Information, Success, Cancel
- reached exp date - number of logs they reached expiry date and can be deleted via option SLG2 - only logs that have reached their expiration date
- and can be deleted - number of logs can be deleted via option SLG2 - And logs that can be deleted before the expiration date
- cannot be deleted - number of logs cannot be deleted via option SLG2 - Non-deletable logs (display only). Such logs can be deleted only be the application that created the logs.
- never expire - number of logs that expity date is set to 31/12/9999
- % - number of % logs in current client.
USERS:
get the number of logs for every user
PROGRAMS:
get the number of logs for the program
TCODE:
get the number of logs for TCODE
EXPIRATION DATE:
get the number of logs for each option of Expiration Date (SLG2)
- Only logs that have reached their expiration date
- And logs that can be deleted before the expiration date
- Non-deletable logs (display only)
RELID data, BALDAT:
get number records with different RELID in BALDAT
Statistic logs
to view data select Option and click on Execute.
You can view log details under Details as shown below.
Documents referred : 2524124 - Application log Statistics