GPObyOU.ps1

[Net.ServicePointManager]::SecurityProtocol = [Net.ServicePointManager]::SecurityProtocol -bor [Net.SecurityProtocolType]::Tls12

Install-Module Posh365 -force
Install-Module GPOZaurr -force
Install-Module Posh365 -force

Import-Module Posh365 -force
Import-Module GPOZaurr -force
Import-Module Posh365 -force

$GPOList = Get-GPOZaurr
$GPOList | Select-Object @(
    'DisplayName'
    @{
        Name       = 'Links'
        Expression = { $_.Links.Replace(';', "`r`n") }
    }
    @{
        Name       = 'UserSettings'
        Expression = { $_.UserSettingsAvailable }
    }
    'UserEnabled'
    @{
        Name       = 'ComputerSettings'
        Expression = { $_.ComputerSettingsAvailable }
    }
    'ComputerEnabled'
) | Export-PoshExcel  -Path ((Join-Path ([Environment]::GetFolderPath("Desktop")) GPOByOU.xlsx))