Transforming my Grassroot Football Club with Microsoft 365 – Part 1 Understanding the basics

Hello,

Outside of my normal career as Senior Office 365 Architect, I run a football team called Wyrley Junior Ravens at the Under 10s level (Season 2022/2023). We are one of the numerous teams that are associated with Wyrley Juniors at the grassroots level.

Wyrley Juniors are a community club located in Staffordshire. They have 60 different teams registered across the leagues within the local area.

I decided to take it upon myself to look at how the club operates with communication and data retention. During my team with the club, I have found it hard to locate some information I need in order to really support my team.

In this article series, there will be multiple parts as I show how to leverage Microsoft 365 licensing.

So where did I start?

I have always been aware that Microsoft offers licenses for not-for-profit organizations so immediately I got to work understanding the process of how I could apply?

One of the key things that were so important to my application was that Wyrley Juniors are a registered UK Charities and are able to accept donations that help support the club’s goal to develop a safe environment for children within the community to play football.

Getting Started

First of all, your organization needs to be eligible under the following;

A nonprofit or non-governmental organization with recognized legal status in their respective country (equal to 501(c)(3) status under the United States Internal Revenue Code);

Public library that provides general library services without charge to all residents of a given community, district or region; or

Public museums, including public or private institutions, open to the public, that conserves and exhibit tangible objects for purposes of cultural preservation, education, or aesthetic enjoyment.

In addition to the organization criteria, eligible organizations must also operate on a not-for-profit basis and have a mission to benefit the local community that could include but is not limited to – providing relief to the poor; advancing education; improving social welfare; preserving culture; preserving or restoring the environment; promoting human rights; establishment of civil society.

Any organization that does not meet the criteria outlined above for eligible nonprofit missions is ineligible for Microsoft nonprofit programs. Visit Microsoft Licensing for more information about licensing options for ineligible organizations. Examples of ineligible organizations include, but are not limited to:

  • Nonprofit organizations that have not obtained recognized legal status in their respective country;
  • Governmental organizations or agencies, including international governmental organizations, and United Nations Entities;
  • Schools, colleges and universities including formal educational institutions, nonprofit schools, and academic museums;
  • Healthcare organizations including, but not limited to, hospitals, healthcare networks, health plans, and ambulatory/outpatient healthcare organizations;
  • Public Utilities, including public transportation, telecommunications, and utilities;
  • Financial institutions, including banks, insurance providers, and pension and retirement funds;
  • Professional, commerce and trade associations;
  • Professional and semi-professional sports organizations, including governing bodies, Olympics, and national or international tournaments;
  • Political, labor, and fraternal organizations;
  • Refurbishers that will be installing the software on refurbished computers to be distributed or donated to nonprofits or schools. Please email oemmar@microsoft.com for more information about the Registered Refurbisher Program;
  • Individuals.

Nonprofit discounts and grants are permitted for specific employees and volunteers. Nonprofit beneficiaries, donors, and members (such as members of a church, club, or sports team) are not eligible for nonprofit offers.

Grants vs. discounted licenses

Depending on the employee’s status and role in the nonprofit there is a difference between available offers:

  • Grants – Granted licenses are only permitted for paid employees and unpaid executive staff if all organization eligibility is met. User amount limits do apply and vary by the availability of country of usage. Additionally, organizations are expected to regularly remove unused granted licenses from their subscription. Adherence to policy guidance is encouraged and tenant may be subject to audit by Microsoft.
  • Discounts – Discounted licenses are permitted for all staff, including volunteers and temporary staff of the organization. Eligible nonprofits may access discounted pricing on commercial cloud offers, and some on-premise offers. Discounts vary by product, and/or quantity

Person making a presentation to other people in a boardroom

Paid employees

Paid staff includes employees on mandatory unpaid time off but who remain employees of the nonprofit, often referred to as furloughed staff. It does not include staff whose employment has been terminated or is subject to layoff. Paid staff are permitted to use granted and discounted licenses.Person in boardroom speaking to others while using a laptop

