sharepoint Archives - Sathiya's Blog

SharePoint Server 2019 Public Preview

As expected Microsoft introduced SharePoint server 2019 product in May 2018 SharePoint conference. The product has more refined feature in terms of user experience, development stuff, security concerns and scalable with Hybrid collaboration environments

Now, public preview available to experience the complete features of next milestone.

SharePoint Server 2019 Public Preview

Product	Build Number	Package Name	Download/Release CU	Release Date
SharePiont 2019	16.0.10711.37301	Public preview	Download	2018 July 24

Features

Find the major noticeable features;

Modern user experience based on online product
Content across browser and devices
Robust scalability, security and compliance capabilities

Previous production has a limitation in larger file, character restrictions, files/folder names those are improved in 2019

File can be upload upto 15GB
URL length has been Increases from 260 Unicode code units to 400.

Tip: SharePoint 2019 complete features, checkout white paper.

Cheers!

September 8, 2018

Clear SharePoint 2013 Config Cache

SharePoint 2013 Config Cache fix mostly unstable service or applications, try with cache clear script as troubleshoot them in farm level. Here the scripts makes perfect with dynamic values of GUI ID and other parameters.

Standalone farm clean can be done manually but if its multi-tier farm would time conservation so better do with powerful tool. Tweak with below dynamic script that not require any additional changes.

<#
.DESCRIPTION
    Clear SharePoint Config Cache with dynamic values
.NOTES
    Author: Sathiya.io
#>
if((Get-PSSnapin | Where {$_.Name -eq “Microsoft.SharePoint.PowerShell”}) -eq $null) {
    Add-PSSnapin Microsoft.SharePoint.PowerShell;
}
 
function Man-Main {
    try {
        $cacheFolder = $null
        $items = $null
        $item = $null
        $a = $null
        $cacheFolderName = (Get-ItemProperty -Path “HKLM:SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\15.0\Secure\ConfigDB”).id
        if($cacheFolderName -ne $null) {
            Stop-Service SPTimerV4
            $cacheFolder = “$env:ProgramData\Microsoft\SharePoint\Config\$cacheFolderName”
            $items = Get-ChildItem $cacheFolder
            foreach ($item in $items)
            {
                if ($item.Extension -eq “.xml”)
                {
                   $item.Delete()
                    #Write-Host $item.name “file has been deleted”
                }
            }
            $a = Get-Content $cacheFolder\cache.ini
            $a  = 1
            Set-Content $a -Path $cacheFolder\cache.ini
            Write-Host “Cache files are deleted successfully” -ForegroundColor Gray -BackgroundColor Green
            Start-Service SPTimerV4
        }
        else {
            return [System.String](“[WARNING]:No SharePoint instance found in the server”)
        }
    }
    catch {
        Write-Output “Error clearing SharePoint cache”
    }
}
Man-Main

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

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

<#

.DESCRIPTION

Clear SharePoint Config Cache with dynamic values

.NOTES

Author: Sathiya.io

#>

if((Get–PSSnapin | Where {$_.Name –eq “Microsoft.SharePoint.PowerShell”}) –eq $null) {

Add–PSSnapin Microsoft.SharePoint.PowerShell;

}

function Man–Main {

try {

$cacheFolder = $null

$items = $null

$item = $null

$a = $null

$cacheFolderName = (Get–ItemProperty –Path “HKLM:SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\15.0\Secure\ConfigDB”).id

if($cacheFolderName –ne $null) {

Stop–Service SPTimerV4

$cacheFolder = “$env:ProgramData\Microsoft\SharePoint\Config\$cacheFolderName”

$items = Get–ChildItem $cacheFolder

foreach ($item in $items)

{

if ($item.Extension –eq “.xml”)

{

$item.Delete()

#Write-Host $item.name “file has been deleted”

}

$a = Get–Content $cacheFolder\cache.ini

$a = 1

Set–Content $a –Path $cacheFolder\cache.ini

Write–Host “Cache files are deleted successfully” –ForegroundColor Gray –BackgroundColor Green

Start–Service SPTimerV4

}

else {

return [System.String](“[WARNING]:No SharePoint instance found in the server”)

}

catch {

Write–Output “Error clearing SharePoint cache”

}

Man–Main

Cheers!

July 1, 2018

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

Download Installed SharePoint Solutions

Tweaks of SharePoint PowerShell script to download installed SharePoint solutions from the farm. All solution has deployed on server hives folder and the database but there is not option to download them. Try with below script to attain it.

Snippet:

$farm = Get-SPFarm
$solution = $farm.Solutions.Item(“SiteSolution.wsp”).SolutionFile
$solutions.SaveAs(“c:\wsp\SiteSolution.wsp”)

1

2

3

$farm = Get–SPFarm

$solution = $farm.Solutions.Item(“SiteSolution.wsp”).SolutionFile

$solutions.SaveAs(“c:\wsp\SiteSolution.wsp”)

Cheers…!

March 4, 2016

Verifying SMTP SharePoint Outbound mail settings

Once we configured the SharePoint outbound mail server then our responsible to test the setup. Here the small powershell snippet will do!

### The script will return True or False
$toemail = “sathiya@sathiya.io”
$subject = “Test – SharePoint Outbound mail”
$body = “This mail for testing purpose…! Please ignore your action!”
$site = New-Object Microsoft.SharePoint.SPSite “http://sharepoint/”
$web = $site.OpenWeb()
[Microsoft.SharePoint.Utilities.SPUtility]::SendEmail($web,0,0,$toemail,$subject,$body)

1

2

3

4

5

6

7

### The script will return True or False

$toemail = “sathiya@sathiya.io”

$subject = “Test – SharePoint Outbound mail”

$body = “This mail for testing purpose…! Please ignore your action!”

$site = New-Object Microsoft.SharePoint.SPSite “http://sharepoint/”

$web = $site.OpenWeb()

[Microsoft.SharePoint.Utilities.SPUtility]::SendEmail($web,0,0,$toemail,$subject,$body)

If you get “True” the configuration perfectly alright, else you have to check the ULS log to find an issue. Suppose if you are not getting a mail you have to check smtp log or address to exchange/wintel team.

February 10, 2016

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

Tag: sharepoint

SharePoint Server 2019 Public Preview

SharePoint Server 2019 Public Preview

Features

Clear SharePoint 2013 Config Cache

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

Download Installed SharePoint Solutions

Verifying SMTP SharePoint Outbound mail settings

Delete SharePoint list items from PowerShell