Categories
- All Categories
- 93 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14.2K Oracle Analytics Forums
- 5.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 53 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations Gallery
- 2 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Obiee 11g audit IP Address of user in BI presentation services
Hi everyone,
We are using OBIEE11g as a BI tool.
For monitoring reason we need to keep tracking of users who access reports and dashboards.
It is implemented Usage tracking system with S_NQ_ACCT and S_NQ_DB_ACCT tables, and it works fine.
We are required to keep tracking also the Host IP of the user that is accessing the environment (analyses, reports,etc).
If we go to Administration->Manage Sessions there is a column-Host Address, but this column is available only for active sessions and is not recorded in the usage tracking system.
Is there any way i can save this information in usage tracking tables (S_NQ_ACCT and S_NQ_DB_ACCT)?
Or if there is some other way to retrieve this info?
Please, i need some help!
Thank you,
Elona
Answers
-
You can't really extend usage tracking itself to add extra pieces of information.
You can get the info you look for from the presentation service logs which are more like a webserver kind of logs and there you must have the IP address.
You can read about it logging in Presentation Service at https://docs.oracle.com/cd/E21764_01/bi.1111/e10541/logging.htm#BIESG216 . An usage of that feature was described at https://www.rittmanmead.com/blog/2014/11/auditing-obiee-presentation-catalog-activity-with-custom-log-filters/ , it was a way to have more logs than just usage tracking.
It will be up to you to collect these logs and store them for your needs.
You could populate another table with the info and, when needed, join it to usage tracking. Or if it's just for auditing keep these extra logs stored for that reason.
0 -
you could use Data Visualisation and data mashup on the UT data and the extended UT data
0 -
A -> B = the route OP expected
A ------- [break for hyperspace travel to Alpha Centauri] -------> B = @Joel Acha in comparison X-D But perfectly on target. Kudos.
0