Annual Report 2020

stats chart

Happy new year to all my dear readers and followers. And what a crazy year 2020 has been, where the pandemic forced the hand of those delaying digital transformation. The uptake of work from home and supporting technologies and adoption was phenomenal, and professionally it has been an extremely busy year. As you can spend your time only once, the year again proved to be a challenge for those busy working on customer projects while tending to the community as well. In the end, it is all about finding a balance, especially if you are working from home and the rest of the household is as well. And then there’s this cat.

That said, I thought it would be nice to kick 2021 off with reinstating the annual report. I’d like to share with you some of blog’s statistics of 2020, the blog’s 10th year running. The statistics come directly from the site and without additional observations, apart from that for some reason looking things up related to Exchange 2010 still remains to be very popular.

General 2020 Stats

  • Number of views: 300,370 (2,811,923 all-time)
  • Unique visitors: 129,905 (1,457,892 all-time)
  • Number of posts: 20 (629 total)
  • Followers: 450
  • Busiest day: November 18th (3,496 views – Teams Custom Background referrals)
  • Most time: Wednesday, 4pm
  • Top post of 2020: Configuring Exchange Online with IMAP & OAuth2

Most popular blogs from 2020

Apart from the Versions, Builds and Dates, Schema Versions and Toolkit pages, the newly introduced Teams Custom Backgrounds page stood out this year with 13,117 in just a few months. When it comes to blogs published in 2020, the most viewed posts are:

Blog from 2020
Configuring Exchange Online with IMAP & OAuth2
Exchange Online Management using EXOv2 module
Outlook Connectivity changes per Nov2021
Security Updates Exchange 2010-2019 (Dec2020)
Holiday Season Teams background

Most popular all-time blogs

BLOG (All-Time)
Limiting Exchange 2010 Database Cache /
Limiting Exchange 2010 SP1 Database Cache
Exchange ActiveSync and Inheritable Permissions issue
TargetAddress, ExternalEmailAddress and Set As External
The Attribute, the Myth, the legacyExchangeDN
Exchange Message Size Limits

Top Scripts in 2020 (GitHub)

Script
Connect-Office365Services
Get-EventSession
Remove-DuplicateItems
Install-Exchange15
Remove-MessageClassItems

Top visitor countries in 2020

Country
United States
United Kingdom
Germany
Netherlands
Canada

Top referrers in 2020

Referer
Google
Bing
Spiceworks (community)
Twitter
Practical365 (blog)

Most used search terms in 2020

Search term(s)
exchange versions
exchange 2010 end of life
exchange schema versions
office 2016 support lifecycle
exchange version 15.1

Holiday Season Teams background

Update: Per request, added SharePoint and OneDrive, and did some manual corrections.

A really short post on a Ugly Sweater background with Exchange, Teams and Outlook theme to use during those conference calls end of December. Enjoy!

Like it or not, leave feedback in the comments. Also, suggestions are welcomed. In case you are not aware, I keep a set of custom background for you to enjoy here.

MVPs around the World (2020)

With great honor and joy I can announce that I have been awarded the Microsoft Most Valuable Professional award for the seventh consecutive year, again in the category Office Apps & Services. Congratulations to other new and re-awarded MVPs as well, and kudos to the MVP program in undertaking the monstrous task of reviewing and evaluating thousands of contributions every award cycle.

With another award cycle also comes the time to have a look at the MVP statistics. Below numbers are taken from the public MVP site. July 3rd is chosen as the first days the site gets updated and new awardees need to turn in their NDA before they show up on the site.

Because people can get awarded each month, the comparison to July 3rd of every year indicates only yearly trend. Therefor we’ll also compare the numbers to those of June to see the impact on long-term MVP population, as awardees from January are only up for consideration in July 2021 for example.

From the numbers, it is clear that this cycle the number of MVPs went a bit down from 2.998 in June 2020 to 2.850 now (-5%), but it is higher than the 2.634 (+8%) of July 2019.

The following table contains the changes per award category from July 2019 and June 2020 to July 2020. I will leave the interpretation up to you.

ExpertiseJuly 2019June 2020ChangeJuly 2020Change
Cloud and Datacenter Management2322424%209-10%
Microsoft Azure40945511%46313%
Office Apps & Services4915308%5124%
Business Applications16623441%24045%
Data Platform33237513%3588%
Developer Technologies64474215%6978%
Enterprise Mobility10611912%1137%
AI8410930%12245%
Office Development476028%6436%
Windows Development1191233%110-8%
Windows and Devices for IT5755-4%43-25%
Total Awards2687304413%29319%
Total MVPs2634299814%28498%

Note: The total number of MVPs doesn’t equal the total number of awardees, as MVPs can be awarded in more than one category; there are now 82 people awarded in multiple categories’; an increase of 57% compared to June 2019.

When zooming in on the Office Apps & Services category, the awards per country are shown below, including change compared to last year. Be advised that 26 OAS MVPs are anonymous or have profiles without information on residency.

