Public/Migration/MailboxMove/License/Get-MailboxMoveLicenseUserSku.ps1
|
function Get-MailboxMoveLicenseUserSku { <# .SYNOPSIS Reports on a user or users Office 365 enabled Sku Either All, All Licensed, SearchString or Sharepoint can be used for input .DESCRIPTION Reports on a user or users Office 365 enabled Sku Either All, All Licensed, SearchString or Sharepoint can be used for input .PARAMETER SharePointURL Sharepoint url ex. https://fabrikam.sharepoint.com/sites/Contoso .PARAMETER ExcelFile Excel file found in "Shared Documents" of SharePoint site specified in SharePointURL ex. "Batchex.xlsx" .PARAMETER All All AzureAd Users and their licence(s) or lackthereof .PARAMETER AllLicensedOnly All licensed AzureAD Users .PARAMETER SearchString Search by keyword for certain AzureAD Users .PARAMETER OnePerLine Output one license per line. For example: User1 License1 User1 License1 User2 License2 User3 License1 .EXAMPLE An example .NOTES General notes #> [CmdletBinding()] param ( [Parameter(Mandatory, ParameterSetName = 'SharePoint')] [ValidateNotNullOrEmpty()] [string] $SharePointURL, [Parameter(Mandatory, ParameterSetName = 'SharePoint')] [ValidateNotNullOrEmpty()] [string] $ExcelFile, [Parameter(Mandatory, ParameterSetName = 'All')] [ValidateNotNullOrEmpty()] [switch] $All, [Parameter(Mandatory, ParameterSetName = 'AllLicensedOnly')] [ValidateNotNullOrEmpty()] [switch] $AllLicensedOnly, [Parameter(ParameterSetName = 'SearchString')] [string] $SearchString, [Parameter(ParameterSetName = 'SharePoint')] [Parameter(ParameterSetName = 'SearchString')] [Parameter(ParameterSetName = 'All')] [Parameter(ParameterSetName = 'AllLicensedOnly')] [switch] $OnePerLine, [Parameter(ParameterSetName = 'SharePoint')] [Parameter(ParameterSetName = 'SearchString')] [Parameter(ParameterSetName = 'All')] [Parameter(ParameterSetName = 'AllLicensedOnly')] [switch] $ExportToExcel ) end { $Splat = @{ OnePerLine = $OnePerLine } if ($ExportToExcel) { $ExcelSplat = @{ Path = (Join-Path -Path ([Environment]::GetFolderPath("Desktop")) -ChildPath 'UserSkus.xlsx') TableStyle = 'Medium2' FreezeTopRowFirstColumn = $true AutoSize = $true BoldTopRow = $false ClearSheet = $true ErrorAction = 'SilentlyContinue' } } switch ($PSCmdlet.ParameterSetName) { 'SharePoint' { $SharePointSplat = @{ SharePointURL = $SharePointURL ExcelFile = $ExcelFile NoBatch = $true } $UserChoice = Import-SharePointExcelDecision @SharePointSplat if ($UserChoice -ne 'Quit' ) { $Splat.Add('SharePoint', $true) $Splat.Add('UserChoice', $UserChoice) if (-not $ExportToExcel) { Invoke-GetMailboxMoveLicenseUserSku @Splat | Out-GridView -Title "Report of user skus" } else { Invoke-GetMailboxMoveLicenseUserSku @Splat | Export-Excel @ExcelSplat } } } { $_ -match 'All' } { if (-not $AllLicensedOnly) { $UserChoice = Get-AzureADUser -All:$true $Splat.Add('All', $true) $Splat.Add('UserChoice', $UserChoice) } else { $UserChoice = (Get-AzureADUser -All:$true).Where{ $_.AssignedLicenses } $Splat.Add('AllLicensedOnly', $true) $Splat.Add('UserChoice', $UserChoice) } if (-not $ExportToExcel) { Invoke-GetMailboxMoveLicenseUserSku @Splat | Out-GridView -Title "Report of user skus" } else { Invoke-GetMailboxMoveLicenseUserSku @Splat | Export-Excel @ExcelSplat } } 'SearchString' { $UserChoice = Get-AzureADUser -SearchString $SearchString $Splat.Add('SearchString', $true) $Splat.Add('UserChoice', $UserChoice) if (-not $ExportToExcel) { Invoke-GetMailboxMoveLicenseUserSku @Splat | Out-GridView -Title "Report of user skus" } else { Invoke-GetMailboxMoveLicenseUserSku @Splat | Export-Excel @ExcelSplat } } } } } |