Skip to main content

Office 365 License Count

Overview​

Retrieves Microsoft 365 license usage and availability through the Microsoft Graph API and writes the results as an HTML table into a WYSIWYG custom field on the device where the script runs.

The script employs the Microsoft.Graph PowerShell module to establish a connection with the Office 365 portal and generate the report. As there is no provision for a silent or remote connection to the Office 365 portal using Office 365 credentials, the script utilizes the Using PSCredential object method for this purpose.

To effectively use this script, it is imperative to have the Office 365 ClientID, TenantID, and Client Secret. This information can be stored in the client-level custom fields as detailed in the article below.

Please note that this script is designed for professional use and requires a certain level of technical expertise for successful execution. It is recommended to thoroughly understand the script and its requirements before running it.

Note of Caution: Its functionality is not guaranteed on any computer running a version of PowerShell older than 5. Please ensure your systems are updated to at least PowerShell version 5 for optimal performance.

How to create Office 365 ClientID, TenantID, and Client Secret?​

Step 1: Register an Application in Azure AD​

  • Go to the Azure Portal → Azure Active Directory → App registrations → New registration.
  • Name the app (e.g., "LicenseReportApp").
  • Select account type (usually "Accounts in this organizational directory only").
  • Click Register.

Step 2: Generate Client Secret​

  • Go to Certificates & secrets → New client secret.
  • Add a description and choose expiry → Click Add.
  • Copy the secret value (you won't see it again).

Step 3: Assign API Permissions​

  • Go to API permissions → Add a permission → Microsoft Graph → Application permissions.
  • Search for Organization.Read.All → Select it → Add permissions.
  • Click Grant admin consent (requires Global Admin).

Step 4: Note Credentials​

  • Application (Client) ID: Found on the app's overview page.
  • Tenant ID: Found under Azure AD overview.
  • Client Secret: From Step 2.

Sample Run​

Image1

Dependencies​

Custom Fields​

Field LabelAccepted ValuesScopeRequiredDescription
cPVAL M365 Client IDSecure Text (Azure App Registration Client/Application ID)OrganizationTrueThe Client ID for the Azure AD App Registration used for MS Graph authentication.
cPVAL M365 Tenant IDSecure Text (Azure AD Tenant ID)OrganizationTrueThe Tenant ID of the Microsoft 365 environment.
cPVAL M365 Client SecretSecure Text (Azure App Registration Client Secret)OrganizationTrueThe Client Secret generated for the Azure AD App Registration.
cPVAL Office 365 License CountWYSIWYG (HTML String)DeviceFalseStores the HTML-formatted inventory of M365 licenses and their current usage counts.

Automation Setup/Import​

Automation Configuration

Output​

  • Activity Details
  • Custom Field

Changelog​

2026-02-26​

  • Initial version of the document