image
CountryNumberCountryNumberCountryNumber
Australia24 (20%)India13 (0%)Saudi Arabia1 (0%)
Austria3 (0%)Ireland1 (0%)Serbia1 (0%)
Belgium5 (-38%)Israel1 (0%)Singapore3 (0%)
Bosnia and Herzegovina1 (0%)Italy5 (-17%)Slovakia1 (0%)
Brazil8 (-20%)Japan20 (-10%)Slovenia2 (0%)
Bulgaria2 (0%)Korea12 (0%)South Africa4 (-20%)
Cambodia1 (100%)Luxembourg1 (100%)Spain12 (50%)
Canada33 (6%)Macedonia, FYRO2 (0%)Sri Lanka1 (0%)
China17 (6%)Malaysia1 (0%)Sweden9 (80%)
Colombia5 (25%)Mexico5 (0%)Switzerland3 (50%)
Croatia5 (25%)Myanmar1 (100%)Taiwan4 (0%)
Czech Republic2 (0%)Nepal1 (0%)Thailand2 (-34%)
Denmark6 (0%)New Zealand6 (0%)The Netherlands22 (4%)
Egypt1 (0%)Nigeria2 (100%)Turkey2 (0%)
El Salvador1 (0%)Norway6 (0%)Ukraine2 (0%)
Finland4 (33%)Pakistan1 (-50%)United Arab Emirates1 (-50%)
France18 (-10%)Poland6 (50%)United Kingdom33 (17%)
Germany24 (-4%)Portugal3 (50%)United States123 (2%)
Hungary2 (0%)Russia9 (12%)Uruguay1 (0%)

And last, the number of Office Apps & Services and total number of MVP’s over the last years, before and after the award cycle.

June
2017
July
2017
June
2018
July
2018
March
2019
July
2019
June
2020
July
2020
OSS532449490383622491530512
-16%9%-22%62%-21%8%-3%
Total41343490381530303205263429982849
-16%9%-21%6%-18%14%-5%

On a final note, the above data is static; some MVPs have build great dashboards which allow you to work with the data more interactively (if they have updated their data set, that is). Some noteworthy mentions:

If you have questions or comments, please leave them in the comments below.

Security Updates Exchange 2013-2019 (Nov2019)

Exchange2019LogoA quick blog on recently published security updates for Exchange Server 2013 up to Exchange Server 2019. These fixes address the following vulnerabilities:

  • CVE-2019-1373: Microsoft Exchange Remote Code Execution Vulnerability

The CVE documents contain more details on the vulnerabilities. The exploits can be fixed by single security update, which you can find in the table below per current Exchange version.

ExchangeDownloadBuildKBSupersedes
Exchange 2019 CU3Download15.2.464.7 KB4523171KB4515832
Exchange 2019 CU2Download15.2.397.9 KB4523171 KB4515832
Exchange 2016 CU14Download15.1.1847.5 KB4523171 KB4515832
Exchange 2016 CU13Download15.1.1779.7 KB4523171 KB4515832
Exchange 2013 CU23Download15.0.1497.4 KB4523171 KB4509409

Be advised that the Security Updates for Exchange 2013-2019 are Cumulative Update level specific. Unfortunately, the security update carries the same name for different CUs, and you cannot apply the update for Exchange 2016 CU14 to Exchange 2016 CU13. I would suggest tagging the Cumulative Update in the file name when you store it, e.g. Exchange2016-CU14-KB4523171-x64-en.msp.

As with any patch or update, I’d recommend to apply this in a acceptance environment first, prior to implementing it in production.

Exchange Updates – Sep. 2019

Exchange2019LogoToday, the Exchange Team released the quarterly Cumulative Updates for Exchange Server 2019 as well as Exchange 2016. The fixes in each release, product downloads are described below:

VersionBuildKBDownloadUMLPSchema
Exchange 2019 CU315.2.464.5KB4514141VLSC N
Exchange 2016 CU1415.1.1847.3KB4514140DownloadUMLPN

