SaaS Security
Onboard Office 365 Productivity Apps to SSPM
Table of Contents
Expand All
|
Collapse All
SaaS Security Docs
Onboard Office 365 Productivity Apps to SSPM
Connect Office 365 productivity app instances to SSPM to detect posture
risks.
Where Can I Use This? | What Do I Need? |
---|---|
|
Or any of the following licenses that include the Data Security license:
|
To detect posture risks in your Office 365 productivity apps (Microsoft Word,
Microsoft PowerPoint, and Microsoft Excel), SSPM connects to the productivity apps
by using information that you provide. Once SSPM connects, it scans the Office 365
productivity apps for misconfigured settings and will continue to run scans at
regular intervals.
There are two ways to onboard the Office 365 productivity apps, depending on how you
want SSPM to scan your Office 365 productivity apps. Review the following
information about these two methods of scanning to decide which one you want SSPM to
use. Before you onboard the Office 365 productivity apps to SSPM, there are certain
actions you must take and certain information you must gather. These actions will
differ depending on the method you choose.
- You can onboard a Microsoft OneDrive App for scans that use the Microsoft Graph
API. To enable SSPM to access the Microsoft Graph API, you create a client
application in Azure Active Directory (AD) with the necessary permissions, and
allow access to the application to users in your organization. During
onboarding, you will supply SSPM with Microsoft credentials for a user in the
organization with the necessary permissions. You will also supply the Client ID
of the Azure AD application. SSPM uses this information in a PowerShell call to
connect to the Microsoft Graph API. The account that you use for onboarding
cannot require MFA.This approach uses a published API.
- You can onboard a Microsoft OneDrive App for scans that use data extraction
(also known as web scraping). To perform this data extraction, SSPM logs in to
Microsoft by using an administrator account. You can have SSPM access the
account directly or through the Okta or Microsoft Azure identity providers. If
SSPM will be logging in to the administrator account directly, then the account
cannot be configured for MFA. If SSPM will be accessing the account through Okta
or Microsoft Azure, then MFA is required. During onboarding, you will provide
SSPM with the administrator credentials. If SSPM will connect to the account
through an identity provider, you will also specify the information that SSPM
needs for MFA.This data-extraction approach scans more settings compared to the Microsoft Graph API approach.
Onboard Office 365 Productivity Apps for Scans That Use the Microsoft Graph API
Connect Office 365 productivity app instances to SSPM to detect posture
risks.
The Office 365 productivity apps are Microsoft Word, Microsoft PowerPoint, and
Microsoft Excel. High-level configuration scanning across Office 365 products is
available by onboarding the Office 365 app. Adding the Office 365
productivity apps gives you greater visibility into Microsoft Word, Microsoft
PowerPoint, and Microsoft Excel settings.
For SSPM to detect posture risks in Office 365 productivity apps with more detail
than the Office 365 app scan, you must onboard your Office 365 productivity apps to
SSPM. Through the onboarding process, SSPM connects to a Microsoft API and, through
the API, scans the Office 365 productivity apps at regular intervals for
misconfigured settings. If there are misconfigured settings, SSPM suggests a
remediation action based on best practices.
There are two ways in which SSPM can scan your Office 365 productivity apps. The
following instructions describe how to enable SSPM to use the Microsoft Graph API to
perform its configuration scans. You can follow alternative instructions that enable
SSPM to use data extraction techniques to perform its
configuration scans. To onboard your Office 365 productivity app
instances, you complete the following actions:
Collect Information for Connecting to Your Office 365 Productivity App Instances
To access your Office 365 productivity app instances, SSPM requires the following
information, which you will specify during the onboarding process.
Item | Description |
---|---|
Username |
The login email address for a Microsoft account. The account
must not require multi-factor authentication (MFA).
Required Permissions: The user must be assigned to
the Global Administrator role.
|
Password |
The password for the Microsoft account.
|
Client ID | SSPM will access a Microsoft API through an Azure AD application that you create. During the onboarding process, SSPM prompts you for a Client ID that uniquely identifies the application. |
As you complete the following steps, make note of the values of the items
described in the preceding table. You will need to enter these values during
onboarding to access your Office 365 productivity app instances from SSPM.
- Identify the Microsoft account that SSPM will use to access your Office 365 instance.Account requirements:
- The account must have Global Administrator permissions.
- The account must not require MFA.
After SSPM establishes the connection, it will perform an initial scan of your Office 365 instance, and will then run scans at regular intervals of approximately 30 minutes. For SSPM to run these scans, the administrator account that you use to establish the initial connection must remain available. For this reason, we recommend that you use a dedicated service account to grant SSPM access. If you delete the service account, the scans will fail and you will need to onboard the Office 365 productivity apps again.Register an Azure AD Client ApplicationDuring onboarding, SSPM will access a Microsoft API through an Azure AD client application that you create. Follow the instructions to register a an Azure AD client application, and note the Client ID that Azure AD generates for the client app.If you have already onboarded another Microsoft application that requires an Azure AD client application, you can use that same Azure AD client app to onboard the Office 365 productivity apps. If necessary, ask the administrator who registered the Azure AD client app for its Client ID.Do not continue to the next step unless you have obtained the Client ID. You will provide this information to SSPM during the onboarding process.Enable Required Enterprise Applications
To complete its scans, SSPM also requires the Microsoft Graph Command Line Tools enterprise application. - As a Global Administrator, log in to the the Azure portal and navigate to the Enterprise applications page. To quickly navigate to this page, enter Enterprise applications in the search field at the top of the page.Complete the following steps to enable Microsoft Graph Command Line Tools for user sign in.
- On the Enterprise applications page, use the search box to quickly locate the Microsoft Graph Command Line Tools application.If the Enterprise applications page does not list this application, you will need to install it by using PowerShell. PowerShell is included with all supported versions of Microsoft Windows, but if you are using the macOS operating system, you will need to install PowerShell on macOS.
- Open PowerShell. If you are using Microsoft Windows, use the search bar to locate the PowerShell application and Run as Administrator. If you are using macOS, open the command terminal and run the pwsh command.
- Enter the following command in PowerShell to install the
Microsoft.Graph.Authentication
module.Install-Module Microsoft.Graph.Authentication -Scope CurrentUser -RequiredVersion 2.18.0 -Force -Verbose
- On Windows only: Enter the following command to set the PowerShell execution policies for subsequent commands. This command prevents PowerShell from blocking commands and scripts. This block prevention will be in effect only for the current PowerShell session. If you are using the macOS operating system, you do not need to enter this command.
Set-ExecutionPolicy -ExecutionPolicy Bypass -Scope Process -Force- Enter the following command in PowerShell to access Microsoft Graph.
Connect-MgGraph -Scope "Sites.Read.All","Domain.Read.All","openid","profile","ReportSettings.Read.All","OrgSettings-AppsAndServices.Read.All","OrgSettings-DynamicsVoice.Read.All","OrgSettings-Forms.Read.All","Application.Read.All";After you issue the preceding commands, the Enterprise applications page will list the Microsoft Graph Command Line Tools.Click the application name and, from the left navigation pane, navigate to its Properties.Set the Enabled for users to sign-in property and the Assignment required property to Yes.Save your changes.Connect SSPM to Your Office 365 Productivity App Instances
By adding the Office 365 productivity apps in SSPM, you enable SSPM to connect to your Microsoft Word, Microsoft PowerPoint, and Microsoft Excel instances.- From the Add Application page (Posture SecurityApplicationsAdd Application ), click the Microsoft Office 365 - Productivity Apps Powershell tile.Under posture security instances, Add Instance or, if there is already an instance configured, Add New instance.Log in with Credentials.When prompted, provide SSPM with the Microsoft user credentials and the Client ID of the Azure AD application.Connect.
Onboard Office 365 Productivity Apps for Scans That Use Data Extraction
Connect Office 365 productivity app instances to SSPM to detect posture risks.The Office 365 productivity apps are Microsoft Word, Microsoft PowerPoint, and Microsoft Excel. High-level configuration scanning across Office 365 products is available by onboarding the Office 365 app. Adding the Office 365 productivity apps gives you greater visibility into Microsoft Word, Microsoft PowerPoint, and Microsoft Excel settings.For SSPM to detect posture risks in Office 365 productivity apps with more detail than the Office 365 app scan, you must onboard your Office 365 productivity apps to SSPM. Through the onboarding process, SSPM logs in to a Microsoft administrator account. SSPM uses this account to scan your Office 365 productivity apps for misconfigured settings. If there are misconfigured settings, SSPM suggests a remediation action based on best practices.There are two ways in which SSPM can scan your Microsoft OneDrive instance. The following instructions describe how to enable SSPM to use data extraction techniques (also known as web scraping) to perform its configuration scans. You can follow alternative instructions that enable SSPM to use the Microsoft Graph API to perform its configuration scans.During the onboarding process, you will supply Microsoft account credentials to SSPM. SSPM can access the account directly or through the Okta or Microsoft Azure identity providers. Having SSPM access the account through one of these identity providers requires MFA, which adds an extra layer of security.To onboard your Office 365 productivity app instances, you complete the following actions:Collect Information for Connecting to Your Office 365 Productivity App Instances
To access your Office 365 productivity app instances, SSPM requires the following information, which you will specify during the onboarding process.Item Description User The username or email address of the administrator account. The format that you use can depend on whether SSPM will be logging in directly to your account or through an identity provider. Required Permissions: The user must be assigned to the Microsoft Global Admin role.Password The password for the administrator account. If you are using Okta as your identity provider, you must provide SSPM with the following additional information:Item Description Okta subdomain The Okta subdomain for your organization. The subdomain was included in the login URL that Okta assigned to your organization. Okta 2FA secret A key that is used to generate one-time passcodes for MFA. If you are using Azure Active Directory (AD) as your identity provider, you must provide SSPM with the following additional information:Item Description Azure 2FA secret A key that is used to generate one-time passcodes for MFA. As you complete the following steps, make note of the values of the items described in the preceding tables. You will need to enter these values during onboarding to access your Office 365 productivity app instances from SSPM.- Identify the Microsoft administrator account that SSPM will use to access your Microsoft productivity apps. The administrator must be assigned to the Microsoft Global Admin role.Determine whether you want SSPM to log in to the administrator account directly, or through an identity provider.Using an identity provider adds an extra layer of security by requiring MFA using one-time passcodes. You can use Okta or Microsoft Azure as the identity provider for accessing the administrator account. However, if you use an identity provider, SSPM requires more information for MFA.
- (For Okta log in) To access the administrator account through Okta:
- (For Microsoft Azure log in) To access the administrator account through Microsoft Azure:
Connect SSPM to Your Office 365 Productivity App Instances
By adding the Office 365 productivity apps in SSPM, you enable SSPM to connect to your Microsoft Word, Microsoft PowerPoint, and Microsoft Excel instances.- From the Add Application page (Posture SecurityApplicationsAdd Application ), click the Office 365 - Productivity Apps tile.Under posture security instances, Add Instance or, if there is already an instance configured, Add New instance.Specify how you want SSPM to connect to your Office 365 productivity apps. SSPM can Log in with Credentials, Log in with Okta, or Log in with Azure.When prompted, provide SSPM with the administrator credentials. If SSPM is connecting to the account through an identity provider, specify the information that SSPM needs for MFA.Connect.
- On Windows only: Enter the following command to set the PowerShell execution policies for subsequent commands. This command prevents PowerShell from blocking commands and scripts. This block prevention will be in effect only for the current PowerShell session. If you are using the macOS operating system, you do not need to enter this command.