How to get client PC IP or any other helpful detail of events performed by a user from Audit db.

[SAPSupport]

We would like to see what actions were performed by users during different intervals. Since all our user use single user account, is there any way we can get this information from Audit Database?

--Steps to reproduce--

1. Login to client portal using respective User Credentials(Portal credentials).
2. Access any Report from there.
3. It uses only one BO User(Enterprise in this case) to access any report: ABC-Standard.
4. So this way multiple portal users are using the same BO user to fetch reports.
5. In the CMC>> Sessions, we can see multiple sessions are created for this ABC-Standard user.

[SAPSupport · Accepted solution]

Have got this KBA 2113348 - How to get user logon event and ip address from Auditing database in BI 4.x?

• But this KBA won't give those information if portal is involved which ultimately will go through load balancer URL.
• This KBA mentions, it will be useful only in case we access BI Launchpad/CMC/Open Document via direct Web Application server:port.

I would very much appreciate your thoughts on this. Whether it is even possible or not.

[DellSC]

I am not an SAP employee. However, my understanding of most licensing agreements is that each user must have their own login to the system - using a single ID might be a license violation.

AFAIK, getting the IP of the user's computer is not possible in this situation - the IP of the portal computer used to log in to BOBJ will be recorded in the Audit database.

-Dell