SharePoint (2003 thru Online): September 2019

Tuesday, September 24, 2019

Global reader (Azure role)


MSFT are introducing a new Azure Active Directory (AD) role called global reader.
MSFT  started the roll out and will be completed worldwide in October, 2019. 

Global reader is the read-only counterpart to global administrator. Users in this role can read settings and administrative information across Microsoft 365 services but cannot take management actions.

It is available in my tenant (below screenshot).


MSFT created the global reader role to help reduce the number of global administrators in your organization. Because global administrator accounts are powerful and vulnerable to attack, MSFT recommend that you have fewer than five global administrators.
Assign global reader instead of global administrator for planning, audits, or investigations.
Use global reader in combination with other limited admin roles like Exchange administrator to make it easier to get work done without the invoking the global administrator role.

Global reader works with the new Microsoft 365 admin center, Exchange admin center, Teams admin center, Security center, Compliance center, Azure AD admin center, and Device Management admin center.

Note: At public preview launch, global reader does not work with SharePoint, Privileged Access Management, Customer Lockbox, sensitivity labels, or the following features within Teams: Teams Lifecycle, Reporting & Call Analytics, IP Phone Device Management, and App Catalog. All of these services will work with global reader in the future.

This role will be added advantage for SharePoint Online admins to understand the integrations between features in M365/o365.
To get the most value from this new feature, we suggest that you identify the admins in your organization who should have the global reader role assigned to them. For example:
Remove the global admin role and assign global reader, and any other essential limited roles, to individuals and admins who can complete their tasks with only the global reader role or the role in combination with limited admin roles like Exchange admin or user admin.
Assign the global reader role to individuals in your organization who don’t have admin center access today and are dependent on coworkers for getting the administrative information they need for their work.

Monday, September 9, 2019

Cumulative Updates in your SharePoint Farm


For SharePoint Online, view here

Farm Build Version via SharePoint Management Shell.
Open SharePoint Management Shell as administrator.

Run the Cmdlet’  Get-SPFarm.BuildVersion

SharePoint Farm Build Version via Central Administration.
Go to Central Administration > System Settings > Manage Servers in this farm.

Under Farm Information > Check the Configuration database version = farm patch level of the farm (Build Farm Version).

Get the Products and Patches build numbers that already installed on the farm.
Go to Upgrade and Migration > Check product and patch installation status.

You could check all the installed products in the whole farm or on a specific server.

Check the install status and version columns for all installed Products/Patches.


Get the Database build number on the farm.
Central Administration > Upgrade and Migration > Review Database Status.

Manage Database Upgrade Status > Click on Content Database name.

Get the database Schema Versions.

Get the Farm Build Version via SQL Server.
Open SQL Server Management Studio.
Open the Content Database > Versions Table. 

SELECT TOP 10 [VersionId]
      ,[Version]
      ,[Id]
      ,[TimeStamp]
FROM [SharePoint_Config].[dbo].[Versions]



The Farm build number is the corresponding value of versionID start with ‘0000000-000’ that is ‘15.0.4569.1000‘.
The version table also shows the Database Sequence build number that is ‘15.0.14.0‘ & ‘15.0.146.0‘.

After you get the farm build version, you’ll be able to get its corresponding release.by browsing the below links based on your SharePoint version.
For SharePoint 2010 Build Version Number.
SharePoint 2010 Build Numbers (Cube Sheet).
SharePoint Server 2010 Build Numbers
For SharePoint 2013 Build Version Numbers.
SharePoint 2013 Build Numbers (Cube Sheet).
SharePoint Server 2013 Build Numbers
For SharePoint 2010/2013/2016 Build Version Numbers.
Build Numbers Blog.

Then search for the corresponding release with the farm build number as shown below:

In my case, the related release of my farm build number ‘15.0.4569.1000’ was SharePoint 2013 Service Pack 1.