Unpaid executive staff

The unpaid executive staff is defined as unpaid staff that acts as senior leadership for the nonprofit. Eligible unpaid executive roles are board of directors, president, officer, executive director, and executive program directors. Eligible unpaid executive staff is permitted to use granted and discounted licenses.Group of volunteers passing cardboard boxes from delivery van

Volunteers and temporary staff

Volunteers is defined as all other non-executive unpaid staff and general volunteers. Discounted nonprofit offers are permitted for all nonprofit staff and volunteers.

TypeNon-profit Grant OffersNonprofit Discount OffersVolunteer Use Benefit
Paid Employees X X  
Unpaid Executive Staff X X X
Volunteers   X X
Contracted Staff (temporary, third-party)   X  
Beneficiaries, Members, Donors      
License Restrictions

Organizations cannot share, transfer, rent, or resell nonprofit licenses or subscriptions with/to other organizations or individuals even if they are part of the same group. If the group has both nonprofit and for-profit organizations in its legal structure, nonprofit offers are only permitted for eligible nonprofit organizations. Additionally, groups with centrally managed information technology (IT) systems are only eligible for one grant account. Please contact Microsoft to learn more about enterprise licensing options.

Information Overload

So I can appreciate the information overload above but all details have to be outlined to ensure you are fully aware of the do’s and don’ts

The most important part of all the information above, I highlighted in Blue

In addition to the organization criteria, eligible organizations must also operate on a not-for-profit basis and have a mission to benefit the local community that could include but is not limited to – providing relief to the poor; advancing education; improving social welfare; preserving culture; preserving or restoring the environment; promoting human rights; establishment of civil society.

Grassroots football is and always has been about delivering benefits to the local community by providing football to local young children.

Register

Head over to the following URL

https://signup.nonprofit.microsoft.com/en-us/welcome-policies

Step 1 – Tell us about yourself

Populate all of the required fields as shown with the red asterisk

You will be prompted to provide a verification code to the email address you specified above

Once you have entered the verification code, you will move on to step 2.

Step 2 – Tell us about your organization

Populate all of the required fields as shown with the red asterisk

  • Organisation Budget in USD – Change to 1
  • Add your Charity Number and any supporting documentation you may have.
Step 3 – Help us verify it’s you

Provide your number to verify you via text message or phone call

Step 4 – Create your Account

You are now required to create an account which will be given Administrator access to the Microsoft tenant.

Please Note: Under Your Company, please enter your club name for example wyrleyjuniors.

Microsoft will evaluate your potential eligibility. Registration review may take up to 7 days. You will receive an email notifying you if your registration has been approved.

While waiting for your registration review results get a head start with technical training through the Nonprofit Digital Skills Training, and more learning paths for nonprofit employees.

Once your registration is approved, you can access the Nonprofit Hub to take advantage of customized offerings to ensure the collaboration, productivity, and security of your organization.

Regards
Andrew Moran

In Part 2 – I run through the options of selecting the correct licenses plan for your club.

Whats new in the Microsoft 365 Roadmap today? 2023-01-24 01:00:42Z

Additions : 3
Updates : 12

More Details At: www.roadmapwatch.com

New Features Current Status
Microsoft Purview compliance portal: eDiscovery – Certificate based authentication support for eDiscovery PowerShell cmdlets In Development
Microsoft Purview compliance portal: Data Loss Prevention – Surface existing non-Microsoft DLP policies with the migration assistant In Development
Microsoft Stream: Timeline markers in Teams meeting recording for when your name was mentioned In Development
 
