Report for SharePoint Access Request Email Configurations

Requirement:
People are moving to different roles, Few left the company from time to time. Access requests are sent to those in that kind. Its a problem! We had to monitor the access request configurations to make sure its sent to the relevant person. So, Wrote this PowerShell code to generate the report for SharePoint access request email address configurations.

PowerShell to Generate Report on Access Requests Configuration:

#Set-ExecutionPolicy RemoteSigned
$OutputFN = "AccessRequestConfigs.csv"
#delete the file, If already exist!
if (Test-Path $OutputFN)
 { 
    Remove-Item $OutputFN 
 }
#Write the CSV Headers
"Site Collection Name, Site Name ,URL ,Access Requst E-Mail" > $OutputFN

# Get All Web Applications 
$WebAppServices=Get-SPWebApplication

foreach($webApp in $WebAppServices)
{

   # Get All Site collections
    foreach ($SPsite in $webApp.Sites)
    {
       # get All Sites 
       foreach($SPweb in $SPsite.AllWebs)
        {
          if($SPweb.RequestAccessEnabled -eq $True)
          {
           $SPsite.Rootweb.title + "," + $SPweb.title.replace(","," ") + "," + $SPweb.URL + "," + $SPweb.RequestAccessEmail >>$OutputFN
         
          }
          $SPweb.dispose()
        }
      $SPsite.dispose()
    }
  }

and the Output:

Here is the MOSS 2007 Version to get access request Emails:

[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint") > $null

#For SharePoint 2007 compatibility
function global:Get-SPSite($url){
    return new-Object Microsoft.SharePoint.SPSite($url)
}
 
#Get the web application
Write-Host "Enter the Web Application URL:"
$WebAppURL= Read-Host
$SiteColletion = Get-SPSite($WebAppURL)
$WebApp = $SiteColletion.WebApplication

$OutputFN = "AccessRequestConfigs.csv"
#delete the file, If already exist!
if (Test-Path $OutputFN)
 {
    Remove-Item $OutputFN
 }

#Write the CSV Headers
"Site Collection Name, Site Name ,URL ,Access Requst E-Mail" > $OutputFN
 
   # Get All Site collections
    foreach ($SPsite in $webApp.Sites)
    {
       # get All Sites
       foreach($SPweb in $SPsite.AllWebs)
        {
          if($SPweb.RequestAccessEnabled -eq $True)
          {
           $SPsite.Rootweb.title + "`t" + $SPweb.title + "`t" + $SPweb.URL + "`t" + $SPweb.RequestAccessEmail >>$OutputFN
          
          }
          $SPweb.dispose()
        }
      $SPsite.dispose()
    }

Related Posts:

• Configure Access Requests in SharePoint
• Change All Site's Access Request Emails with PowerShell