O365_LicenseAssignment.ps1
|
<#PSScriptInfo .VERSION 1.0 .GUID 9fb9489c-2584-4b71-8122-abd3d9d9d95b .AUTHOR andrewjosephanderson@live.com - @drewjanderson on Twitter .COMPANYNAME AndersonTech .COPYRIGHT .TAGS .LICENSEURI .PROJECTURI .ICONURI .EXTERNALMODULEDEPENDENCIES .REQUIREDSCRIPTS .EXTERNALSCRIPTDEPENDENCIES .RELEASENOTES #> <# .DESCRIPTION This script will export a list of all Microsoft Online/Office365 users along with their assigned license SKUs. #> Param() ################################################################################################### # Prerequisites: # # -PowerShell 2.0 # # -Azure AD PowerShell Module (follow steps below to install) # # 1. Microsoft Online Services Sign-In Assistant for IT Professionals RTW # # https://www.microsoft.com/en-us/download/details.aspx?id=41950 # # 2. Azure Active Directory Module for Windows PowerShell (64-bit version) # # http://go.microsoft.com/fwlink/p/?linkid=236297 # ################################################################################################### # Import the Azure Active Directory module into the current PS session Import-Module Azure # Opens a Save File dialog box filtered to CSV file types Function Get-SaveFilePath($initialDirectory){ [System.Reflection.Assembly]::LoadWithPartialName("System.windows.forms") | Out-Null $SaveFileDialog = New-Object System.Windows.Forms.SaveFileDialog $SaveFileDialog.initialDirectory = $initialDirectory $SaveFileDialog.filter = "CSV Files (*.csv) | *.csv" $SaveFileDialog.ShowDialog() | Out-Null Return $SaveFileDialog.FileName } # Prompts user to enter Microsoft Online credentials $Msolcredential = Get-Credential -Message "Enter your Microsoft Online credentials with username in <username>@<domain> format." # Sets the Save File path for the CSV export file using C:\ as the initial directory $filepath = Get-SaveFilePath -initialDirectory C:\ # Connects to Microsoft Online using the credentials that were entered at the prompt Connect-MsolService -Credential $Msolcredential # Gathers all Microsoft Online users that have any licenses assigned and pulls their name and the license SKU(s) they have assigned to their account, renames the column headings, and exports it to CSV using the selected location Get-MsolUser -All | Where-Object {$_.isLicensed -eq $true} | Select-Object @{expression={$_.DisplayName}; label='Name'},@{expression={$_.Licenses.AccountSkuId}; label='License(s) Assigned'} | Export-Csv -Path $filepath -NoTypeInformation # Remove the Azure Active Directory module from the session Remove-Module -Name Azure -Confirm:$false |