Is it possible to retrieve the last login date for myrealm users in Weblogic? We would like to deactivate user IDs that are no longer in use.
The log files...
The information may also be contained in one of the new 12c tables where OPSS stores its information but you are not really supposed to touch those
The 'last login attribute' is a common feature usually enabled via a password policy in most commonly used LDAP servers. However, the embedded LDAP that comes with weblogic does not have this feature so you will not to find this information in the log files.
We customised a solution where we executed an "INSERT INTO" script (via session variable) every time somebody authenticated against OBI.Now we have a table in the OBI database that stores username and the login date & time. Easy!
Why not use Usage Tracking to see if a user executed reports? No customization needed and will provide insights.
Only issue is that if the user never logged in, it will not be returned and you need an extra lookup to compare with your user base.
Michael Verzijl wrote:Why not use Usage Tracking to see if a user executed reports? No customization needed and will provide insights.Only issue is that if the user never logged in, it will not be returned and you need an extra lookup to compare with your user base.
What if they login but don't do anything?Does anything go into Usage Tracking?
i don't believe so. But with logging of initblocks enable you can also cover this.
Adam Wickes wrote:What if they login but don't do anything?Does anything go into Usage Tracking?
I would count those as "no longer in use", because just login to see the homepage but not run a single analysis is like not logging in
Yes that's what we use to find out which users are not using Obi (anymore). If you need user who have never used any dashboard copy user names from myrealm and combine this with usertracking data in excel (vertical lookup)
Wow many answers made me realize just how ambiguous the initial question is.
What users do you mean and which logins do you mean? I was working with the assumption of you wanting to prune WLS users - as in administrative users - and not OBI users which the others are using as an assumption
My assumption (based on the question) is that the OBI users are stored in the embedded Weblogic LDAP and not in an external corporate LDAP or AD.
Explore how to build agents using code in AI Data Platform. We'll create an agent that examines and analyzes the contents of a Github repository and reports its findings. The session demonstrates how to use different developer tools to create agents including the AIDP extension for VS Code and Codex. Using these tools we…
The user icon in the upper-right corner of OAC (DV) is displaying more menu options for our non-admin users than we wish to display. We would like to restrict these to only "Profile" and "Sign Out" for regular users. Is there a way to customize these menu items? Especially if we can control this via security, that would be…
What is wrong with this code
Am I missing something or is there no way to search through previous posts to make sure I don't duplicate a question? All I see on the filter options are tags or status… a general search for a word or phrase would be helpful.
We were under the impression that when exporting a visualization in DV to CSV format hidden columns would be include from the grammar panel. This is not happening. See below for a screenshot showing 3 hidden columns that do not appear when exporting the pivot table to CSV. This seems to have worked a month or so back but…
Migrated RPD from obiee12c to OAS 2024. post migration when we try to access dashboards on OAS we are getting below error: State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000) State: HY000. Code: 43275. [nQSError: 43275] Message returned from OBIS…
