21 Replies Latest reply: Mar 26, 2014 12:32 PM by Prakash Kumar RSS

Extracting List of Users from BO Server

Jayalakshmi Siddaramaiah
Currently Being Moderated

Hi All,


As an administration requirement we have to extract list of users within our BO server. I looked upon the forum and found that we can use query builder for the purpose.

I used query builder and ran query " Select SI_NAME from CI_SYSTEMOBJECTS where SI_NAMEDUSER=1 AND SI_KIND='User' " to list down the users. No issues till this point, the query ran fine and gave list of users in the server but I couldn't find a way to take export of this list. Then I thought of creating a webi report on top of CMS database pulling column "dbo.CMS_Aliases6.Alias" into report but that shows some ids for all enterprise users.


Please let me know if there is any other method that I can implement to take export of user list from server. I know this can be achieved using SDK but I want to try it at last.