Exchange 2019 CU3 fixes:

  • 4515257 Hash mismatch is reported for Exchange DLLs in the bin directory of Exchange Server 2019
  • 4502159 Adding or removing mailbox permission in EAC doesn’t address the msExchDelegateListLink attribute in Exchange Server 2019 and 2016
  • 4515276 Room mailbox accepts a meeting as “Free” if a booking delegate is set in Exchange Server 2019 and 2016
  • 4515275 Enable Get/Restore-RecoverableItems to work with Purges folder in Exchange Server 2019 and 2016
  • 4515274 AutodiscoverV2 request returns REST API endpoint not AutoDiscoverV1 endpoint in Exchange Server 2019 and 2016
  • 4515269 SentToMemberOf shows every recipient type not distribution groups when you create transport rule in Exchange Server 2019 and 2016
  • 4515272 Message is blocked in “SMTP Delivery to Mailbox” queue if exchange server is added in groups of a child domain in Exchange Server 2019 and 2016
  • 4515271 Can’t convert a migrated remote user mailbox to shared in Exchange Server 2019 and 2016
  • 4515270 SubmissionQueueLengthMonitor shows “System.ArgumentException: Transition timeout…” in Exchange Server 2019 and 2016
  • 4515267 NDR occurs when you resend message from alternate journaling mailbox to journaling mailbox in Exchange Server 2019 and 2016
  • 4515265 Removing In-Place Hold doesn’t work for mailboxes in different domains in Exchange Server 2019 and 2016
  • 4515264 FindPeople request from Skype for Business on Mac fails with “Invalid Shape Specification” in Exchange Server 2019 and 2016
  • 4515263 Hide the “Validate-MailFlowThroughFrontDoor” command for Exchange Server 2019 and 2016
  • 4515262 Enable Remove-MobileDevice to delete mobile devices after migrating to Office 365 from Exchange Server 2019 and 2016
  • 4515261 Can’t copy eDiscovery search results for mailboxes with Exchange online archives in Office 365 in Exchange Server 2019 and 2016
  • 4515273 Mailbox auditing fails when using SHA1Managed in Exchange Server 2019 and 2016
  • 4515266 Infinite loop in Recurrence.GetNumberOfYearsBetween() with the Japanese calendar in Exchange Server 2019 and 2016
  • 4520319 S/MIME signed reply draft behaves like the first message in conversation in Exchange Server 2019 and 2016
  • 4515832 Description of the security update for Microsoft Exchange Server 2019 and 2016: September 10, 2019

Exchange 2016 CU14 fixes:

  • 4515255 “X-InnerException: Microsoft.Mapi.MapiExceptionRpcServerTooBusy” error when you try to use a mailbox in Exchange Server 2016
  • 4515254 Event 1009 frequently occurs in application logs for lagged database copies in Exchange Server 2016
  • 4502159 Adding or removing mailbox permission in EAC doesn’t address the msExchDelegateListLink attribute in Exchange Server 2016
  • 4515276 Room mailbox accepts a meeting as “Free” if a booking delegate is set in Exchange Server 2016
  • 4515275 Enable Get/Restore-RecoverableItems to work with Purges folder in Exchange Server 2016
  • 4515274 AutodiscoverV2 request returns REST API endpoint not AutoDiscoverV1 endpoint in Exchange Server 2016
  • 4515269 SentToMemberOf shows every recipient type not distribution groups when creating transport rule in Exchange Server 2016
  • 4515272 Message is blocked in “SMTP Delivery to Mailbox” queue if exchange server is added in groups of a child domain in Exchange Server 2016
  • 4515271 Can’t convert a migrated remote user mailbox to shared in Exchange Server 2016
  • 4515270 SubmissionQueueLengthMonitor shows “System.ArgumentException: Transition timeout…” in Exchange Server 2016
  • 4515267 NDR occurs when you resend message from alternate journaling mailbox to journaling mailbox in Exchange Server 2016
  • 4515265 Removing In-Place Hold doesn’t work for mailboxes in different domains in Exchange Server 2016
  • 4515264 FindPeople request from Skype for Business on Mac fails with “Invalid Shape Specification” in Exchange Server 2016
  • 4515263 Hide the “Validate-MailFlowThroughFrontDoor” command for Exchange Server 2016
  • 4515262 Enable Remove-MobileDevice to delete mobile devices after migrating to Office 365 from Exchange Server 2016
  • 4515261 Can’t copy eDiscovery search results for mailboxes with Exchange online archives in Office 365 in Exchange Server 2016
  • 4515273 Mailbox auditing fails when you use SHA1Managed in Exchange Server 2016
  • 4515266 Infinite loop in Recurrence.GetNumberOfYearsBetween() with the Japanese calendar in Exchange Server 2016
  • 4520319 S/MIME signed reply draft behaves like the first message in conversation in Exchange Server 2016
  • 4515832 Description of the security update for Microsoft Exchange Server 2019 and 2016: September 10, 2019

Notes:

  • These Cumulative Updates do not contain schema changes compared to their previous Cumulative Update.
  • When upgrading from an n-2 or earlier version of Exchange, or an early version of the .NET Framework, consult Upgrade Paths for CU’s & .NET.
  • Don’t forget to put the Exchange server in maintenance mode prior to updating. Regardless, setup will put the server in server-wide offline mode post-analysis, before making actual changes.
  • When using Exchange hybrid deployments or Exchange Online Archiving (EOA), you are required to delay installing at most one version (n-1).
  • If you want to speed up the update process for systems without internet access, you can follow the procedure described here to disable publisher’s certificate revocation checking.
  • Cumulative Updates can be installed directly; no need to install RTM prior to installing Cumulative Updates.
  • Once installed, you can’t uninstall a Cumulative Update nor any of the installed Exchange server roles.
  • The order of installation shouldn’t matter with the “every server is an island” concept, yet recommended is to upgrade internet-facing, non-internet-facing servers first, followed by Edge Transports.

Caution:

As for any update, I recommend to thoroughly test updates in a test environment prior to implementing them in production. When you lack such facilities, hold out a few days and monitor the comments on the original publication or forums for any issues.