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.
Description: Join our Product Management team to learn about new features that are part of 26.R3 Application release of Fusion Data Intelligence (SCM). The session will cover updates on Supply Chain Management and Procurement. Presented by: Anil Sebastian - Senior Director, SCM Product Management, Fusion Data Intelligence…
So when I click the apply button, it uses the value . Also. How do I stop the auto populate table when the report opens???? I am in OAC
Good day, please kindly assist. We are creating a graph to calculate the number of assets per milestones. However, the planners have only populated assets for only one milestone from the list of milestones the customer wants to track. Which gives an incorrect view as the project moves past different milestones that it has…
I scheduled the report in OTBI and the agent was run successfully. However, I do not receive the report after the run in my inbox. The addresses are properly recorded, and the report is in an excel format and saved as a pivot table in otbi. What can be the cause?
Anyone has any idea why the OAC documentation on custom viz is not available now? I was able to access till last week - https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsdv/build-package-extension.html. Does this mean OAC doesnt support custom viz or custom workbook extensions?
I made a parameter with letter range values… put it into a dashboard filter. Then I created an expression filter to bind it to my last name column in the table with the image I uploaded here. I am getting the following error??? Invalid Expression. Validation of parameter values failed. A general error has occurred. Message…