Updated Features Current Status Update Type
Outlook: Navigation changes for Android Rolling Out Status
Microsoft Purview compliance portal: Information Protection – Maintain label and protection when creating PDF files from VBA in Word, Excel, and PowerPoint (U.S. Government clouds) Launched Status
Microsoft Viva: Automatic Topic Relationships available in GCC Launched Status
Microsoft Search: Custom result types in Microsoft Search In Development Status
Microsoft Teams: RTMP-In for Teams Live Events Rolling Out Status
Outlook: Context IQ -inline search and insert Rolling Out Status
Outlook: MIP sensitivity label support S/MIME Launched Status
Microsoft Purview compliance portal: Information Protection – | Configure display colors for sensitivity labels Launched Status
Microsoft Stream and SharePoint: Inline playback of videos in Hero web part Launched Status
Windows 365: Windows 365 availability on GCC Launched Status
Windows 365: Windows 365 availability on GCCH Launched Status
Viva: Connections Feed Launched Status

Regards
The Author – Blogabout.Cloud

Whats new in the Microsoft 365 Roadmap today? 2023-01-21 00:01:17Z

Additions : 3
Updates : 5

More Details At: www.roadmapwatch.com


New FeaturesCurrent Status
Microsoft Purview compliance portal: Information Protection – | Maintain label and protection when import data to PowerBI (Web and Desktop)In Development
Excel: Blocking XLL add-ins from the internet.In Development
testIn Development
 
Updated FeaturesCurrent StatusUpdate Type
Whiteboard: Text formattingLaunchedStatus
Microsoft Teams: Microsoft Teams Rooms on Android – New touch and collaboration experiencesLaunchedStatus
Microsoft Purview compliance portal: Data Loss Prevention – DLP Policy tips revamp for Outlook for WindowsIn DevelopmentTitle, Description
Visio: Shape Data in Visio WebIn DevelopmentDescription
Microsoft Edge: In-browser JSON viewerIn DevelopmentDescription

Regards
The Author – Blogabout.Cloud

Whats new in the Microsoft 365 Roadmap today? 2023-01-20 01:02:00Z

Additions : 4
Updates : 15

More Details At: www.roadmapwatch.com


New FeaturesCurrent Status
Visio: Shape Data in Visio WebIn Development
Microsoft Edge: In-browser JSON viewerIn Development
Microsoft 365 admin center: New Activations Graph API Set Releasing for User Detail, Activation, and User Counts in Usage ReportsIn Development
Microsoft Search: Search & intelligence admin center, Search Usage Analytics, and Item InsightsIn Development
 
Updated FeaturesCurrent StatusUpdate Type
Outlook: S/MIME sensitivity label support natively on Outlook for WindowsLaunchedStatus
Microsoft Teams: Receive all group chat messages with resource-specific consentIn DevelopmentStatus
SharePoint: New site templatesRolling OutStatus
Microsoft Teams: Federated group callingLaunchedStatus
SharePoint: Adding an app to TeamsLaunchedStatus
Microsoft Purview compliance portal: Communication Compliance – Ability to analyze Microsoft Teams meeting transcriptsIn DevelopmentDescription
Microsoft Search: Custom result types in Microsoft SearchLaunchedStatus
Microsoft Teams: Collaborative Annotation on presenter shared screenLaunchedStatus
Microsoft Defender for Office 365: Enforce authentication to pass on AntiSpam allowed domains & senders for Spoof protectionLaunchedStatus
Windows 365: Point-in-Time Restore of Windows 365 Cloud PCs including recovery to different zone/datacenterLaunchedStatus
Windows 365: Ability to get a Cloud PC disk snapshot for forensic analysis and legal discoveryLaunchedStatus
Microsoft Teams: Viewing the Full Chat conversation thread after clicking on search message resultsLaunchedStatus
Microsoft Syntex: new rules actions – move and copyRolling OutStatus
Microsoft Viva: Create more than one Connections experience in the same tenantIn DevelopmentTitle, Description
Microsoft Viva: New landing experience for Viva Connections desktopRolling OutStatus

Regards
The Author – Blogabout.Cloud

Whats new in the Microsoft 365 Roadmap today? 2023-01-19 01:00:51Z

Additions : 5
Updates : 3

More Details At: www.roadmapwatch.com


