Extracting List of Users from BO Server

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.



Helpful Answer