joerodgers
joerodgers
/ Get-Microsoft365GroupDetails.ps1
Last active
June 26, 2024 20:58
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #requires -modules "PnP.PowerShell" | |
| Connect-PnPOnline ` | |
| -Url "https://$env:O365_TENANT-admin.sharepoint.com" ` | |
| -ClientId $env:O365_CLIENTID ` | |
| -Thumbprint $env:O365_THUMBPRINT ` | |
| -Tenant $env:O365_TENANTID ` | |
| -ErrorAction Stop | |
| $unifiedGroups = Get-PnPMicrosoft365Group |
joerodgers
/ Find-OrphanedM365Groups.ps1
Last active
June 21, 2024 15:36
Shows all M365 group connected sites and reports if the associated M365 group exists.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #requires -module "PnP.PowerShell" | |
| # Required permissions: | |
| # Microsoft Graph API : One of Directory.Read.All, Directory.ReadWrite.All, Group.Read.All, Group.ReadWrite.All, GroupMember.Read.All, GroupMember.ReadWrite.All | |
| # SharePoint Online : Sites.FullControl.All | |
| Connect-PnPOnline ` | |
| -Url "https://$env:O365_TENANT-admin.sharepoint.com" ` | |
| -ClientId $env:O365_CLIENTID ` | |
| -Thumbprint $env:O365_THUMBPRINT ` | |
| -Tenant $env:O365_TENANTID ` |
joerodgers
/ Get-SharePointSiteGroupMembers.ps1
Created
June 21, 2024 15:04
Reports the memberships of the Owners, Members, and Visitors groups of SharePoint Online sites. This example further filters the results to only show sites with any group containing the EEEU claim
joerodgers
/ Get-CrmBot.ps1
Last active
June 13, 2024 18:37
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #requires -modules "Microsoft.Xrm.Data.Powershell" | |
| $ErrorActionPreference = [System.Management.Automation.ActionPreference]::Stop | |
| $credential = [PSCredential]::new( 'powerplatfromadmin@contoso.com', ( '<password>' | ConvertTo-SecureString -AsPlainText -Force) ) | |
| $environments = Get-CrmOrganizations -OnLineType Office365 -Credential $credential | |
| $timestamp = Get-Date -Format FileDateTime |
joerodgers
/ Get-LoopWorkspaceData.ps1
Created
June 4, 2024 20:44
Exports Loop Workspace Data to CSV
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Connect-SPOService -Url "https://contoso-admin.sharepoint.com" | |
| $counter = 1 | |
| $token = $null | |
| $containers = do | |
| { | |
| Write-Host "[$(Get-Date)] - Fetching Containers page: $counter" | |
| $containers = if( -not $token ) |
joerodgers
/ Add-SiteUrlToSharePointSiteUsageDetailReport.ps1
Created
June 3, 2024 15:08
Fills in the missing Site Url column value in the SharePointSiteUsageDetail report.
joerodgers
/ Disable-TeamifyDialog.ps1
Created
June 3, 2024 14:48
Example script to hide the "Teamify" Dialog box on all M365 group connected sites
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #requires -modules "PnP.PowerShell" | |
| # permission requirements | |
| # - Microsoft Graph > Application > one of Directory.Read.All, Directory.ReadWrite.All, Group.Read.All, Group.ReadWrite.All, GroupMember.Read.All, GroupMember.ReadWrite.All | |
| # - SharePoint > Application > Sites.FullControl.All | |
| Connect-PnPOnline ` | |
| -Url "https://$env:O365_TENANT-admin.sharepoint.com" ` | |
| -ClientId $env:O365_CLIENTID ` | |
| -Thumbprint $env:O365_THUMBPRINT ` |
joerodgers
/ New-AzureACSSharePointAppRegSecret.ps1
Created
May 24, 2024 13:50
joerodgers
/ Get-FolderChildCount.ps1
Created
May 17, 2024 19:23
Gets the file and folder count for the provided list folder and, optionally, all sub folders.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #requies -modules "PnP.PowerShell" | |
| function Get-FolderChildCount | |
| { | |
| [CmdletBinding()] | |
| param | |
| ( | |
| [Parameter(Mandatory=$true)] | |
| [Microsoft.SharePoint.Client.List] | |
| $List, |
joerodgers
/ Grant-AzureADAppSitePermission.ps1
Last active
May 23, 2024 21:13
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #requires -modules "PnP.PowerShell" | |
| # permissions required SharePoint > Application > Sites.FullControl.All | |
| Connect-PnPOnline ` | |
| -Url "https://$env:O365_TENANT-admin.sharepoint.com" ` | |
| -ClientId $env:O365_CLIENTID ` | |
| -Thumbprint $env:O365_THUMBPRINT ` | |
| -Tenant $env:O365_TENANT ` | |
| -ErrorAction Stop |
NewerOlder