PowerShell: Assign Office 365 license en-mass

January 18, 2014May 22, 2014 Mike Hudson How-To's, Powershell, Programming How-To's

Last week I was tasked with the challenge of assigning a sharepoint only license from our Office 365 license pool to a large list of staff.

The following PowerShell script is what I came up with – I added the ability to prompt before assignment, just in case a UPN had slipped through my pre scripting filtering.

This script relies on a CSV file of user principal names, one column – titled UserPrincipalName

<!DOCTYPE html>
<html>
  <head>
    <meta http-equiv="Content-type" content="text/html; charset=utf-8">
    <title>Server Error &middot; Gist</title>
    <style type="text/css" media="screen">
      body {
        background: #f1f1f1;
        font-family: "HelveticaNeue-Light", Helvetica, Arial, sans-serif;
        text-rendering: optimizeLegibility;
        -webkit-font-smoothing: antialiased; }

      .container { margin: 100px auto; width: 600px; text-align: center; }

      a { color: #4183c4; text-decoration: none; }
      a:visited { color: #4183c4 }
      a:hover { text-decoration: none; }

      h1 { letter-spacing: -1px; line-height: 60px; font-size: 60px; font-weight: 100; margin: 0px; text-shadow: 0 1px 0 #fff; }
      p { color: rgba(0, 0, 0, 0.5); margin: 20px 0 40px; }

      ul { border-top: 1px solid #ccc; list-style: none; margin: 20px 0; padding: 20px 0; }
      li { display: table-cell; font-weight: bold; width: 1%; }
    </style>
  </head>
  <body>
    <div class="container">
      <h1>OH NOES, 404.</h1>
      <p>We seem to have missed the <em>gist</em> of that <em>gist</em> you were looking for.</p>
      <ul id="error-suggestions">
          <li><a href="https://github.com/contact">Contact Support</a></li>
          <li><a href="https://status.github.com">Status Site</a></li>
          <li><a href="https://twitter.com/github">@github</a></li>
      </ul>
      <p><img src="https://github.s3.amazonaws.com/media/maint-logo.png" alt="GitHub"></p>
    </div>
  </body>
</html>

<!DOCTYPE html>
<html>
  <head>
    <meta http-equiv="Content-type" content="text/html; charset=utf-8">
    <title>Server Error &middot; Gist</title>
    <style type="text/css" media="screen">
      body {
        background: #f1f1f1;
        font-family: "HelveticaNeue-Light", Helvetica, Arial, sans-serif;
        text-rendering: optimizeLegibility;
        -webkit-font-smoothing: antialiased; }

      .container { margin: 100px auto; width: 600px; text-align: center; }

      a { color: #4183c4; text-decoration: none; }
      a:visited { color: #4183c4 }
      a:hover { text-decoration: none; }

      h1 { letter-spacing: -1px; line-height: 60px; font-size: 60px; font-weight: 100; margin: 0px; text-shadow: 0 1px 0 #fff; }
      p { color: rgba(0, 0, 0, 0.5); margin: 20px 0 40px; }

      ul { border-top: 1px solid #ccc; list-style: none; margin: 20px 0; padding: 20px 0; }
      li { display: table-cell; font-weight: bold; width: 1%; }
    </style>
  </head>
  <body>
    <div class="container">
      <h1>OH NOES, 404.</h1>
      <p>We seem to have missed the <em>gist</em> of that <em>gist</em> you were looking for.</p>
      <ul id="error-suggestions">
          <li><a href="https://github.com/contact">Contact Support</a></li>
          <li><a href="https://status.github.com">Status Site</a></li>
          <li><a href="https://twitter.com/github">@github</a></li>
      </ul>
      <p><img src="https://github.s3.amazonaws.com/media/maint-logo.png" alt="GitHub"></p>
    </div>
  </body>
</html>

Currently, the script assigns a full set of 365 licenses, then removes all but the one the user requires – future plans are to just assign whats required.

Related

Mike Hudson

Mike Hudson is a Lead Cyber Security Analyst living and working in Kingston Upon Hull. With extensive experience in Microsoft and Apple technologies, ranging from desktop OS’s to Server OS’s and hardware. By day working as part of an infrastructure team, and by night ridding the world of IT issues through blog posts..

%d bloggers like this: