Haaron Gonzalez – Blog in English Rotating Header Image


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






Fail patching your SharePoint 2010 farm for apparent no reason

  • Act 1: You notice that health analyzer is warning you that some updates needed to applied on the server X and server Y.
  • Act 2: You download the KB2956080 and properly install on both good old SharePoint 2010 servers
  • Act 3: Run the psconfig -cmd upgrade -inplace b2b -wait command and “Missing installs error is displayed

How the play was called?

Fail patching your SharePoint 2010 farm for apparent no reason

At some point SharePoint loses track of the CU version information between the registry, windows installer and SharePoint but with just one magic PowerShell command you can force and fix the mismatch, the command is Get-SPProduct -Local , just run on the servers that display the Missing error then run the Configuration Wizard or PSConfig.