Skip to main content

Monitor and notify Microsoft 365 health status

Author: Arjun Menon

This is a script which monitors the health status of your Microsoft 365 tenant and notifies if something is not normal. Script creates a SharePoint List and will add the outage content to that. It will also send an email notification to the configured user.

Script Overview​

Following is the overview of the script package

  1. We use the command tenant serviceannouncement health list for getting the current status.

  2. If there is an outage or some of the service is not normal, we will be adding the information to SharePoint list using the command spo listitem add

    1. Advantage of adding to SharePoint list - You can configure Power Automate for List item Added so that you can define your business process if needed

  3. Script also will send an email to the configured user/s using the command spo mail send so that concerned team could be notified

Bonus Action​

All the pre-requisites would be completed by the script. Script checks whether SharePoint List exists in the SharePoint site. If it does not exist, it will create a SharePoint List using spo list add command and will also add the needed fields. Person who is executing the script just need to have Edit permission in the site against which the script will be executed.

If you want to schedule the script directly, you can go ahead without the need of any other configurations.

#Ensure that you are logged in to the site mentioned in the webURL as a user who has Edit Permission
$webURL = "https://contoso.sharepoint.com/sites/contososite"
$listName = "M365HealthStatus"
#Email address to which an outage email will be sent
$notifyEmail = "itpro@contoso.onmicrosoft.com"

$CurrentList = (m365 spo list get --title $listName --webUrl $webURL --output json) | ConvertFrom-Json

#Checking whether List exists. Will create the list if the List doest not exist
if ($CurrentList -eq $null) {
  Write-Host "List does not exist. Hence creating the SharePoint List"

  #Creating the list - Conventional
  $CurrentList = m365 spo list add --baseTemplate GenericList --title $listName --webUrl $webURL

  #Adding the fields
  $FieldLists = @(
    @{fieldname = "Workload"; fieldtype = "Text"; }, @{fieldname = "FirstIdentifiedDate"; fieldtype = "DateTime"; }, @{fieldname = "WorkflowJSONData"; fieldtype = "Note"; }
  )

  Foreach ($field in $FieldLists) {
    $addedField = m365 spo field add --webUrl $webURL --listTitle $listName --xml "<Field Type='$($field.fieldtype)' DisplayName='$($field.fieldname)' Required='FALSE' EnforceUniqueValues='FALSE' Indexed='FALSE' StaticName='$($field.fieldname)' Name='$($field.fieldname)'></Field>" --options AddFieldToDefaultView
  }

  Write-Host "Created SharePoint List $listName for logging the Outages."
}

#Getting current Tenant Status and do the needed operations
$workLoads = m365 tenant serviceannouncement health list --issues --query "[?status != 'serviceOperational']" --output json | ConvertFrom-Json
$currentOutageServices = (m365 spo listitem list --webUrl $webURL --listTitle $listName --fields "Title, Workload, Id" --output json).Replace("ID", "_ID") | ConvertFrom-Json

#Checking for any new outages
$updateSinceLastExecution = $false
Write-Host "`n### New Outages ###"

Foreach ($workload in $workLoads) {
  if ($workload.id -notin $currentOutageServices.Workload) {
    #Add outage information to SharePoint List
    $addedWorkLoad = m365 spo listitem add --webUrl $webURL --listTitle $listName --contentType Item --Title $workload.service --Workload $workload.id --FirstIdentifiedDate (Get-Date -Date $workload.issues[$workload.issues.Count -1].startDateTime) --WorkflowJSONData (Out-String -InputObject $workload -Width 400)

    #Send notification using CLI Commands
    m365 outlook mail send --to $notifyEmail --subject "Outage Reported in $($workload.service)" --bodyContents "An outage has been reported for the Service : $($workload.service) <a href='$webURL/Lists/$listName'>Access the Health Status List</a>" --bodyContentType HTML --saveToSentItems false

    Write-Host "Outage is Reported for Service : $($workload.service). Please access $webURL/Lists/$listName for more information"
    $updateSinceLastExecution = $true
  }
}

if ($updateSinceLastExecution -eq $false) {
  Write-Host "NO New Outages are reported yet."
}

#Checking whether any existing outages are resolved
$updateSinceLastExecution = $false
Write-Host "`n### Resolved Outages ###"

Foreach ($Service in $currentOutageServices) {
  if ($Service.Workload -notin $workLoads.id) {
    #Removing the outage information from SharePoint List
    $removedRecord = m365 spo listitem remove --webUrl $webURL --listTitle $listName --id $Service.Id --force

    #Send notification using CLI Commands
    m365 outlook mail send --to $notifyEmail --subject "Outage RESOLVED for $($Service.Title)" --bodyContents "Outage which was reported for the Service : $($Service.Title) is RESOLVED." --bodyContentType HTML --saveToSentItems false

    Write-Host "Outage which was reported for the Service : $($Service.Title) is now RESOLVED."
    $updateSinceLastExecution = $true
  }
}

if ($updateSinceLastExecution -eq $false) {
  Write-Host "No further updates on the existing outages"
}
CTRL + M