Display users under their SharePoint Groups
When running a permissions matrx and expanding the SharePoing Groups can you make the users in that group appear under it so it keeps the users in that group together instead of lumped to getter because it doesn't make any since when looking at the exported report when I just have a list of users.
I've attached an image to show this issue. When a group is expanded note the user doesn't appear directly under the actual group of which it is a member.
If the users appeared under the correct group, it would actually transform this product amazingly.
Currently, I am unable to use the Matrix report in its current format, as I have to export the report in Excel, reorganise, edit to make it readable to department managers to sign off. Doing that for 100s of sites takes over 3weeks!
If the group had the members listed directly under, I could at least screenshot that for approval.
Anny Hong commented
Yes, currently, the report shows the users but all the members are listed in one column separated by semi-colon. It would be great if it shows the SharePoint group and each user as a separate row.
Indeed we need to know the users of the SharePoint groups also