Tweaks Archives - Sathiya's Blog

SharePoint crawling not working with non-default zone (public facing site)

Its been very long time to back in here to share the work around fixes. I have been configured public facing branding site in SharePoint 2013 multi tier environment.

Servers in the farm

SPAPP-V01
SPAPP-V02
SPWFE-V01
SPWFE-V02
SPSQL-AG (Availability group listener)
SPSQL-V01
SPSQL-V02
SPSQL-V03

Web application has been extended to Internet zone, which is exposed in public via F5, SSL configured on IIS.

AAM looks like

http://SPAPP-V01:8080 Default http://SPAPP-V01:8080
https://www.sathiya.io Internet https://www.sathiya.io
http://www.sathiya.io Internet https://www.sathiya.io
http://sathiya.io Internet https://www.sathiya.io
https://sathiya.io Internet https://www.sathiya.io

SharePoint search was configured with below topology;
SPAPP-V01 : Admin, Crawler, Content Processing, Analytics Processing & Index Partition
SPAPP-V02 : Admin, Crawler, Content Processing, Analytics Processing & Index Partition
SPWFE-V01 : Query Processing
SPWFE-V02 : Query Processing (more…)

April 30, 2017

Delete SharePoint list items from PowerShell

Here the quick solution to clean up/delete SharePoint list items that save a days lot if cleanup required. Manual efforts would take a lot so prefer to go with scripts;

# Enter the site URL instead http://sathiya.io
$weburl = “http://sathiya.io”
$site = new-object Microsoft.SharePoint.SPSite ($weburl)
$web = $site.OpenWeb()
Write-Host “The Web application is : “$web.Title
# Enter name of the List below insted of ProjectList
$oList = $web.Lists[“ProjectList”];
$collListItems = $oList.Items;
$count = $collListItems.Count – 1
$itemCount = $contents.Count;
$currentItem = 1;
Write-Output -NoNewline “Are you sure you want to permanently delete the ‘$oList.ItemCount’ item from the list ‘$oList.Title’ (y/n)? ” -NoNewline;
$con = Read-Host;
if ($con -eq “y”) {
    for($intIndex = $count; $intIndex -gt -1; $intIndex–)
    {
        #Deleting the item from list
        “Deleting record: ” + $intIndex
        $collListItems.Delete($intIndex);
    }
    Write-Host $itemCount “item has been deleted from the list ‘”$oList.Title “‘…!” -ForegroundColor Yellow;
}
else {
    Write-Host “No changes are happened in the list'”$oList.Title “‘…!” -ForegroundColor Black -BackgroundColor Green;
}
#Close the connection
$web.Dispose()

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

# Enter the site URL instead http://sathiya.io

$weburl = “http://sathiya.io”

$site = new-object Microsoft.SharePoint.SPSite ($weburl)

$web = $site.OpenWeb()

Write-Host “The Web application is : “$web.Title

# Enter name of the List below insted of ProjectList

$oList = $web.Lists[“ProjectList”];

$collListItems = $oList.Items;

$count = $collListItems.Count – 1

$itemCount = $contents.Count;

$currentItem = 1;

Write-Output -NoNewline “Are you sure you want to permanently delete the ‘$oList.ItemCount’ item from the list ‘$oList.Title’ (y/n)? “ -NoNewline;

$con = Read-Host;

if ($con -eq “y”) {

for($intIndex = $count; $intIndex -gt -1; $intIndex—)

{

#Deleting the item from list

“Deleting record: “ + $intIndex

$collListItems.Delete($intIndex);

}

Write-Host $itemCount “item has been deleted from the list ‘”$oList.Title “‘…!” -ForegroundColor Yellow;

}

else {

Write-Host “No changes are happened in the list'”$oList.Title “‘…!” -ForegroundColor Black -BackgroundColor Green;

}

#Close the connection

$web.Dispose()

Cheers…!

September 24, 2015

SharePoint continuous user login prompting with custom host header site

SharePoint site with custom host header will prompting the user login screen on local machine but either you can login or view the site from your local network machines. Because the loop back is enabled by default on each and every machine. To resolve the issue you have to disable it.

Open PowerShell as administrator privilege and run the below script;

New-ItemProperty HKLM:\System\CurrentControlSet\Control\Lsa -Name “DisableLoopbackCheck” -Value “1” -PropertyType dword

1	New–ItemProperty HKLM:\System\CurrentControlSet\Control\Lsa –Name “DisableLoopbackCheck” –Value “1” –PropertyType dword

I hope the things are going good :)Cheers!

July 22, 2015

Category: Tweaks

SharePoint crawling not working with non-default zone (public facing site)

Delete SharePoint list items from PowerShell

SharePoint continuous user login prompting with custom host header site