App-only authentication for unattended scripts in Exchange Online PowerShell and Security & Compliance PowerShell
Article
12/12/2023
Auditing and reporting scenarios in Microsoft 365 often involve unattended scripts in Exchange Online PowerShell and Security & Compliance PowerShell. In the past, unattended sign in required you to store the username and password in a local file or in a secret vault that's accessed at run-time. But, as we all know, storing user credentials locally isn't a good security practice.
Certificate based authentication (CBA) or app-only authentication as described in this article supports unattended script and automation scenarios by using Microsoft Entra apps and self-signed certificates.
If the procedures in this article don't work for you, verify that you don't have Beta versions of the PackageManagement or PowerShellGet modules installed by running the following command: Get-InstalledModule PackageManagement -AllVersions; Get-InstalledModule PowerShellGet -AllVersions.
In Exchange Online PowerShell, you can't use the procedures in this article with the following Microsoft 365 Group cmdlets:
Delegated scenarios are supported in Exchange Online. The recommended method for connecting with delegation is using GDAP and App Consent. For more information, see Use the Exchange Online PowerShell v3 Module with GDAP and App Consent. You can also use multi-tenant applications when CSP relationships are not created with the customer. The required steps for using multi-tenant applications are called out within the regular instructions in this article.
Use the SkipLoadingFormatData switch on the Connect-ExchangeOnline cmdlet if you get the following error when using the Windows PowerShell SDK to connect: The term 'Update-ModuleManifest' is not recognized as a name of a cmdlet, function, script file, or executable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.
How does it work?
The Exchange Online PowerShell module uses the Active Directory Authentication Library to fetch an app-only token using the application ID, tenant ID (organization), and certificate thumbprint. The application object provisioned inside Microsoft Entra ID has a Directory Role assigned to it, which is returned in the access token. The session's role based access control (RBAC) is configured using the directory role information that's available in the token.
Connection examples
The following examples show how to use the Exchange Online PowerShell module with app-only authentication:
Important
In the following connection commands, use the primary .onmicrosoft.com domain for your organization as the value of the Organization parameter.
Microsoft 365 GCC High or Microsoft 365 DoD environments require the following additional parameters and values:
Connect-ExchangeOnline in GCC High: -ExchangeEnvironmentName O365USGovGCCHigh.
Connect-IPPSSession in GCC High: -ConnectionUri https://ps.compliance.protection.office365.us/powershell-liveid/ -AzureADAuthorizationEndpointUri https://login.microsoftonline.us/common.
Connect-ExchangeOnline in DoD: -ExchangeEnvironmentName O365USGovDoD.
Connect-IPPSSession in DoD: -ConnectionUri https://l5.ps.compliance.protection.office365.us/powershell-liveid/ -AzureADAuthorizationEndpointUri https://login.microsoftonline.us/common.
If a Connect-IPPSSession command presents a login prompt, run the command: $Global:IsWindows = $true before the Connect-IPPSSession command.
Connect using a certificate thumbprint:
Note
The CertificateThumbprint parameter is supported only in Microsoft Windows.
The certificate needs to be installed on the computer where you're running the command. The certificate should be installed in the user certificate store.
The certificate doesn't need to be installed on the computer where you're running the command. You can store the certificate object remotely. The certificate is fetched when the script is run.
Using a ConvertTo-SecureString command to store the password of the certificate locally defeats the purpose of a secure connection method for automation scenarios. Using a Get-Credential command to prompt you for the password of the certificate securely isn't ideal for automation scenarios. In other words, there's really no automated and secure way to connect using a local certificate.
An initial onboarding is required for authentication using application objects. Application and service principal are used interchangeably, but an application is like a class object while a service principal is like an instance of the class. For more information, see Application and service principal objects in Microsoft Entra ID.
For a detailed visual flow about creating applications in Microsoft Entra ID, see https://aka.ms/azuread-app.
An application object has the Delegated API permission Microsoft Graph > User.Read by default. For the application object to access resources in Exchange, it needs the Application API permission Office 365 Exchange Online > Exchange.ManageAsApp.
For app-only authentication in Microsoft Entra ID, you typically use a certificate to request access. Anyone who has the certificate and its private key can use the app with the permissions granted to the app.
Create and configure a self-signed X.509 certificate, which is used to authenticate your Application against Microsoft Entra ID, while requesting the app-only access token.
This procedure is similar to generating a password for user accounts. The certificate can be self-signed as well. See this section later in this article for instructions to generate certificates in PowerShell.
Note
Cryptography: Next Generation (CNG) certificates aren't supported for app-only authentication with Exchange. CNG certificates are created by default in modern versions of Windows. You must use a certificate from a CSP key provider. This section section covers two supported methods to create a CSP certificate.
The application needs to have the appropriate RBAC roles assigned. Because the apps are provisioned in Microsoft Entra ID, you can use any of the supported built-in roles.
Step 1: Register the application in Microsoft Entra ID
Note
If you encounter problems, check the required permissions to verify that your account can create the identity.
On the App registrations page, select New registration.
On the Register an application page that opens, configure the following settings:
Name: Enter something descriptive. For example, ExO PowerShell CBA.
Supported account types: Verify that Accounts in this organizational directory only (<YourOrganizationName> only - Single tenant) is selected.
Note
To make the application multi-tenant for Exchange Online delegated scenarios, select the value Accounts in any organizational directory (Any Microsoft Entra directory - Multitenant).
Redirect URI (optional): This setting is optional. If you need to use it, configure the following settings:
Platform: Select Web.
URI: Enter the URI where the access token is sent.
Note
You can't create credentials for native applications, because you can't use native applications for automated applications.
When you're finished on the App registrations page, select Register.
You're taken to the Overview page of the app you just registered. Leave this page open. You'll use it in the next step.
Step 2: Assign API permissions to the application
Choose one of the following methods in this section to assign API permissions to the app:
Select and assign the API permissions from the portal.
Modify the app manifest to assign API permissions. (Microsoft 365 GCC High and DoD organizations should use this method)
Select and assign the API permissions from the portal
On the app Overview page, select API permissions from the Manage section.
On the app API Permissions page, select Add a permission.
In the Request API permissions flyout that opens, select the APIs my organization uses tab, start typing Office 365 Exchange Online in the Search box, and then select it from the results.
On the What type of permissions does your application require? flyout that appears, select Application permissions.
In the permissions list that appears, expand Exchange, select Exchange.ManageAsApp, and then select Add permissions.
Back on the app API permissions page, verify Office 365 Exchange Online > Exchange.ManageAsApp is listed and contains the following values:
Type: Application.
Admin consent required: Yes.
Status: The current incorrect value is Not granted for <Organization>.
Change this value by selecting Grant admin consent for <Organization>, reading the confirmation dialog that opens, and then selecting Yes.
The Status value is now Granted for <Organization>.
For the default Microsoft Graph > User.Read entry, select ... > Revoke admin consent, and then select Yes in the confirmation dialog that opens to return Status back to the default blank value.
Close the current API permissions page (not the browser tab) to return to the App registrations page. You use the App registrations page in an upcoming step.
Modify the app manifest to assign API permissions
Note
The procedures in this section append the existing default permissions on the app (delegated User.Read permissions in Microsoft Graph) with the required application Exchange.ManageAsApp permissions in Office 365 Exchange Online.
On the app Overview page, select Manifest from the Manage section.
On the app Manifest page, find the requiredResourceAccess entry (on or about line 42), and make the entry look like the following code snippet:
Microsoft 365 GCC High or DoD environments have access to Security & Compliance PowerShell only. Use the following values for the requiredResourceAccess entry:
When you're finished on the Manifest page, select Save.
Still on the Manifest page, select API permissions from the Manage section.
On the API permissions page, verify Office 365 Exchange Online > Exchange.ManageAsApp is listed and contains the following values:
Type: Application.
Admin consent required: Yes.
Status: The current incorrect value is Not granted for <Organization> for the Office 365 Exchange Online > Exchange.ManageAsApp entry.
Change the Status value by selecting Grant admin consent for <Organization>, reading the confirmation dialog that opens, and then selecting Yes.
The Status value is now Granted for <Organization>.
For the default Microsoft Graph > User.Read entry, select ... > Revoke admin consent, and then select Yes in the confirmation dialog that opens to return Status back to the default blank value.
Close the current API permissions page (not the browser tab) to return to the App registrations page. You use the App registrations page in an upcoming step.
Step 3: Generate a self-signed certificate
Create a self-signed x.509 certificate using one of the following methods:
(Recommended) Use the New-SelfSignedCertificate, Export-Certificate and Export-PfxCertificate cmdlets in an elevated (run as administrator) Windows PowerShell session to request a self-signed certificate and export it to .cer and .pfx (SHA1 by default). For example:
On the application page that opens, select Certificates & secrets from the Manage section.
On the Certificates & secrets page, select Upload certificate.
In the dialog that opens, browse to the self-signed certificate (.cer file) that you created in Step 3.
When you're finished, select Add.
The certificate is now shown in the Certificates section.
Close the current Certificates & secrets page, and then the App registrations page to return to the main https://portal.azure.com/ page. You'll use it in the next step.
Step 4b: Exchange Online delegated scenarios only: Grant admin consent for the multi-tenant app
If you made the application multi-tenant for Exchange Online delegated scenarios in Step 1, you need to grant admin consent to the Exchange.ManageAsApp permission so the application can run cmdlets in Exchange Online in each tenant organization. To do this, generate an admin consent URL for each customer tenant. Before anyone uses the multi-tenant application to connect to Exchange Online in the tenant organization, an admin in the customer tenant should open the following URL:
Step 5: Assign Microsoft Entra roles to the application
You have two options:
Assign Microsoft Entra roles to the application
Assign custom role groups to the application using service principals: This method is supported only when you connect to Exchange Online PowerShell or Security & Compliance PowerShell in REST API mode. Security & Compliance PowerShell supports REST API mode in v3.2.0 or later.
Note
You can also combine both methods to assign permissions. For example, you can use Microsoft Entra roles for the "Exchange Recipient Administrator" role and also assign your custom RBAC role to extend the permissions.
For multi-tenant applications in Exchange Online delegated scenarios, you need to assign permissions in each customer tenant.
Assign Microsoft Entra roles to the application
The supported Microsoft Entra roles are described in the following table:
¹ The Global Administrator and Exchange Administrator roles provide the required permissions for any task in Exchange Online PowerShell. For example:
Recipient management.
Security and protection features. For example, anti-spam, anti-malware, anti-phishing, and the associated reports.
The Security Administrator role does not have the necessary permissions for those same tasks.
² Microsoft recommends that you use roles with the fewest permissions. Using lower permissioned accounts helps improve security for your organization. Global Administrator is a highly privileged role that should be limited to emergency scenarios when you can't use an existing role.
The following steps are slightly different for Exchange Online PowerShell vs. Security & Compliance PowerShell. The steps for both environments are shown. To configure roles for both environments, repeat the steps in this section.
In Microsoft Entra admin center at https://portal.azure.com/, start typing roles and administrators in the Search box at the top of the page, and then select Microsoft Entra roles and administrators from the results in the Services section.
On the Roles and administrators page that opens, find and select one of the supported roles by clicking on the name of the role (not the check box) in the results.
Exchange Online PowerShell: For example, find and select the Exchange administrator role.
Security & Compliance PowerShell: For example, find and select the Compliance Administrator role.
On the Assignments page that opens, select Add assignments.
Exchange Online PowerShell:
Security & Compliance PowerShell:
In the Add assignments flyout that opens, find and select the app that you created in Step 1.
When you're finished in the Add assignments flyout, select Add.
Back on the Assignments page, verify that the role has been assigned to the app.
Exchange Online PowerShell:
Security & Compliance PowerShell:
Assign custom role groups to the application using service principals
Note
You need to connect to Exchange Online PowerShell or Security & Compliance PowerShell before completing steps to create a new service principal. Creating a new service principal without connecting to PowerShell won't work (your Azure App ID and Object ID are needed to create the new service principal).
This method is supported only when you connect to Exchange Online PowerShell or Security & Compliance PowerShell in REST API mode. Security & Compliance PowerShell supports REST API mode in v3.2.0 or later.
To assign custom role groups to the application using service principals, do the following steps:
In Microsoft Graph PowerShell, run the following commands to store the details of the Microsoft Entra application that you registered in Step 1 in a variable:
In Exchange Online PowerShell or Security & Compliance PowerShell, run the following command to add the service principal as a member of the custom role group:
This module focuses on effectively managing identities and enhancing security in Microsoft Enterprise Identity, ensuring that users, groups, and external identities are protected against security threats and unauthorized access.