Skip to Content
Technical Articles
Author's profile photo Siddharth Jain

Getting Logon User Counts from Authentication logs

This Blog Describe how to extract the total number of End users & Service users logon counts from each Portal server node using Authentication logs .This information correctly depicts the total number of logon, user has performed unlike the unique login of the user provided in portal activity reports. Analyst /Consultants can merge this information logs with the Backend ECC/HR/SRM/CRM user logs maintained in USR02 tables for further reporting purposes for determining business transactions in more detailed manner.

following are the steps :

1) Go to NWA log viewer of SAP Portal


2) Choose authentication log from view


3) Click everywhere and from advance filter choose date filter and set it for biggining of day time till present time click on apply filter


4) Now download the excel file of logs from log file download content


5) Choose all column and download



6) Save it on the location you like on your machine. Now open excel file and apply filter, Select all login ok and application irj logs and now choose and count the required users


Below example show total number of 120 logons from the selected date on all the nodes of SAP portal for all user types, user type can be selected from user dropdown (Service or end user)


Portal Consultants can merge this information with ECC/ABAP system user logs and device statistics and reports ,they can formulate a Excel template based on their requirement  if they want and feed the data from ABAP system and Portal Authentication logs and generate Graphs out of it.

Main Advantage which I see in this approach is no coding required (Java or ABAP) and all the user logins(End users & Service users) based on the application(irj) can be identified from all server nodes, the approach works well in the Portal scenario where login screen is used by the users for Login to Portal.

I am listing down some use cases where this approach can be used:

— Getting the last logon date of WAS users or irj Portal users.

— Generating Portal Usage history reports from this logs using some reporting tool like Excel etc.

— Can be used for Auditing purpose and to identify security attacks

Its good to take a back up of these logs periodically as depending on portal usage and log size configured ,logs will be overwritten once the log size reaches its maximum value.

Some references:

Thanks for reading!

Siddharth Jain

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Sebastian Wörner
      Sebastian Wörner

      Great Idea!!

      Thanks for sharing!

      I have a small note, use the 'pivot tables' in Excel. This is much faster then filtering and selecting every single user to get the numbers of logons.

      Author's profile photo Siddharth Jain
      Siddharth Jain
      Blog Post Author

      thanks for the feedback

      Author's profile photo Former Member
      Former Member

      We've slightly a different need. We want present the user a warning message when they login to portal if there are other active sessions with same userid. Are there any Java APIs available to know active sessions for a userid?

      Author's profile photo Siddharth Jain
      Siddharth Jain
      Blog Post Author

      Pls open a new discussion in forum where you will get more suggestions and solution

      You can explore j2ee engine java docs , ume or session management java docs if SAP has provided any public api for tthe same also check iuser methods

      Author's profile photo Aníbal RBB
      Aníbal RBB


      I am trying to get this information but I do not get results, what happens? Do you have to configure something to show them?