Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 212 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OBIEE 12.2.1.3 how to get list of all users and their login dates in the past one year
Hi Gurus,
We need to generate list of all users and their login dates into OBIEE during the last one year. (say last 12 months starting from today).
Purpose is we have around 2500 users, want to identify how many accessed OBIEE in the last one year and remove the users who did not login to OBIEE.
Please share any inputs.
Thanks..
Answers
-
a) You either need detailed OBIPS logs going back one year and parse those OR
b) You need to look into your Usage Tracking table and go by queries emitted by user.
0 -
And, if b), keep in mind that a user can login and not be visible at all in Usage Tracking (sure it's useless, but maybe the user only login to the homepage without firing any query and therefore not being visible in Usage Tracking, and also if it receives a delivery from an agent not ran as the user etc.)
And if you want a list of "all users", you should look into your authentication provider config: the list of "all possible user" can be extremely large compared to the list of users you thought you had...
0 -
Hi Chris,
a) OBIPS logs -- you mean the "sawlog*" files , the oldest timestamp i see in those is 10/26/2021, so seems it doesnot help.
b) Usage Tracking, checked NQSconfig file, under "usage tracking" section, i see ENABLE = NO.
Please let if there's any third way..
Thanks Gianni --- yes you are correct, unless user trigger some query, he/she won't make entry into usage tracking table.
Thanks..
0 -
There is no other way.
To be fair there isn't a valid reason to not have usage tracking enabled, so with that disabled you are missing a lot of info about what your environment is used for.
If you are really desperate and are ready to have an approximative answer to your question, you could try to go through all the users' folders in the catalog and try to get last access dates (the OBIEE metadata) and also filesystem dates.
You could easily have a result missing 50% or more of the users having been active in the last year.
Enable usage tracking, make sure it works and in 6 months you will already enough information to let you decide what users aren't connecting (some users needs OBIEE only once a year for end of year financial closing for example, but most will hopefully use it every few months at least).
0 -
Thanks Gianni, that's helpful.
0 -
Hi..
Understood that usage tracking gives the user details, timestamps, logical and physical queries hitting the database.
So is there a way we can get info on the "last viewed dates" of all reports in the catalog using usage tracking ? (if not possible in usage tracking, apart from parsing presentation server logs (sawlog files) as Chris mentioned ) is there any other possible way ?
Intention is to get rid of all unused analyses sitting in the catalog for a while.
Thanks..
0 -
What is "last viewed dates" supposed to be?
Usage Tracking has dates on every single row, select MAX on the date and group by analysis and you get a last executed date.
Of course here it's just like for the users: you need to have Usage Tracking enabled for a while before to consider the data as safe to be used.
Every (native OBIEE) object in the catalog has various dates as well, but I wouldn't trust them much as they can be quite random.
0
