SAP NW Java - Login information for a user

[Former Member]

Hi Experts,

We are using SAP NW Java 7.3 application server. I want to view a daily log report which can show the user's login information i.e. LOGIN OK or LOGIN Failed.

1. Are there any tables in SAP NW java which can be used to view this information?
2. Is there any way by which we can configure SAP NW Java to produce a file (daily) with the logs of user login information

I can see the logs via Log Viewer and default.trc file. But I am facing following issue:

1 While viweing logs via Log Viewer, I can filter and view logs for the day and download it in a file. But there is no mechanism or background job which can actually filter the content of the log everyday and prepare a file automatically. We wish to use the login information present in the files for further processing

2. Default.trc provides cumulative logs. So it's difficult to process such a big file everyday. As the number of days pass, the file size would grow and make processing of data impossible.

Please advise if a background job or configuration can be done so that a daily log file with log in information can be generated on the server. We'll pick the file from the server and send it for further processing.

Thanks,

Anuj

[Former Member]

Hello Anuj

This is not exactly what you are looking for but is pretty close.

NW 7.3 system allows you to create your own reports/ monitors and you can decide what information you would like to be displayed.

Login to NetWeaver Administrator http://<hostname>:<port>/nwa

Navigate to Availability and performance --> Resource monitoring --> History Reports

Go to Configure tab and click on New Report. Give a name to your report. After that navigate  in your left pane to find a monitor with name "Logged in users count" and click add to report. In the similar way add unsuccessful logon attempts count

Switch to Display and you can see your data in graphical format.

You can also export it out. I recommend to explore the monitors to find what your exact requirements.

Regards

Amit Padmawar

[Former Member]

Hi Amit,

Thanks for the information provided. The reports would be helpful during audit.

Currently, I have a scenario where I have to get the USERID who logged in successfully. The report you have mentioned only provides the user count, I need the user id who have actually logged into the system.

Are there any reports available in NW Java 7.3 which can provide this information?

If such reports are available, is there any way by which it can be scheduled in background to generate a file every midnight?

Thanks,

Anuj

[hemanth2]

Hi Anuj ,

Hope you are doing good.

With the help of the security audit log, you should be able to achieve this:

http://help.sap.com/saphelp_nw73ehp1/helpdata/en/4b/6013583840584ae10000000a42189c/frameset.htm

"

The security audit log of the SAP NetWeaver Application Server (AS) Java contains a log of important security events, such as successful and failed user logons, and creation or modification of users, groups and roles. This information is used by auditors to track changes made in the system.

"

Thank you and have a nice day :).

_____________

Kind Regards,

Hemanth

[Former Member]

Hi Hemanth,

I understand that SAP NW java 7.3 logs everything in a file. The name of the files were provided in the first section of this discussion. However, the file that stores the log is not in readable format. Neither can we automate the process to collect the logs.

We are trying to automate the process of collecting logs on a daily basis. These logs will be used to process further information. As the logs are in file format and the file is not in a process able format , we cannot use it in the existing state.

We are looking for some tables in SAP NW Java which can yield similar information. Extracting information from tables would be easy compared to extracting it from such files.

Thanks,

Anuj

[Former Member]

Hi Anuj,

  I believe your query is answered in the below link.

http://scn.sap.com/thread/636456

http://help.sap.com/saphelp_nw04s/helpdata/en/fb/144120ea5b4e9c9385d493a578d6c9/content.htm

Thanks and Regards,

Vimal

[Former Member]

Hi Vimal,

The links that you have provided are related to SAP Enterprise Portal.The tables that are mentioned are specific to SAP EP ,they don't exist in SAP NW Java.

Is there any solution which can be implemented on SAP NW java stack?

Thanks,

Anuj