In this article we can explore the new Permissions Add-in inside Squadron.
Squadron is a Free Administrative Tool for SharePoint. You can download it from:
What is inside Permissions Add-in?
Permission Add-in helps with the following tasks:
1. Find permissions of site level, list level, item level
2. Distinguish between Unique & Inherited permissions
3. Save Reports
4. Provides wizards for Find, Copy, Delete, Backup, Restore permissions
Types of Permissions
In a quick overview of Permissions, there are basically 2 types:
Unique Permissions where we assign unique users/groups & permission levels.
Inherited Permissions where the securable object (site, list, item) inherits permissions from its parent.
How to Generate the Report?
Let us examine the steps to generate a report for a site collection.
Step 1: Enter URL
Run Squadron & in the appearing screen, enter the URL of the site. Please note that you should run this in SharePoint Farm Account context.
Step 2: Open Permissions
From the left hand side click the Permissions link.
Step 3: Set Options
You can set the options in the appearing screen.
Site: To include site objects check this item.
List & Library: To include list & library objects check this item.
Item: To include items & documents check this item.
Expand Groups: A permission entry can be a SharePoint Group or User. If it is a SharePoint Group, you might need to include the users contained inside it. Check this item for including users.
Show User Name: The user item will be having a Login Name (eg: DOMAINuser) & a Display Name (eg: Full Name). You can choose this option to include the Display Name of the user as well.
Include Hidden: There could be hidden lists which are not visible in Quick Launch or in the All Site content page. Check this option to include those.
Unique Permissions Only: Check this option if you need only Unique Permission items.
Expand Inherited Groups: Usually the Inherited Permissions will be expanded in the parent object, as it is unique there. This checkbox enables you to expand the inherited groups too.
Filter By: Checking this option will enable a URL textbox where you can enter the URL to filter the result.
Highlight: Highlight Unique Permissions as Yellow & inherited ones as Green.
For the time being I have checked the following options:
Step 4: Generate
For generating the report, click the View Permissions from the left. You can see the result as shown below depending on your Site.
Step 5: Save Report
For saving the report, you need to right click on the grid & choose the option.
1. Save to Excel
2. Save to CSV
You may uncheck the option “Open after save..” if you do not wanted to launch your report file after save.
I have selected the option to save as Excel.
Enter the file name and click the Save button.
You will be viewing the file in Excel after saving.
This concludes our usage of Squadron Permissions add-in.
I wanted to iterate the Microsoft Recommendation of using SharePoint Groups instead of directly adding users to the site/list/item permissions. Groups are more easily manageable & easier understanding.
About the Wizards
The additional wizards are separately documented. Here is the screen shot of thee wizard screens.
In this article we have explored about Squadron Permissions Add-in. I believe in real life scenario the add-in is useful in quickly analyzing a SharePoint site.