LogicMonitor offers out-of-the-box monitoring for Microsoft 365. With LogicMonitor’s Microsoft 365 packages, you can monitor the state of your Microsoft 365 deployment and the underlying services and license usage that allows you to identify faults and manage performance.
- Import the Microsoft 365 LogicModules. See Import LogicModules. Importing the LogicModules must be done before setting up Microsoft 365 for LogicMonitor to create a dashboard for the monitored resources.
- Collect and save the following information in Azure as you go through the steps for Setting Up a LogicMonitor Account in Microsoft 365. You’ll need this information later when you set up monitoring:
- Application (client) ID: Located in Azure > App Registrations
- Directory (tenant) ID: Located in Azure > Active Directory
- Value: Located in Azure > App registrations > Certificates & secrets > Client secrets
From the LogicMonitor repository, import all Microsoft 365 LogicModules, which are listed in the LogicModules in the Package section of this support article. If these LogicModules are already present, ensure you have the most recent version.
Once the LogicModules are imported (assuming all previous setup requirements have been met), the PropertySources will automatically detect the host and assign the appropriate values to the
system.categories property. These settings will also automatically associate the DataSources (and ConfigSources if supported by your LogicMonitor account) and data monitoring will begin.
LogicModules in Package
LogicMonitor’s package for Microsoft 365 consists of the following LogicModules. For full coverage, ensure that all of these LogicModules are imported into your LogicMonitor platform.
|Microsoft_Office365_Subscriptions||DataSource||Monitors Mircosoft 365 subscriptions.|
|Microsoft_Office365_ServiceHealth||DataSource||Monitors the Office 365 service health.|
|Microsoft_Office365_Teams_Device_Usage||DataSource||Monitors the last seven days of Microsoft Teams device usage by the number of users.|
|Microsoft_Office365_Teams_Activity||DataSource||Monitors the last seven days of Microsoft Teams activity.|
|Microsoft_Office365_OneDriveFileCount||DataSource||Monitors OneDrive total and active files, as well as the time since the report was last updated.|
|Microsoft_Office365_OneDriveAccounts||DataSource||Monitors the number of Active and Total accounts on OneDrive.|
|Microsoft_Office365_OneDriveStorage||DataSource||Monitors OneDrive total storage used.|
|Microsoft_Office365_EmailActivity||DataSource||Monitors Outlook total and rate counts for read, received, and sent emails.|
|Microsoft_Office365_EmailAppUsage||DataSource||Monitors usage by application or Office version.|
|Microsoft_Office365_UserCount||DataSource||Monitors individual Office365 services and their associated user activity.|
|Microsoft_Office365_SharepointSiteDetails||DataSource||Monitors the overall status of the SharePoint site. For more information, see Granular Monitoring of SharePoint.|
|Microsoft_Office365_SharepointStorage||DataSource||Monitors SharePoint site storage.|
|Microsoft_Office365_Skype_DeviceUsage||DataSource||Monitors Skype usage by device type.|
|Microsoft_Office365_Skype_PeerActivityMinutes||DataSource||Monitors Microsoft 365 Skype for Business user activity by minutes for video and audio.|
|Microsoft_Office365_Skype_PeerActivity||DataSource||Displays Skype for business peer-to-peer activity counts.|
|Microsoft_Office365_MailboxQuotaStatus||DataSource||Monitors the number of Mailboxes in different quota states.|
|Microsoft_Office365_MailboxUsageDetail||DataSource||Fetches details about mailbox usage.|
|Microsoft_Office365_Yammer_Device_Usage||DataSource||Monitors Yammer usage by device type.|
Setting Up LogicMonitor Account in Microsoft 365
Follow these steps to register and authorize a new application to call the reports API:
1. Log into the Azure portal using an administrator account.
2. From the Azure Services menu, click Azure Active Directory and click Add.
3. Navigate to Home > Organizational account > Manage > App registrations and click +New registration.
4. On the Register, an application page, enter the following details:
- Name: Enter a display name for the application. This name will be used throughout your Azure portal and does not have any specific requirements.
- Supported account types: Select the Accounts in this organizational directory only option.
- Redirect URI: This setting is optional and can be left unspecified. Enter the name for the application.
5. Click Register.
6. On the Registration page, copy and save the Application (client) ID and Directory (tenant) ID.
7. On the left navigation pane, click API permissions.
8. Click +Add permission.
9. On the Request API permission panel, click Microsoft Graph to configure Microsoft APIs.
10. Click Application permissions.
11. Add the following permissions to gather properties for collection.
|User.Read||Allows you to sign in to the app with your organizational account and let the app read your profile. Also, allows the app to read basic company information.|
|Reports.Read.All||Allows the app to read all service usage reports without a signed-in user. Services that provide usage reports include 365 and Azure Active Directory.|
|Organization.Read.All||Allows the app to read the organization and related resources, without a signed-in user. Related resources include subscribed SKUs and tenant branding information.|
|Directory.Read.All||Allows the app to read data in your organization’s directory, such as users, groups, and apps, without a signed-in user.|
|Allows the app to read service health of your organizational account.|
12. Click Add permissions.
13. On the left navigation pane, click Certificates & secrets.
14. Add +New client secret.
15. On the Add a client secret pane, add information in the Description and the Expires fields.
16. Click Add.
17. On the Clients Secret tab, copy and save the Value to a secure location. You will not be able to retrieve this information after you leave the screen.
Setting up Microsoft 365 Account for Monitoring
Add your Microsoft 365 account into LogicMonitor from Exchange > Cloud Integrations.
1. Log into the LogicMonitor Portal.
2. On the left navigation pane, click Exchange.
3. Click Cloud Integrations.
4. Select Office 365 and click Add.
5. On the Name page, enter the following details:
- Name: (Required) Enter a name for the Office 365 account.
- Description: Provide a description for this Office 365 account.
- Parent Group: (Required) Assign the Office 365 account to a parent group. By default, it will be assigned to the root group of the portal.
- Properties: Define properties and values.
6. On the Permissions page, enter the details that you collected from Azure:
- User ID: This is the Application (client) ID from Azure > App Registrations.
- Tenant ID: This is the Directory (tenant) ID from Azure > Active Directory.
- Secret Key: This is the Value field from Azure > App registrations > Certificates & secrets > Client secrets.
7. After you click Add Service, you should be able to view resources and dashboards from your Office 365 application.
Example Use Cases
Next, we’ve highlighted a sample dashboard and some sample monitoring scenarios that could be accomplished with the Office 365 LogicModule package.
Granular Monitoring of SharePoint
The SharePoint DataSources monitors multiple SharePoint site instance usage, traffic, storage, and file count, providing granular flexibility when monitoring SharePoint. With this information, you can decide whether to delete or combine sites that don’t get a lot of traffic but use up a considerable amount of storage.
On September 1, 2021 Microsoft removed identifiable user information such as usernames, groups, and sites from all their SharePoint usage reports. For more information, see Show user details in the reports.
If you want LogicMonitor to monitor SharePoint Site Usage Details, which uses that information for instance naming, you’ll need to make these configuration changes to your Microsoft 365 settings to display the user information:
- As a Global Administrator, in the admin center, go to Settings > Org Settings > Services.
- Select Reports.
- Uncheck the statement In all reports, display de-indentified names for users, groups, and sites.
- Save your changes.
Service Availability Monitoring
Track the availability of certain services including Exchange sign-in, voice mail, email, calendar, Microsoft portal, and billing page. Along with service availability monitoring, the
Office365_Reports_ServicesUserActivity DataSource provides the total number of users that are utilizing the applications. The pairing of this information can be useful when prioritizing issues.
Using user activity historical data collected across multiple services, such as call volume, meeting attendance, message counts, and so on, you can look into repurposing the licenses of the least active users if you are running low on licenses, or you might find that some licensed users are not in the organization anymore.
There is also a device usage breakdown that allows you to track which devices (Windows, Macs, iPhones, Androids) are most popular within your organization. This data can be useful when testing internal applications to prioritize testing on those operating systems that are most heavily used within the organization.