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
    By default, results are displayed in Out-GridView, unless -ExportToExcel switch is used
    Excel is saved as UserSkus.xlsx to desktop
 
    .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. "Batches.xlsx"
 
    .PARAMETER All
    All AzureAd Users and their licence(s) or lack thereof
 
    .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
 
    .PARAMETER ExportToExcel
    Export Results to a xlsx file on the desktop named UserSkus.xlsx
    If a file is already named this on the desktop it will be overwritten with the new data
 
    .EXAMPLE
    Get-MailboxMoveLicenseUserSku -All
 
    .EXAMPLE
    Get-MailboxMoveLicenseUserSku -All -ExportToExcel
 
    .EXAMPLE
    Get-MailboxMoveLicenseUserSku -All -OnePerLine
 
    .EXAMPLE
    Get-MailboxMoveLicenseUserSku -All -OnePerLine -ExportToExcel
 
    .EXAMPLE
    Get-MailboxMoveLicenseUserSku -AllLicensedOnly
 
    .EXAMPLE
    Get-MailboxMoveLicenseUserSku -AllLicensedOnly -ExportToExcel
 
    .EXAMPLE
    Get-MailboxMoveLicenseUserSku -AllLicensedOnly -OnePerLine
 
    .EXAMPLE
    Get-MailboxMoveLicenseUserSku -AllLicensedOnly -OnePerLine -ExportToExcel
 
    .EXAMPLE
    Get-MailboxMoveLicenseUserSku -SearchString Mike
 
    .EXAMPLE
    Get-MailboxMoveLicenseUserSku -SearchString Mike -ExportToExcel
 
    .EXAMPLE
    Get-MailboxMoveLicenseUserSku -SearchString Mike -OnePerLine
 
    .EXAMPLE
    Get-MailboxMoveLicenseUserSku -SearchString Mike -OnePerLine -ExportToExcel
 
    .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,

        [Parameter(ParameterSetName = 'SharePoint')]
        [Parameter(ParameterSetName = 'SearchString')]
        [Parameter(ParameterSetName = 'All')]
        [Parameter(ParameterSetName = 'AllLicensedOnly')]
        [switch]
        $IncludeRecipientType
    )
    end {
        $Splat = @{
            OnePerLine           = $OnePerLine
            IncludeRecipientType = $IncludeRecipientType
        }
        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 sku's"
                    }
                    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 sku's"
                }
                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 sku's"
                }
                else {
                    Invoke-GetMailboxMoveLicenseUserSku @Splat | Export-Excel @ExcelSplat
                }
            }
        }
    }
}