New FeaturesCurrent Status
Microsoft Purview compliance portal: Communication Compliance – New built-in trainable and global classifiers (U.S. Government clouds)In Development
Outlook: Mandatory labeling pre-compose for iOSIn Development
Outlook: MIP sensitivity label support S/MIMEIn Development
Microsoft Purview compliance portal: Information Protection – Enhanced Source Code classifierIn Development
Microsoft Viva: Increased Language Availability for Viva GoalsIn Development
 
Updated FeaturesCurrent StatusUpdate Type
Microsoft Teams: Meeting Toolbar Usability ImprovementsRolling OutStatus
Microsoft Teams: Surface Message Actions by Most Recently Used MenuRolling OutStatus
SharePoint on Stream: Inline playback of videos in SharePoint Highlighted content web parts for Grid, list and Compact layoutsCancelledStatus, Description

Regards
The Author – Blogabout.Cloud

Whats new in the Microsoft 365 Roadmap today? 2023-01-18 01:01:35Z

Additions : 3
Updates : 4

More Details At: www.roadmapwatch.com


New FeaturesCurrent Status
Microsoft Purview compliance portal: Information Protection – New cmdlet for Content ExplorerIn Development
Microsoft Viva: Goals Bulk OKR ImportIn Development
Microsoft Viva: Goals Audit LogsIn Development
 
Updated FeaturesCurrent StatusUpdate Type
Microsoft Project: Custom Calendars in Project for the WebRolling OutStatus
Office App: Idle session timeout for Microsoft 365 web appsRolling OutDescription
OneDrive: Known Folder Move for macOSLaunchedStatus
Microsoft Purview compliance portal: Additional third-party data connectors (Veritas)CancelledStatus, Description

Regards
The Author – Blogabout.Cloud

Updating your PowerShell Modules to the latest versions

It is very common that important PowerShell modules used with Microsoft 365 are not updated on client machines. The PowerShell Gallery regulary receives updates to all your favorites modules.

Wouldnt it be nice to have one script that checked and updated all your installed modules? The following script will;

  • Start a transcript to output the console display
  • Get all modules installed
  • Check the PowerShell Gallery to see if an update is available and if so, download then install it.
  • Also provide a clean up by checking the PC for versions of a module and removing all but the latest to ensure that scripts only ever run the latest cmdlets.
  • Stop the transcript and make available on the users desktop.

All you need to do is run the script “As Administrator”

Clear-Host
 <#Information
 
    Author: thewatchernode
    Contact: andrew.moran@lyncme.co.uk
    Published: 16th January 2023

    .DESCRIPTION
    Tool to assist with removal of legacy installed PowerShell Module from PSGallery

    Version Changes             : 0.1 Initial Script Build
                                : 1.0 Initial Build Release
     
    .EXAMPLE
    .\Get-InstalledModulesUpdate.ps1

    Description
    -----------
    Runs script with default values.


    .INPUTS
    None. You cannot pipe objects to this script.
#>
 #region Shortnames
 $Red = 'Red'
 $Green = 'Green'
 $DarkRed = 'DarkRed'
 $White = 'White'
 $DarkCyan = 'DarkCyan'
 $DarkGray = 'DarkGray'
 #endregion

# Array for Modules
    #$CommonO365Module = @('MSOnline', 'Microsoft365DSC', 'Microsoft.Graph', 'ExchangeOnlineManagement', 'Microsoft.Online.Sharepoint.PowerShell', 'ORCA','AzureAD')
    $Array = @(Get-InstalledModule)
 
 
