[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint")
#Functions to Imitate SharePoint 2010 Cmdlets in MOSS 2007function global:Get-SPWebApplication($WebAppURL) { return [Microsoft.SharePoint.Administration.SPWebApplication]::Lookup($WebAppURL) }function global:Get-SPSite($url) { return new-Object Microsoft.SharePoint.SPSite($url) }function global:Get-SPWeb($url){ $site= New-Object Microsoft.SharePoint.SPSite($url) if($site -ne $null) { $web=$site.OpenWeb(); } return $web}#Function to Check if an User exists in ADfunction CheckUserExistsInAD() { Param( [Parameter(Mandatory=$true)] [string]$UserLoginID ) #Search the User in AD $forest = [System.DirectoryServices.ActiveDirectory.Forest]::GetCurrentForest() foreach ($Domain in $forest.Domains) { $context = new-object System.DirectoryServices.ActiveDirectory.DirectoryContext("Domain", $Domain.Name) $domain = [System.DirectoryServices.ActiveDirectory.Domain]::GetDomain($context) $root = $domain.GetDirectoryEntry() $search = [System.DirectoryServices.DirectorySearcher]$root $search.Filter = "(&(objectCategory=User)(samAccountName=$UserLoginID))" $result = $search.FindOne() if ($result -ne $null) { return $true } } return $false } $WebAppURL="<a class="vglnk" href="https://sharepoint.crescent.com" rel="nofollow"><span>https</span><span>://</span><span>sharepoint</span><span>.</span><span>crescent</span><span>.</span><span>com</span></a>" #Get all Site Collections of the web application $WebApp = Get-SPWebApplication $WebAppURL #Iterate through all Site Collections foreach($site in $WebApp.Sites) { #Get all Webs with Unique Permissions - Which includes Root Webs $WebsColl = $site.AllWebs | Where {$_.HasUniqueRoleAssignments -eq $True} | ForEach-Object { $OrphanedUsers = @() #Iterate through the users collection foreach($User in $_.SiteUsers) { #Exclude Built-in User Accounts , Security Groups & an external domain "corporate" if(($User.LoginName.ToLower() -ne "nt authority\authenticated users") -and ($User.LoginName.ToLower() -ne "sharepoint\system") -and ($User.LoginName.ToLower() -ne "nt authority\local service") -and ($user.IsDomainGroup -eq $false ) -and ($User.LoginName.ToLower().StartsWith("corporate") -ne $true) ) { $UserName = $User.LoginName.split("\") #Domain\UserName $AccountName = $UserName[1] #UserName if ( ( CheckUserExistsInAD $AccountName) -eq $false ) { Write-Host "$($User.Name)($($User.LoginName)) from $($_.URL) doesn't Exists in AD!" #Make a note of the Orphaned user $OrphanedUsers+=$User.LoginName } } } # **** Remove Users ****# # Remove the Orphaned Users from the site # foreach($OrpUser in $OrphanedUsers) # { # $_.SiteUsers.Remove($OrpUser) # Write-host "Removed the Orphaned user $($OrpUser) from $($_.URL) " # } }}
One thought on “Powershell script to find and delete orphaned users in SharePoint”