Microsoft 365 Integration

Microsoft 365 Integration


Integrating Microsoft 365 (formerly Office 365) with AssetExplorer allows technicians to view and manage the subscriptions purchased from Microsoft by the organization.
Since PowerShell is used to execute commands and fetch subscription/license details,  Microsoft 365 integration can be configured only in the Windows server where the application is hosted.  

Role Required: SDAdmin in AssetExplorer; Global Administrator role in Microsoft 365.

Benefits of Microsoft 365 Integration 

  1. Sync subscription details from Microsoft 365 to AssetExplorer periodically.
  2. Map individuals to synced subscriptions through Microsoft 365 associations.
  3. Monitor licenses and services consumed by individuals from a central console.
  4. Track services usage visually using graph views.

Prerequisites    

  1. Ensure that you have an optimal network connection.
  2. In the server where AssetExplorer is hosted, install the following applications and modules.
Application/Module
Instructions for Help
Microsoft Dot NET version 4
(installed by default with OS)
Install Microsoft Dot NET Framework 4 from here.
PowerShell version 3 
(installed by default with OS)
To check the PowerShell version installed,
  1. Go to Start > Run and type PowerShell
  2. Enter the command $PSVersionTable to check for its version number.
  3. If you don't have PowerShell version 3, install it here.
Microsoft Visual C++ Redistributable 2017 (64-bit version)
(installed by default with OS)
To check if Microsoft Visual C++ Redistributable is installed,
  1. Go to Control Panel > Programs > Programs and Features.
  2. Look for Microsoft Visual C++ Redistributable and check its version number.
  3. If the Microsoft Visual C++ Redistributable 2017 is not present, install it here.
Microsoft Online Service Sign-in Assistant
To check if the Microsoft Online Service Sign-in Assistant is installed,
  1. Go to Start > Run and type services.msc.
  2. Check if the Microsoft Online Services Sign-in Assistant service is installed.
  3. If it is not installed, download it here.

Azure Active Directory Module for Windows PowerShell (64-bit)
To check if the Azure Active Directory Module is installed,
  1. Go to Start > Run. 
  2. Open PowerShell and enter Get-Module - ListAvailable -Name MSOnline. This will list the module if it is installed.
  3. If the Azure Active Directory Module is not listed, open PowerShell as administrator.
  4. Install the MSOnline module with the command: Install-Module -Name MSOnline -Force.
 

Understanding Terminologies    

Microsoft 365 Subscription/Package/License: Microsoft applications and other productivity services provided by Microsoft, along with their access constraint.
Microsoft 365 Tenant: An organization, department, or any sub-division using Microsoft 365 services. Tenant is the container for entities in an organization like users, domains, or subscriptions.
Microsoft 365 Account: User login account used to access Microsoft 365 services and applications.
Global Administrator Role: A privileged account managing Microsoft 365 tenants and essential configurations.

Configure Integration    

  1. Go to Admin > Apps & Add-ons > Integrations > Third Party.
  2. On the Microsoft 365 card, click Settings.
  3. Click New to create a tenant. You can create multiple tenants for various Microsoft accounts.
  4. Use the pointers below to configure the fields 
Fields
Explanation
Credential Name *
Provide the organization name
Description
Provide a short description.
Username *
Provide admin credentials to authenticate the tenant.
Password *
Password *
Start Date & Time
Specify the date and time to start syncing the data from Microsoft 365.
Repeat (No.of days)
Mention the frequency (in days) to refresh the data synced
* Mandatory fields

List View Operations    

  1. Edit Tenant Details: Click and select Edit.
  2. Sync Changes: Click and select Sync Now. The latest subscription/license details updated in Microsoft 365 will be updated to AssetExplorer.
  3. Update Latest Tenant Details: Click on the toolbar to update the tenant details.
  4. Delete Tenant: Click and select Delete.
  5. View History: Click View History and track all operations performed on the tenants.


Troubleshoot Scan Failures  

  1. Click View Details displayed in tenants where the scan status is Failed. A slide-out panel lists the various prerequisite software with their status. You can check this list to ensure all prerequisite software is installed successfully.
  2. Ensure the global administrator credentials used during the tenant configuration are accurate. If the global administrator credentials are modified after configuring the tenant, the scan will fail.
  3. Check your network connectivity.
 

 
See also Microsoft 365

    • Related Articles

    • SCCM Integration

      AssetExplorer users can integrate with Microsoft System Centre Configuration Manager (SCCM) to manage desktops and Windows-based applications. By integrating AssetExplorer with SCCM, technicians can retrieve SCCM-scanned asset data without the need ...

    • Integration Key

      Administrators can configure multiple API keys to allow delegated access for different integration requirements. Integration keys can also be reassigned to different technicians if needed. Role Required: SDAdmin Add New Key Go to Admin > Developer ...

    • UEM Integration

      With the last upgrade of AssetExplorer, it looks like we need to install Endpoint Central for scanning assets. Is it included with our Enterprise License or does it need to be purchased as an Add-On? AssetExplorer takes advantage of more secured and ...

    • Overview - Microsoft 365

      This section will be accessible only if Microsoft 365 is integrated. Click here to know more. View and manage data synced from Microsoft 365 under Software > Microsoft 365. The details fetched from Microsoft 365 are displayed in the following tabs: ...

    • Users

      Role Required: SDAdmin, Technicians with View Assets permission. Users synchronized from the Microsoft 365 admin center are displayed in AssetExplorer under Software > Microsoft 365 > Users. The following details of the users are also listed: Name ...