Microsoft Office 365 SharePoint Online

This template shows information about Office 365 SharePoint Online and includes the following component monitors:

  • Site Name & Count
  • Site Status
  • Storage Used by Site
  • Storage Allocated to Site
  • Number of Page View
  • Number of files on Site

Portions of this topic are based on What is the SharePoint Online Management Shell?, Overview of Microsoft Graph, and Working with Office 365 usage reports in Microsoft Graph (© 2019 Microsoft Corp., available at https://docs.microsoft.com, obtained on May 8, 2019).

Prerequisites

  • The following component monitors use the PowerShell SharePoint Online Module:
    • Site Name & Count
    • Site Status
    • Storage Used by Site
    • Storage Allocated to Site

    To Install the PowerShell SharePoint Online Module, execute Install-Module -Name Microsoft.Online.SharePoint.PowerShell in your PowerShell console.

    To verify installation, run Get-Module -ListAvailable -Name "*SharePoint*.

    All four monitors require Organization Name in script arguments, orgName=<Value>.

  • Configure these two monitors to use the Microsoft Graph API to fetch data; see Integrate Office 365 templates with Microsoft Graph:
    • Number of Page View
    • Number of Files on Site

    Pass the details collected from the Graph API as arguments to monitors in the following format/precedence:

    Client_id=<Value>, TenantID=<Value>, client_secret=<Value>

Credentials

  • User belongs to the SAM Administrator group

    Use UPN format (username@domain) and not domain\username format to enter credentials. Also, SolarWinds recommends using a service account for Exchange Web Services to avoid authentication issues when passwords are updated.

  • Pass Client ID/Application ID and Password as arguments to monitors

Monitored Components

Site Name & Count

Get the Count of the Sites and return all Site Names in message

Arguments: Organization Name

Format: OrgName=<value>

Statistic Unit: Number

Site Status

Get the Status of a particular site.

Argument: Organization Name, Site URL

Format: orgName=<value>, siteName=<value>

Output: 0 – In-active, 1 – Active

Statistic Unit: Boolean (0 or 1)

Storage Used by Site

Get the Storage of the site used. The Monitor returns the Storage of all the sites, in case a User want the Storage of a particular site than “site name” can be passed as argument

Argument: Organization Name, Site URL (Optional)

Format: orgName=<value>, siteName=<value>

Statistic Unit: GB

Storage Allocated to Site

Get the Storage allocated to a particular site.

Argument: Organization Name, Site URL

Format: orgName=<value>, siteName=<value>

Statistic Unit: GB

Number of Page View

Get the number of pages viewed across all sites.

Argument: Client ID, Tenant ID, Client Password

Format: client_id=<Value>, TenantID=<Value>, client_secret=<Value>

Statistic Unit: Number

Number of files on Site

Get the total number of files across all sites.

Argument: Client ID, Tenant ID, Client Password

Format: client_id=<Value>, TenantID=<Value>, client_secret=<Value>

Statistic Unit: Number