Function Get-ModuleUpdates {# Check and update all modules to make sure that we're at the latest version
# Check and remove older versions of the modules from the PC
    ForEach ($Module in $array) {
    Write-Host 'INFO: Checking for older versions of' $Module.Name 'installed on client device' -BackgroundColor $DarkCyan -ForegroundColor $White
    $AllVersions = Get-InstalledModule -Name $Module.Name -AllVersions
    $AllVersions = $AllVersions | Sort -Property PublishedDate -Descending 
    $MostRecentVersion = $AllVersions[0].Version
    Write-Host 'Most recent version (' $MostRecentVersion ') for' $Module.Name 'is installed on client device'
   
    If ($AllVersions.Count -gt 1 ) { # More than a single version installed
    ForEach ($Version in $AllVersions) { #Check each version and remove old versions
    If ($Version.Version -ne $MostRecentVersion)  { # Old version - remove
    Write-Host 'Uninstalling version' $Version.Version 'of Module' $Module.Name -BackgroundColor $DarkRed -ForegroundColor $White 
    Uninstall-Module -Name $Module.Name -RequiredVersion $Version.Version -Force
         } #End if
      } #End ForEach
  } #End If
} #End ForEach
}

 Write-host 'Version information - You are running script version 1.0' -ForegroundColor $White -BackgroundColor $DarkGray
  @'
  ┌─────────────────────────────────────────────────────────────┐
           Updating your PSGallery PowerShell Modules

               Follow @thewatchernode on Twitter                               
  └─────────────────────────────────────────────────────────────┘
'@
Start-Transcript -Path $env:USERPROFILE\desktop\ModuleUpdate_Log.txt
Get-ModuleUpdates
Stop-Transcript

Keep your modules updated!!!

Regards
Andrew Moran

Powershell Tip – Export Exchange Online to CSV Error (TYPE Microsoft.PowerShell.Commands.Internal.Format.FormatStartData)

I recently ran into an error message when trying to export information from Exchange Online to a CSV.

Error: (TYPE Microsoft.PowerShell.Commands.Internal.Format.FormatStartData)

When running the below command I could see that my data was displaying the PowerShell console

Get-EXOMailbox | Get-EXOMailboxStatistics | ft displayname, totalitemsize

But when running the below cmdlet the data didnt render as expected.

Get-EXOMailbox | Get-EXOMailboxStatistics | ft displayname, totalitemsize | export-csv C:\_build\EXOUsageMX1.csv

Thankfully this error was caused by the use of FT (Format-Table) when I switch the command to

Get-EXOMailbox | Get-EXOMailboxStatistics | select displayname, totalitemsize | export-csv C:\_build\EXOUsageMX1.csv

The data was rendered as expected 🙂 PowerShell typos are a pain.

Regards
Andrew Moran

MC445406 – Announcing Microsoft Teams Premium

Updated January 14, 2022: We have updated the content below to provide additional clarity. Thank you for your patience.

Today, we are excited to announce Microsoft Teams Premium. Built on the familiar, all-in-one collaboration experience of Microsoft Teams, this new offering makes every meeting from 1:1s to large meetings, to virtual appointments to webinars more personalized, intelligent, and protected. Unlike the disconnected experience and costs of multiple point products or add-ons, with Teams Premium you get everything you need for just one low price.

As part of the Teams Premium announcement, these existing features will move to Teams Premium, and will be still open for everyone for a grace period of time:

  • Live translation of captions – available to all until 60 days after Teams Premium General availability.
  • Custom together mode scenes – available to all until 30 days after Teams Premium General availability.
  • Timeline markers in Teams meetings recordings (join/leave meetings)- available to all until 30 days after Teams Premium General availability.
  • Virtual Appointments – available to all until 30 days after Teams Premium General availability.
    • SMS notifications
    • Organizational analytics in Admin Center
    • Scheduled queue view

Teams Premium will be generally available in February.

Learn more about Teams Premium here: Introducing Microsoft Teams Premium, the better way to meet.

MC497317 – Actionable Missed call Notification in Activity

Message Summary

Users will have the option to call back on a missed call directly from their activity feed. This will help users complete the underlying task quickly and improve triaging of activities.

This message is associated with Microsoft 365 Roadmap ID 102236

When this will happen:

Preview: We will begin rolling out mid-January and expect to complete by late January.

Standard Release: We will begin rolling out early February and expect to complete by mid-February.

>How this will affect your organization:

There are no tenant level settings. Defaults will not change.

Image of call directly back function
View image in new tab

What you need to do to prepare:

There is no action needed to prepare for this change. You may want to notify your users about this change and update any relevant documentation as appropriate.

Sitting on a cloud discussing Microsoft Technologies