Last login date for Weblogic users in myrealm — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Last login date for Weblogic users in myrealm

Received Response
214
Views
11
Comments
Dulce Bautista
Dulce Bautista Rank 2 - Community Beginner
edited Aug 13, 2024 5:49PM in Oracle Analytics Cloud and Server

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.

«1

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    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

  • handat
    handat Rank 5 - Community Champion

    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.

  • Adam Wickes
    Adam Wickes Rank 6 - Analytics Lead

    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!

  • Michael Verzijl
    Michael Verzijl Rank 6 - Analytics Lead

    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.

  • Adam Wickes
    Adam Wickes Rank 6 - Analytics Lead 
    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?

  • Michael Verzijl
    Michael Verzijl Rank 6 - Analytics Lead

    i don't believe so. But with logging of initblocks enable you can also cover this.

  • Gianni Ceresa
    Gianni Ceresa Mod 
    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

  • Martin van Donselaar
    Martin van Donselaar Rank 6 - Analytics Lead 
    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.

    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)

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    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

  • Gianni Ceresa
    Gianni Ceresa Mod

    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.