Integrating with Microsoft 365

  • Release version: Yokohama
  • Updated January 30, 2025
  • 6 minutes to read
  • Summarize
    Summarized using AI
    This content was generated using new OpenAI-powered functionality. Results are provided on an as is basis and are not guaranteed to be accurate or complete.

    Summary of Integrating with Microsoft 365

    Integrating the ServiceNow Software Asset Management (SAM) application with Microsoft 365 enables you to track software subscriptions and usage, ensuring license compliance and identifying optimization opportunities. This integration helps minimize security risks by requiring only minimal, necessary Microsoft 365 user or API permissions. It supports managing licenses effectively across multiple tenants and government cloud environments.

    Show full answer Show less

    Setup and Configuration

    • Prerequisites: Install key plugins including Software Asset Management Professional for Microsoft, ITAM Health Check, Software Asset Management - SaaS License Management, and Microsoft Entra ID Spoke (requires Integration Hub subscription).
    • Register Application: Register an application in Microsoft Entra ID for subscription retrieval from the Microsoft 365 admin center.
    • Configure Power BI Usage: Enable service principal authentication for Power BI APIs to optimize licenses such as downgrading or removing low-usage subscriptions.
    • Disable Anonymous User Information: Disable anonymization in Microsoft 365 Admin Center to allow accurate user license tracking.
    • Create Microsoft 365 Integration Profile: Import subscription and usage data for compliance and optimization. Support is available for government plans and products without direct API access by uploading activity reports.
    • Set up Reclamation and User Resolution Rules: Automate license reclamation based on usage and map Microsoft 365 users to ServiceNow users for accurate license management.
    • Run Scheduled Jobs: Automate data pulls or run on demand to keep license and usage data current.
    • Configure Software Models and Entitlements: Automatically generate models based on subscriptions, including suite components and downgrade rights, and add entitlements based on Publisher Part Number to avoid duplicates.
    • Manage Add-on and Step-Up Licenses: Associate add-ons and handle various Microsoft 365 subscription types to maintain accurate license inventory.
    • Set up License Reservations: Create reserve entitlements for Microsoft online services to supplement existing subscriptions.

    Verification and Management

    • Verify Subscription Pulls: Confirm all subscriptions are imported correctly with your Microsoft 365 administrator.
    • Health Checks: Use the ITAM Health Check dashboard to validate Microsoft 365 configurations and troubleshoot issues.
    • Verify Usage Data: Ensure usage data is accurately pulled to identify inactive licenses and optimization candidates.
    • Create Success Goals: Track your Microsoft 365 license management progress and improvements.
    • Add to Published Product List: Add Microsoft 365 products to improve visibility and simplify the Software Asset Workspace.
    • Run Reconciliation: Perform reconciliation specifically for Microsoft to verify license consumption aligns with configurations.
    • Check License Position Reports: Review compliance status across Microsoft 365 and associated products.
    • Act on Unlicensed Subscriptions and Optimization: Identify unlicensed usage and leverage SAM analytics to reclaim or optimize licenses effectively.

    Benefits for ServiceNow Customers

    This integration empowers ServiceNow customers to maintain accurate Microsoft 365 license compliance, reduce unnecessary license costs through optimization and reclamation, and ensure security by enforcing minimal permission access. It streamlines managing multiple tenants and government cloud environments and supports comprehensive reporting and automation, thereby enhancing overall software asset management efficiency.

    Integrating the Software Asset Management application with the Microsoft 365 service enables you to track your software subscriptions and software usage to determine license compliance and act on optimization opportunities.

    Important:
    Minimize security risks and protect information by granting access only to the necessary user or API permissions.
    Table 1. Minimal user permissions
    Process Required user role in the Microsoft 365 application Authentication scopes
    Download subscriptions Application developer
    • User.Read.All
    • Organization.Read.All
    Pull user activity
    • Power platform administrator
    • Application developer
    Reports.Read.All
    Reclaim subscriptions Application developer
    • GroupMember.ReadWrite.All
    • LicenseAssignment.ReadWrite.All

    Setting up Microsoft 365 integration

    Manage Microsoft 365 license compliance and optimization by performing the following steps:
    • Prerequisites

      Before you begin with Microsoft 365 integration, confirm that all prerequisites are met.

      1. Install Software Asset Management Professional for Microsoft

        Install the Software Asset Management Professional for Microsoft (com.snc.samp.microsoft) plugin to access the Microsoft Publisher pack features in the Software Asset Management application.

      2. Install ITAM Health Check application

        Install the ITAM Health Check application to get an overview of your Software Asset Management configurations and receive recommendations for correcting errors.

      3. Install Software Asset Management - SaaS License Management plugin

        Install the Software Asset Management - SaaS License Management plugin (com.sn_sam_saas_int) to create and manage integrations with your SaaS and Single Sign-On (SSO) applications. These integrations enable you to track license usage and reclaim unused licenses effectively.

      4. Install Microsoft Entra ID Spoke

        Install the Microsoft Entra ID spoke (formerly Azure AD spoke) to enable automated integration with the Microsoft 365 Admin Center for license removal and other scenarios. An Integration Hub subscription is required for this spoke. For more information about Integration Hub, see Integration Hub.

      5. Receive latest updates from Software Asset Management Content Service

        Update your instance with new content weekly on a scheduled basis through Software Asset Management Content Service. The Software Asset Management application provides automated content to simplify the normalization of software installations and subscriptions, offering enriched data such as lifecycle information, downgrade rights, and suite definitions. This data is essential for maintaining accurate license compliance and optimization.

      6. Create a success goal

        Create a success goal to track the success of Microsoft 365 configuration setup on the Software Asset Management application.

    • Software Asset Management configurations

      Configure your Software Asset Management (SAM) application, which includes setting up user accounts, managing licenses, and confirming compliance with Microsoft's software usage policies.

      1. Register application on Microsoft Entra ID

        Register an application on Microsoft Entra ID (formerly Azure Active Directory) that enables the retrieval of all subscriptions provisioned in the Microsoft 365 admin center.

      2. Configure Power BI usage to get usage information

        Enable service principal authentication for Power BI read-only APIs to enable your application access to Power BI service content and APIs. This access helps optimize your Microsoft 365 subscriptions, such as downgrading subscriptions from Office 365 E5 to Office 365 E3 or removing Power BI low-usage subscriptions​.

      3. Prevent anonymous user information

        By default, Microsoft hides the user names of subscribers in the Microsoft 365 Admin Center, preventing ServiceNow from accurately tracking Microsoft 365 license usage. To resolve this issue, disable this anonymization feature in the Microsoft 365 Admin Center.

      4. Set up a Microsoft 365 integration profile

        Create a Microsoft 365 integration profile in the Software Asset Management application to import user subscription data, determine license compliance, and identify optimization opportunities. If you manage multiple tenants, create a separate integration profile for each.

      5. Configure the integration profile to get data for government customers

        The ServiceNow AI Platform supports Microsoft 365 Government plans, offering all the features of Microsoft 365 services within a government-exclusive cloud. This setup helps organizations comply with the U.S. security and compliance standards.

      6. Configure the integration profile to get usage for Microsoft 365 Copilot, Visio Online, and Project Online

        Microsoft doesn't provide APIs to get usage directly for Microsoft 365 subscription products, such as Microsoft Visio, Microsoft Project, and Microsoft Copilot. However, you can download activity reports for these products from the Microsoft 365 admin center. Microsoft 365 administrators can download these reports and SAM Admin can attach them unmodified to the integration profile in the Software Asset Management application. The scheduled jobs within ServiceNow will then process these reports and identify reclamation candidates if the usage is low.

      7. Configure reclamation rules

        The Software Asset Management application automatically provides base system reclamation rules when you create an integration profile for Microsoft 365. For more information, see Reclamation rules for Microsoft 365 integration.

      8. Configure user resolution rules

        Resolve or match the Microsoft 365 admin center user to the ServiceNow user (sys_user) to determine the right license compliance and provide correct optimization recommendations.

        Important:
        Remember that sometimes licenses are assigned to non-human users such as email accounts. In these instances, you can skip the user resolution process as it isn’t required.
      9. Run scheduled jobs

        The Microsoft 365 integration profile you created automatically gets subscription and usage information from the Microsoft 365 admin center on a scheduled basis. You can now run these jobs on demand and verify they’re completed successfully.

      10. Set up software models and entitlements
        The Software Asset Management application integrates with the Microsoft 365 admin center to generate software models automatically based on assigned subscriptions. These models include suite components, downgrades, and lifecycle details to confirm compliance and optimize licensing. For these automatically created software models, remember to add your entitlements. If you have previously set up entitlements using Publisher Part Number, the software models from that setup are used in this integration, avoiding the creation of duplicate models.
        Note:
        Verify that no software models are created without Discovery Maps (DMAPs) and no entitlements are created without a Publisher Part Number (PPN) for a smoother implementation.
      11. Set up Add on, From SA, and Step Up entitlements

        Associate an Add-on license with a perpetual office legacy license with active Software Assurance. Microsoft 365 offers various subscription types such as Full USL, Add On USL, From SA USL, Step-up license, and reserved licenses. To learn more about these licenses, see Supported Microsoft 365 license types.

      12. Set up license reservations

        Create reserve entitlements for Microsoft online services to add licenses to your existing Microsoft 365 subscriptions.

    • Software Asset Management configurations verification

      Review and validate the Software Asset Management configurations to track and manage Microsoft 365 licenses and usage accurately.

      1. Verify the complete pull of all subscriptions

        Verify with the Microsoft 365 administrator that all subscription records have been successfully pulled.

      2. Run health check

        Run a health check on the Health check dashboard by selecting Microsoft 365, SaaS, and General to verify the Microsoft 365 configurations and review the findings for each suite.

      3. Verify the pull of all required software usage

        Verify if the Software Asset Management application has pulled the usage details for your Microsoft 365 subscribed users, which is required to identify the last activity and determine optimization opportunities.

      4. Create a success goal

        Create a success goal to manage your Microsoft 365 licenses.

      5. Add Microsoft 365 and associated products to the published product list

        Add Microsoft 365 and associated products to the published product list to improve readability and declutter the Software Asset Workspace. Scale your SAM efforts strategically by evaluating progress based on resource needs, work quality, and configuration management.

      6. Run reconciliation

        Run reconciliation on the Software asset overview page to verify that the licenses are consumed according to the Software Asset Management configurations. You must run reconciliation only for Microsoft as the publisher to verify Microsoft 365 license consumption.

      7. Check license position report

        Check your overall compliance positions for Microsoft 365 and associated products in the License Position Report.

      8. Act on unlicensed subscriptions

        Identify and address the unlicensed Microsoft 365 subscriptions.

      9. Act on optimization recommendations

        Software Asset Management supports various optimization use cases, which you can view on the Software asset analytics page.