Track the ip address of the user in OBIEE 11G

Question

Can any one help in Tracking  ip address of the user in OBIEE 11G

Details :

Implemented usage tracking but am unable the track IP address of user in S_NQ_ACCOUNT table.

Requirement:

With the addition of S_NQ_ACCT table information need to track IP address of user system , if its possible work around i need.

Help is appreciated

EmmanuelMash · Answer

Hi

If you are not using some kind of load balancer then you can use a tool like elasticsearch, logstash, filebeat and kibana to collect logs and do a bit text mining. In obiee the RemoteIP: 172.16.4.56 of the user is stamped in the sawlog You could mine this file and much more from your app logs.

regards

Emmanuel

mac2 · Answer

Not sure if it's possible to add it to S_NQ_ACCT. There is a way to track IP address, one way is mentioned in this article: https://www.rittmanmead.com/blog/2014/11/auditing-obiee-presentation-catalog-activity-with-custom-log-filters/

Do read the disclaimers.