Rename SharePoint IIS WebSite URL

 Updating SharePoint Web Application url involves couple of steps.

1. Identify zone which old Webapplication URL is referring to this can be achieved using Powershell or

through Central Admin of SharePoint.

Below is PowerShell Script to get zone of Webapplication let us say i have webapplication which is referring to Custom zone which needs to be update with new url then

1.      We see that its mapped with Custom Zone, We need to update https://xyz.olddomain.com to https://xyz.newdomain.com 

      Set-SPAlternateURL -Identity https://xyz.olddomain.com -Url https://xyz.newdomain.com   -Zone "Custom"

2. Update IIS Settings ( Steps to be Performed in all Webfrontend (WebServer) Servers)

 1.     Loginto your webserver and   Go to IIS àEdit àBindings of Internal URL to Change and update HostName to xyz.newdomain.com

Refresh the AppPool you should be able to see the changes new domain changes

SharePoint Online The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator

Microsoft.SharePoint.SPQueryThrottledException

SharePoint Online Lists and library are capable of storing around 30 million 

items or files in a SharePoint list or library.

In order to overcome the error listview threshold of 5000 items , Create an index for the column

Below is the rest api query while i am trying to query a list which has 11,000 records and trying to filter with non indexed column which is throwing below error

In Order to overcome to above error, i went ahead and created an index for the column which i am querying 

SharePoint Online Update List item

SharePoint Online Update Rich Text Column html

We had a business requirement to remove/update the list items by removing unnecessary styles added at list item

Below is the code snippet which will loop through all the items and removes  strings  ex: data between style tags i.e all the styles between  <style> </style>

cls

Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.dll"

Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.Runtime.dll"

$UserName= "username@companyname.com"

$Password = "pwd"

$credentials= New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($UserName,(ConvertTo-SecureString $Password -AsPlainText -Force))

$webURL="https://companyname.sharepoint.com/teams/sitename/"

$ctx= New-Object Microsoft.SharePoint.Client.ClientContext($webURL)

$ctx.Credentials = $credentials

$list = $ctx.web.Lists.GetByTitle("Resources")

$listItems = $list.GetItems([Microsoft.SharePoint.Client.CamlQuery]::CreateAllItemsQuery())

$ctx.load($listItems)

$ctx.executeQuery()

foreach($item in $listItems)

{

     try

    {

    $startIndex=$item["Overview_x0020_Text0"].IndexOf("<style>")

    $endIndex=$item["Overview_x0020_Text0"].IndexOf("</style>")

    If($startIndex -gt  0)

    {

    $newitem=$item["Overview_x0020_Text0"].Remove($startIndex,$endIndex+8)

    $item["Overview_x0020_Text0"]=$newitem

    $item.Update();

    Write-Host -ForegroundColor DarkGreen $item.Id   "Item Updated"

    }

     }

     catch

     {

       Write-Host -ForegroundColor Red  $item.Id "Item Not Updated"

     }

}

    $ctx.ExecuteQuery()

Email address empty after user profile synchronization

After user profile synchronization email address attribute is empty

To fix the issue

Start incremental sync which will resolve the issue

The Tool was unable to install Web Server(IIS) Role

SharePoint 2019 unable to install Web Server Role

The issue was due to .Net 3.5 framework was not installed, hence Follow the below steps

 

The sources file is on your Windows Server 2016 installation media, and you need to specify it and have it mounted

on your computer (or copied somewhere) for the prerequisite install to work properly

Make sure to replace the F:\sources\sxs to the actual path of your sources file.

Everything should work properly afterwards to run the prerequisite installer

Export User Subscribed Alerts to CSV PowerShell

Export Alerts to CSV file using PowerShell

cls

asnp "*sh*"

$web=Get-SPWeb http://msdev02dp:3636/

$alertCollection = @()

 foreach($alert in $web.Alerts)

{

$ExportItem = New-Object PSObject

$ExportItem | Add-Member -MemberType NoteProperty -name "UserName" -value $alert.User.DisplayName

$ExportItem | Add-Member -MemberType NoteProperty -Name "Email" -value $alert.User.Email

$ExportItem | Add-Member -MemberType NoteProperty -name "Title" -value $alert.Title

$ExportItem | Add-Member -MemberType NoteProperty -name "EventType" -value $alert.EventType

$ExportItem | Add-Member -MemberType NoteProperty -name "Frequency" -value $alert.AlertFrequency

$alertCollection += $ExportItem

}

  $alertCollection | Export-CSV "D:\Useralerts.csv" -NoTypeInformation

  $web.Dispose()

Restore Deleted SiteCollection PowerShell

PowerShell Script to Restore Deleted SiteCollection from a Webapplication 

Get the Specific Webapplication ID  and use GetDeltedSites() method to to find out ID your deleted sitecollection and use Restore-SPDeletedSite command let to restore the sitecollection

cls

Add-PSSnapin "Microsoft.SharePoint.PowerShell"

$WebApplication = Get-SPWebApplication -Identity http://spdev2016:2626/

$restore = $WebApplication.GetDeletedSites()

Restore-SPDeletedSite  -Identity 1b0af67e-2f0d-413c-b8b7-9dec119dbc8c -WebApplication 7f1ac80d-d8fb-4a0a-9715-3865a4d139c5 -Confirm:$false