3 Replies Latest reply: Nov 1, 2013 2:33 AM by kent_ RSS

    Export list of Hyperion users from Shared Services [EPM11.1.2.2]

    kent_

      Hi All,

       

      I used to pull the list of users from Native directories using the query :

      select * from CSS_USERS;

       

      I looked at the remainder of the tables in Shared Services and couldn't find the "username" of the accounts stored in the external directory. All I could find are the corresponding AD users GUID. eg. msad://OBJECTGUID=\f7\70\aa\c1\fb\0f\61\4e\95\b9\e5\f8\1e\8b\23\43?USER

       

      Is there an easier way to get a list of the users provisioned within Hyperion?

      As a workaround, I manually pull the users details using LCM; is there a way I could automate this?

       

      *** UPDATE ***

      - EPM version: 11.1.2.2

       

      Thanks,

      Kent