joerodgers

## Get-ExtenalUser.ps1
[System.Net.WebRequest]::DefaultWebProxy.Credentials = [System.Net.CredentialCache]::DefaultCredentials
[System.Net.ServicePointManager]::SecurityProtocol = [System.Net.SecurityProtocolType]::Tls11 -bor [System.Net.SecurityProtocolType]::Tls12

Import-Module -Name SharePointPnPPowerShellOnline -WarningAction SilentlyContinue

$tenant       = "contoso"
$clientId     = "8a6b10a8-1234-1234-1234-9b8e49b6f6b7"
$certPath     = "E:\AppPrincipalCert.pfx"
$certPassword = ConvertTo-SecureString -String "pass@word1" -AsPlainText -Force

## Get-SuperUserReaderStatus.ps1


function Get-DomainPrincipal
{
    [CmdletBinding()]
    param
    (
        [Parameter(Mandatory=$true,ParameterSetName='DistinguishedName')]
        [Parameter(Mandatory=$true,ParameterSetName='Name')]
        [Parameter(Mandatory=$true,ParameterSetName='SamAccountName')]

## Set-SiteExternalSharingPolicy.ps1
Import-Module SharePointPnPPowerShellOnline

[System.Net.WebRequest]::DefaultWebProxy.Credentials = [System.Net.CredentialCache]::DefaultCredentials
[System.Net.ServicePointManager]::SecurityProtocol = [System.Net.SecurityProtocolType]::Tls11 -bor [System.Net.SecurityProtocolType]::Tls12

$tenant       = "contoso"
$clientId     = "8a6b10a8-1234-1234-1234-9b8e49b6f6b7"
$certPath     = "C:\AADAppPrincipalCertificates\AppPrincipalCert.pfx"
$certPassword = ConvertTo-SecureString -String "pass@word1" -Force -AsPlainText

## Merge-CSV.ps1

function Merge-CSV
{
    [CmdletBinding()]
    param
    (
        [parameter(Mandatory=$true)][string]$PrimaryCSVPath,
        [parameter(Mandatory=$true)][string]$SecondaryCSVPath,
        [parameter(Mandatory=$true)][string]$PrimaryCSVKey,
        [parameter(Mandatory=$true)][string]$SecondaryCSVKey

## Get-FileCompressedMetaInfo.ps1
Add-PSSnapin Microsoft.SharePoint.Powershell

function ConvertFrom-HexStringToByteArray
{
    [CmdletBinding()]
    param
    (
        [parameter(Mandatory=$true)][string]$String
    )


## Remove-FilesBySize.ps1

Add-PSSnapin Microsoft.SharePoint.Powershell

function Get-FileOfSize
{
    [CmdletBinding()]
    param
    (
        [parameter(Mandatory=$true)][string]$SiteUrl,
        [parameter(Mandatory=$true)][int]$Size

## Reset-SiteToDefaultOfficeTheme.ps1

Add-PSSnapin Microsoft.SharePoint.PowerShell

function Remove-ComposedLook
{
    [cmdletbinding()]
    param
    (
        [Parameter(Mandatory=$true)][string]$Name,
        [Parameter(Mandatory=$true)][Microsoft.SharePoint.SPWeb]$Web

## Replace-SPFile.ps1
Add-PSSnapin -Name Microsoft.SharePoint.Powershell

function Get-SPFile
{
    [CmdletBinding()]
    param
    (
        [parameter(Mandatory=$true)][string]$FileUrl
    )


## Remove-PrincipalsFromSiteCollections.ps1
Import-Module SharePointPnPPowerShellOnline

[System.Net.WebRequest]::DefaultWebProxy.Credentials = [System.Net.CredentialCache]::DefaultCredentials
[System.Net.ServicePointManager]::SecurityProtocol = [System.Net.SecurityProtocolType]::Tls11 -bor [System.Net.SecurityProtocolType]::Tls12

$tenant       = "contoso"
$clientId     = "8a6b10a8-1234-1234-1234-9b8e49b6f6b7"
$clientSecret = "44VRi5r3bbCWoEU/WyEQQ+EMq_U]=jRT"
$certPath     = "E:\AppPrincipalCert.pfx"
$certPassword = ConvertTo-SecureString -String "pass@word1" -AsPlainText -Force

## Get-FilesWithMissingEditorAndAuthor.ps1
Add-PSSnapin Microsoft.SharePoint.PowerShell

function Set-EditorAuthorProperty
{
    [cmdletbinding()]
    param
    (
        [Parameter(Mandatory=$true)][string]$FileUrl,
        [Parameter(Mandatory=$true)][string]$DefaultAuthor,
        [Parameter(Mandatory=$true)][string]$DefaultEditor