When viewing a group in SharePoint, you can view a list of all permissions of that group across the site collection by going to Settings\View Group Permissions. Here is what that would look like:
Today a colleague wanted to export this list to Excel to facilitate some testing. The problem is the page that comes up when you click Settings\View Group Permissions is a dialog and you can’t right click on it, or even select and copy/paste.
The trick is browse directly to the URL that serves the dialog above. Here are the steps:
- Get the group ID. The URL when viewing a group is of the format http://yourServer/_layouts/people.aspx?MembershipGroupId=25. 25 is the group ID.
- Browse to this page http://yourServer/_layouts/viewgrouppermissions.aspx?ID=25, and change the ID to the ID of the group you want to view.
- On the page that comes up, right click on the table and choose Export to Microsoft Excel (or whatever else you fancy).