Export SharePoint Users and Group Permissions to Excel

Requirement: Export users and group permissions to Excel in SharePoint. Here is the shortcut to export SharePoint users and groups permission to Excel: Open your SharePoint site in Internet Explorer. Navigate to either site permissions or any User group.  Right-click on the users list page, choose the “Export to Excel” item. You…

Read more

SharePoint Group vs Active Directory Group – Which is Best?

So you need to determine the best way to manage SharePoint users, Whether to use SharePoint groups or Active Directory groups to manage permissions in SharePoint? Well, Both SharePoint Group and AD Group have their own advantages and disadvantages. Let me list down some of them: Manageability: Any SharePoint site owner/admin can…

Read more

Remove User from All Sites in SharePoint using PowerShell

How to delete a user from all site collections in SharePoint 2013 using PowerShell? Sometimes, we may need to delete a particular user from all site collections. Say for e.g., an employee leaves the company! Here is how to remove a user from all SharePoint sites using PowerShell: This will scan and…

Read more

Create SharePoint Group from Active Directory Group using PowerShell

Requirement: Convert Active Directory Group into SharePoint Group! Solution: Managing SharePoint users at Active Directory Security group and within SharePoint has its advantages and disadvantages too! Now, we require migrating from the AD group to the SharePoint group. So, let’s use PowerShell to create a new SharePoint group from the Active Directory…

Read more

Create a SharePoint Group using PowerShell

Requirement: Create a new SharePoint Group using PowerShell SharePoint groups simplify permission management by assigning a set of users to a group and assigning permission levels to them through the group. There are default groups that get created based on the site template you choose while creating site collections, Such as Owners,…

Read more

Migrate SharePoint Users from One Domain To Another using Move-SPUser

Requirement: During an acquisition, Our company decided to merge with an acquired company’s AD by re-creating their user Ids in our AD. Also, the acquired company had a number of SharePoint sites, and we wanted to migrate them to our SharePoint environment. That brought another challenge of re-mapping user Ids with permission…

Read more

Get All Users of SharePoint Farm-Web Application-Site Collection-Site using PowerShell

Requirement: Get all users of SharePoint Farm. SharePoint PowerShell to Get All Users in Farm Do you want to get a list of all users in your SharePoint farm? PowerShell can help you with this! This blog post will show you how to use PowerShell to quickly find all users in your…

Read more

How to Create Default Groups in SharePoint Site?

Problem:The default SharePoint groups are automatically created when you create a new site collection through SharePoint Web UI. But, when you create SharePoint sites programmatically or with PowerShell (E.g., New-SPSite or New-SPWeb), The default site groups (such as Visitors, Members, Owners) are not created automatically! Default groups creation from UI: You can…

Read more

Copy Users from One SharePoint Group to Another using PowerShell

Recently, I had a requirement to copy users from one SharePoint group to another group. Unfortunately, SharePoint doesn’t support nested groups, and simply renaming the group didn’t help us! Well, there is no direct way to copy users from one group to another, but without having to retype each user ID, you…

Read more

Create SharePoint Alert for a Group

SharePoint doesn’t provide a direct way to create alerts for groups. Alerts are always targeted to individual user accounts in SharePoint. If you have a requirement to create alerts for a group of people, create an E-mail enabled AD security group and add an alert to it from SharePoint. Set alert to…

Read more