Announcement

Collapse
No announcement yet.

Login Information

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Login Information

    Is there any table in the OTM which captures the login information such that we can query on the number of user's logged in currently?

  • #2
    Re: Login Information

    I think that this information is part of either the App or Web-Server. In OTM you can have a look at GL_USER, but its per user so you would need to write your own summary-qry. Table :


    GL_USER_GID VARCHAR2(12NOT NULL GL_USER_XID VARCHAR2(50)NOT NULL GL_PASSWORDVARCHAR2(12NOT NULL DOMAIN_NAMEVARCHAR2(50)NOT NULL IS_AD_HOC_REPORTS_USERVARCHAR2(1)NOT NULL Y/N LAST_LOGIN_DATEDATE AD_HOC_REPORTS_DB_TYPEVARCHAR2(100) OLTP/ODS GL_ACCOUNT_POLICY_GID (FK: GL_ACCOUNT_POLICY)VARCHAR2(101) PW_EXPIRATION_DATE DATE ACCOUNT_LOCKOUT_TIME DATE USERNAMEVARCHAR2(101) UNIQUE DEFAULT_USER_ROLE_GID (FK: USER_ROLE)VARCHAR2(101)NOT NULL IS_ADVANCED_ANALYTICS_USERVARCHAR2(1)NOT NULL Y/N DEFAULT_AA_REPORTVARCHAR2(100) DOCUMENT_USE_PROFILE_GID (FK: DOCUMENT_USE_PROFILE)VARCHAR2(101) INSERT_USERVARCHAR2(12NOT NULL INSERT_DATEDATENOT NULL UPDATE_USERVARCHAR2(12 UPDATE_DATEDATE

    Comment


    • #3
      Re: Login Information

      Hi Moshe

      Actually the GL_user table only shows the configured users (unless its changed since v4.5).

      If you add an Account Policy to each user, where the Account Policy has the Record Login box checked, then OTM will log attempts (sucessful or not) in the table gl_login_history.

      This will only tell you when they log in though - there's no way to know when they log out.

      Hope this helps
      Gary
      Regards
      Gary Cunningham
      www.cbmc.co.uk
      www.mavenwire.com

      Comment


      • #4
        Re: Login Information

        Gary is right -- OTM doesn't provide this functionality.

        Back in an earlier version (v4.0, I think) there was a servlet that would list out current sessions (and therefore logged-in users), however it broke when we upgraded Tomcat versions, and the code was never updated. I'd recommend creating an Enhancement Request for this through Oracle, as this would be a very helpful admin utility.

        In addition, I've heard the same request from many OTM administrators -- if we can get enough requests to Oracle, they'll get it done.

        --Chris

        Comment


        • #5
          Re: Login Information

          HI

          Guys is it possible to see the history in 5.5 and later versions, in 5.5.3 there is no check box called Record Login, only there is a check box called keep login history but there is no records in gl_login_history,

          whether there is any files in the sever side to this records, if so please let me know.
          Attached Files
          Thanks
          Gokul

          Comment


          • #6
            Re: Login Information

            Hi Gokul

            It is the 'keep login history' that needs checking as you point out.

            Make sure that your users have the Account Policy applied in the User Manager. Each User must have the policy applied before this will work.

            It is certainly working in 5.5

            Gary

            btw - You can see login history from the UI - look in Configuration and Administration -> User Management -> Login History
            Last edited by cunninghamg; December 14, 2007, 09:21. Reason: additional comment
            Regards
            Gary Cunningham
            www.cbmc.co.uk
            www.mavenwire.com

            Comment


            • #7
              Re: Login Information

              Hi Gary,

              i checked the user in the user management, the account policy is properly assigned but it is not refelected in the gl_login_history as well as in the application Login History.
              Thanks
              Gokul

              Comment


              • #8
                Re: Login Information

                Hi Gokul

                These are the steps required.
                It is all I needed to do.
                If you are still having a problem - you should talk to support.

                Cheers

                Gary
                Regards
                Gary Cunningham
                www.cbmc.co.uk
                www.mavenwire.com

                Comment


                • #9
                  Re: Login Information

                  Hi Gray,

                  Thanks For ur assistance
                  Thanks
                  Gokul

                  Comment


                  • #10
                    Re: Login Information

                    Hi Gokul,

                    Did you manage to solve the issue....?

                    I am also having the same probem, not populating gl_login_history table after done all the necessary stpes like setup Account Policy and assigned it to the users...

                    We are using OTM v5.5 CU2.

                    Any advice....

                    Thanks in advance,

                    Rgds,
                    Kiru.

                    Comment

                    Working...
                    X