How to list users with their roles?

[Joel Eijssen]

How to list users with their roles?

For audit, insight and overview purposes it's needed to view/list/report which roles are assigned to which user.

[VolkerB]

Hello,

currently there is no way to fulfill your request. You cannot create a list of roles and see which users are assigned in SMA-X. Since we had a similar need, I wrote a small program using the REST API iterating over all users and storing the needed data in a separate database.

There might be an item on the roadmap concerning user management in SMA-X, but I am not sure.

BR, Volker

[Kirill Rogachev]

Hello,

What tables and relationships did you use when developing your application?

[VolkerB · Accepted solution]

Hi,

you need the authentication token (https://docs.microfocus.com/itom/SMAX:2020.11/ConnectToRESTAPI) and with this you can use the URL https://<host>:<port>/rest/<tenant-id>/rms/AuthorizationPrincipalResourceJSON?filter=UserId='<upn>'

You receive a JSON and you can find an array "Roles" in this JSON with all roles of the user or group.

Hope this helps...

BR, Volker

[Kirill Rogachev]

Is it possible to do this through a database?

[VolkerB]

You mean that the query is not made with REST API but with SQL query? That is certainly possible, but I have not (yet) done a full reverse engineering of the database structure, so I can't make a recommendation there.

[Brindusa Kevorkian]

Hello,

This capability is currently not supported. There is an idea opened and you can vote on it:

https://community.microfocus.com/t5/SMA-Idea-Exchange/Report-with-users-amp-Roles/idi-p/2746971

The API provided here is a private API and should not be used for reporting purposes. It is subject to change without notice and has not been designed/validated for extracting large amounts of data.

Direct database access is not recommended.

Best regards,.

Brindusa