This page looks best with JavaScript enabled

Automated Office 365 Licensing v1.1

 ·  β˜• 3 min read

Update 2019-06-16

I recently learned that Office 365 licensing can be managed via Azure Active Directory’s group based licensing feature and I have since switched to using this and have retired this script. I’ll leave this post and the script itself available here, on the Microsoft TechNet Gallery and GitHub, but I’ll not be developing the script any further. For more information on Azure Active Directory group-based licensing please check out Microsoft’s documentation here and here to start with.

PowerShell script to assign Office 365 license to users in an Active Directory OU structure.

Please consider donating to support my work:

If you have any questions or comments, please leave them below.

-Mike

Features and Requirements

This utility will assign a configurable Office 365 license to Active Directory user accounts within an OU or descending OUs. All options are added via command line switches. Options include:

  • The Office 365 Global Admin user and password to use.
  • The Office 365 license and usage location to assign.
  • Organisation Unit which contains to users to license.
  • The directory to output a log file to.
  • An optional email address to send the log file to.
  • This utility requires the MSOnline and Active Directory PowerShell modules to be installed.
  • The utility requires at least PowerShell 5.0.
  • This utility has been tested running on Windows Server 2016.

Generating A Password File For SMTP Authentication

The password used for SMTP server authentication must be in an encrypted text file. To generate the password file, run the following command in PowerShell, on the computer that is going to run the script and logged in with the user that will be running the script. When you run the command you will be prompted for a username and password. Enter the username and password you want to use to authenticate to your SMTP server.

Please note: This is only required if you need to authenticate to the SMTP server when send the log via e-mail.

1
2
$creds = Get-Credential
$creds.Password | ConvertFrom-SecureString | Set-Content c:\scripts\ps-script-pwd.txt

After running the commands, you will have a text file containing the encrypted password. When configuring the -Pwd switch enter the path and file name of this file.

Configuration

Here’s a list of all the command line switches and example configurations.

1
-User365

The Office 365 Admin user to use for the operation.

1
-Pwd365

The password for the Office 365 Admin user to use for the operation.

1
-Lic

The Office 365 license to apply to your users.

1
-UseLoc

The Office 365 usage location to use.

1
-OU

The top level OU that contains the users to license in Office 365.

1
-L

The path to output the log file to. The file name will be Office-365-Licensing.log

1
-Subject

The email subject that the email should have. Encapsulate with single or double quotes.

1
-SendTo

The e-mail address the log should be sent to.

1
-From

The e-mail address the log should be sent from.

1
-Smtp

The DNS name or IP address of the SMTP server.

1
-User

The user account to connect to the SMTP server.

1
-Pwd

The txt file containing the encrypted password for the user account.

1
-UseSsl

Configures the script to connect to the SMTP server using SSL.

Example

1
2
Office-365-Licensing.ps1 -User365 [email protected] -Pwd365 P@ssw0rd -Lic contosocom:ENTERPRISEPACK -UseLoc GB -OU OU=MyUsers,DC=contoso,DC=com
-L C:\scripts\logs -Subject 'Server: O365 Licensing' -SendTo [email protected] -From [email protected] -Smtp smtp.outlook.com -User user -Pwd c:\scripts\ps-script-pwd.txt -UseSsl

This will login to Office 365 with the specified user and assign licenses to the users in the MyUsers OU, and OUs below that. On completion it will e-mail the log file to the specified address with a custom subject line.

Change Log

2019-09-04 1.1

  • Added custom subject line for e-mail.

2018-04-11 1.0

  • Initial release.
Share on
Support the author with