HOW TO GET OBIEE 12 C USER IP ADRESS ?

3365160

I just saw this morning in the table s_nq_acct one of our connected client, the latter says not to be logged of the day

I can not use "manage sessions" because the connection is dated this morning, I would like to discover who uses the login of our client

Thank you for your help

Syedsalmancs110

Below is my understanding:

You could check sawlog(X).log and look for a login entry with the user reporting the issue, you can check if in entry for issue user login message is an Remote IP address associated with it.

3365160

Your answer is correct however I note that the logs traces that the last actions ditto that if I clicked on "Administration / manage sessions"

I want to have the IP addresses of the users whose actions are saved in n_sq_acct

Syedsalmancs110

The user entries in S_NQ_ACCT table will give you report query,user ran the report,report ran information etc.., you can find report/dashboard run by a user information in sawlog(X).log too as an Remote ID would be associated with same, so can compare the both and find out the IP you are looking for,this is a suggestion try and let us know if it is of any help.

[Deleted User]

a) You will never ever get that into S_NQ_ACCT. That's an internal table which you are not supposed to mess with. Period.

b) Google is an awesome place where one can find things I have heard:

https://www.rittmanmead.com/blog/2016/12/enhanced-usage-tracking-for-obiee-now-available-as-open-source/

^-- Come on it's even open source what more can you ask for

3365160

Thanks Syed,

To achieve this, my sawlog files should contain the traces of all users who use the platform regardless of the date.

However, the sawlog files, which I have, contain only the last 10 connections. So I can not find the connection sought

My cache is disabled, however even by activating the cache, I only visualize the last 10 connections

thanks for your help