Need listing of users from OAS

Question

Hello,

We are running Oracle Analytics Data Visualization v5.,9 on-prem.  I've been asked to provide a listing of the users set up in OAS.  I've been looking through API documentation, but not finding much.

Is there a way I can get this user list using an API or perhaps via a SQL statement in the Admin console?

Thanks,

Steve

[Deleted User] · Answer

Circumventing not having access 101 😂

Gianni Ceresa · Answer

I don't have a 5.9 available, but let's assume that the "Users and Roles" page was already working the same as it is working now (it probably was very similar).

The list of users is a call to a web service (GET /bi-sac-config-mgr/api/v1/security/Users?limit=25&offset=0&_=1732311723832 in my screenshot below)

If you look in your browser developer toolbar you should see the call to list all the users and also make one yourself (in your favorite programming language).

Or even just copy all the returned listings in JSON format. From that JSON you can then easily extract what you need in a fairly simple way (any language can do the job, even just javascript from the browser console).

User_EX991 · Answer

Thanks Gianni.

Yes, it is old.  I'm afraid we are dependent on a 3rd party that provides the tool along with some of its own reports.  There is a "Users and Roles" page, but I was hoping for more than only being able to do a few screen shots.  :)

Users are setup in WebLogic, so I'll take a look at the link you sent.  Appreciate it!

Steve