topic Re: unused user groups in Application Development and Automation Discussions

unused user groups

Former Member — Thu, 04 Jun 2009 07:22:42 GMT

Can anybody let me know how to find the unused usergroups.

Here we are trying to clean up the unused data, we enocountered that there are user groups are not assigned to user.

How to find out them?

Re: unused user groups

Former Member — Thu, 04 Jun 2009 08:07:00 GMT

Probably the easiest way is to go to SE16N and in the select options for field CLASS of table USR02 select each entry once and click on "Number of Entries".

Anything which returns 0 entries is not used => and delete in SUGR.

You could do the same in transaction RSUSR200, and then also add a group to any users without an assignment.

Cheers,

Julius

Re: unused user groups

Former Member — Thu, 04 Jun 2009 09:03:22 GMT

or you can download all the groups from table USGRP, and then download the user-group assignment from USR02 in an excel sheet. Then you just have to take unique user group entries (remove duplicates option in Excel 2007 is great !! ) from the USR02 dump and compare it agains the USGRP dump to find which user groups are not assigned to any users.

Cheers !!

Zaheer

Re: unused user groups

Former Member — Thu, 04 Jun 2009 10:41:48 GMT

Thanks for your replies,

Really it has helpful.