5 Replies Latest reply: May 22, 2013 2:22 AM by JohnGoodwin RSS

    User history

    hyperion start
      Gurus,
      I was wondering if there is any way to check when hyperion users were created.
      For example, there is a user Jsmith.
      Is there any way we can check and see when the user was created in Shared Services or how long he has been using Planning/Essbase, etc.
      Any suggestion is appreciated.
      Thanks
        • 1. Re: User history
          JohnGoodwin
          Is the user a native user or an AD user, as AD users are not actually created in Shared Services only provisioned, if it is a native user then the Shared Services relational tables CSS_USER, CSS_GROUP have columns CREATEDTIMESTAMP,UPDATEDTIMESTAMP
          There is also CSS_PROVISIONING_INFO which holds provisioning and has CREATEDTIMESTAMP
          I would suggest the provisioning and security report in Shared Services but they are pretty limited.

          Cheers

          John
          http://john-goodwin.blogspot.com/
          • 2. Re: User history
            hyperion start
            John
            Thank you very much for your answer.
            The user is from active directory.

            I will try and check the last tables you had mentioned.
            • 3. Re: User history
              hyperion start
              John,
              When I look at the table CSS_PROVISIONING_INFO, I see the column MEMBER_IDENTITY. However, how do I find out what user is which as it does not say the user_name?
              Any suggestion?
              Thanks
              • 4. Re: User history
                Celvin Kattookaran
                Join it with CSS_USERS
                SELECT b.name,  a.*
                FROM css_provisioning_info a,
                  css_users b
                WHERE a.member_identity=b.identity_id;
                Regards

                Celvin
                http://www.orahyplabs.com
                • 5. Re: User history
                  JohnGoodwin
                  As it is for AD users then joining to the CSS_USERS table will not help as AD information is not stored in that table, the provisioning table holds the AD ID attribute which links back to the AD.

                  Cheers

                  John
                  http://john-goodwin.blogspot.com/