Categories
- All Categories
- Oracle Analytics Learning Hub
- 32 Oracle Analytics Sharing Center
- 22 Oracle Analytics Lounge
- 255 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16.1K Oracle Analytics Forums
- 6.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 95 Oracle Analytics Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Track the ip address of the user in OBIEE 11G
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
Answers
-
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.
0 -
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
0