Haaron Gonzalez – Blog in English Rotating Header Image


How to make some other security groups the default ones in SharePoint and SharePoint Online

This week had the opportunity to learn how to configure some other security groups in SharePoint to be the default ones on a given site. Had the scenario where some Site Collection Administrators needed to create beforehand new security groups and assign the members. Then when new sub site was created admin selected the specific security groups, but what happen with the other sites that already exists?  In those cases we use the /_layouts/permsetup.aspx page to redefine the default groups.

So, just navigate to the site and use the system page, then just pick and choose the groups you want.

Get the members of specific Office 365 role

Good day, this time I was asked to retrieve who the Company Administrators and SharePoint Service Administrators are from customer tenant.  The following is the steps I’ve used to deliver the requested Info:

  • I downloaded the Microsoft Online Service Sign-In Assistant from the following URL https://go.microsoft.com/fwlink/p/?LinkId=286152, proceeded to install
  • Install the Azure Active Directory for Windows PowerShell Module, as an Administrator loaded the PowerShell console and executed the Install-Module MSOnline command, specified yes, “Y” two times, first for NuGet and then for Untrusted Repository
  • Inside the PowerShell session, executed the following PowerShell commands:
  1. Import-Module MSOnline
  2. Connect-MsolService this command loaded an authentication window, you need to provide credentials
  3. Get-MsolRole, this command will list all the Office 365 roles, make sure you identify the one you need and copy the Object ID value
  4. Get-MsolRoleMember -RoleObjectId “rol ID” this command will display who the members of the role are






Recover data from an unattached content database

In SharePoint 2010 and 2013 we have the possibility to recover SharePoint objects and content from unattached content databases. When we say unattached, we mean that we didn’t attach a content database to SharePoint Web Application using power shell commands or the Content Databases options available in the Central Admin, instead, we use this approach to connect to a SharePoint content database restored just in SQL Server not in SharePoint, allowing us to be more proactive on the recovery of files, sites, lists etc.

Access SharePoint Central Administration site and access the Recover data from an unattached content database option available in the Backup and Restore left menu


Provide the SQL Server name or alias and specify the name of the content database you want to connect to get SharePoint objects, select the type of recovery you want to do.


Search and select the site collection you want to backup locally from the SQL Server attached content database. As you can see here, SharePoint is capable to query the attached content database in SQL Server and present the Site Collections, Sites and Lists available.


Provide the share folder path for storing the backup file where the content selected will be extracted from SQL Server. Start the backup process


You can monitor the progress of the backup process




Validate the backup file


Run a restore PowerShell command to restore the backup

Restore-SPSite http://intranet/teams/sp -Path \\d21-da\Scripts\backup\sp.bak

Validate restored site collection and ask SQL Team to remove the backup database from SQL Server instance