Adding column to list to all site collections

param($Site,$FilePath)

 

Add-PSSnapin microsoft.sharepoint.powershell -ErrorAction SilentlyContinue

 

function GenerateMAPIdInAllSitecollections ($url)

{

    write-host "Sitecollection Lists...." -foregroundcolor red

    try

      {

         $Site=Get-SPSite $url        

         $spWebApp = $Site.WebApplication

         $TotalList = @()

          write-host "Below is the list of all sitecollections for webapplication" + $spWebApp + "..." -foregroundcolor red

         foreach($allsites in $spWebApp.Sites)

         {

           $siteUrl =  $allsites.url

           write-host $siteUrl -foregroundcolor green

          

            $site = Get-SPSite $siteUrl

            foreach ($web in $site.AllWebs)

                {

                   foreach($list in $web.lists)

                   {

                       if($list.Title -eq "DivisionalDocuments")

                       {

                       write-host $list.Title -ForegroundColor blue

                       write-host $list["Title"]

                       $myCustomList = $web.Lists[$list.Title]

                        

                         ## get fields

                         if($list.Fields.ContainsField("MapId") -eq $true)

                            {                                      

                                  Write-Host "MapId already Exits"

                            }

                        else

                           {

                                $Name = "<Field Type='Text' DisplayName='MapId' Required='FALSE' MaxLength='255' StaticName='MapId' Name='MapId' />"

                                $myCustomList.Fields.AddFieldAsXml($Name,$true,[Microsoft.SharePoint.SPAddFieldOptions]::AddFieldToDefaultView)

                          

                                 $myCustomList.update()

                                 break;

                           }

                         ##

                        

                       }

                    }

                 }

                  

         }                      

      }

   catch

      {

          write-host "Unable to Extract Sitecollection List..." -foregroundcolor red

          break

      }

}

cls

GenerateMAPIdInAllSitecollections  -Url "http://test201305:4130"