cancel
Showing results for 
Search instead for 
Did you mean: 

Is there User Group and Role Reporting in SAP Enterprise Portal?

Former Member
0 Kudos

I want to know if there is a way to pull users statistics our of SAP Enterprise Portal like you can out of the R3 backend systems.

I would like functionality similar to the SUIM transaction. I know through user administration you can access any user, even a list of all users, and you can do similar lists with roles and groups. You can then access any of these things individually and look at their assignments. However, I want to do this on a large scale. I want to know for example every group that has a user assigned to it. Evergroup that has roles assigned to it. Or groups that have no user or role assignments. We have approximately 1904 groups in our Production Portal system and I am trying to clean up the groups that have no user assignment, but I don't want to look through them one by one.

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member202734
Participant
0 Kudos

For a quick single shoot preview you can use the export function.

Go to user admin, select group, in search criteria give a name with * (selection is limited to 1000 group).

Then select all and clic on export button. It generate a text file with group ID, group description and assigned users.

You can also do that for role. In this export you'll find groups assigned to role.

former_member182598
Active Contributor
0 Kudos

Hi Chris,

There is no standard report available for this purpose. However all this information is stored in table UME_STRINGS.

You can write your own SQL queries to generate such reports. However please note that this table is not normalized, and it's a master UME table. You should use it strictly for READ ONLY purpose.

For a sample code you which i wrote some time back, you might refer:

http://forums.sdn.sap.com/thread.jspa?threadID=2088099&messageID=10859334#10859334

Thanks

Prashant