2 Replies Latest reply: Nov 19, 2012 4:46 AM by user248025 RSS

    Identify User Last Login Time

    974940
      Hi All,


      My requirement is to identify the user's last login time and display it on the report. I see some presentation variables like session.loginTime ,logoutTime, lastAccessTime.Question is can i use them to meet my requirement. Where does OBIEE store users last login time?


      Thanks,
      Sreekanth
        • 1. Re: Identify User Last Login Time
          prassu
          Hi,
          The session variable life will be end of the session.If you want to track the session variables then check in the log files.

          You can use usage-tracking concept to track the user log in details....It will store the data in the database.
          Refer this link for more details

          http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/biee/r1013/usage_tracking/usage_tracking.htm

          mark if helpful/correct...

          thanks,
          prassu
          • 2. Re: Identify User Last Login Time
            user248025
            Hi,


            1st you need to implement usage tracking then use session variable you can solve it
            Login Time
            @{session.loginTime}

            Logout time
            @{session.logoutTime}

            Last Accessed Time
            @{session.lastAccessTime}

            For More,
            http://gerardnico.com/wiki/dat/obiee/usage_tracking
            http://gerardnico.com/wiki/dat/obiee/presentation_variable_system

            Thanks
            Deva