Powershell Archives - Sathiya's Blog

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

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

Create claims-based web application from SharePoint PowerShell

Creating claims-based web application is more flexible with SharePoint PowerShell script than CA. Here, the snippet for http and ssl site.

Add-PSSnapin Microsoft.SharePoint.Powershell
$ap = New-SPAuthenticationProvider
New-SPWebApplication -Name <Name> -ApplicationPool <ApplicationPool> -ApplicationPoolAccount <ApplicationPoolAccount> -URL <URL> -Port <Port> -AuthenticationProvider $ap
# <Name> is the name of the new web application that uses claims-based authentication.
# <ApplicationPool> is the name of the application pool.
# <ApplicationPoolAccount> is the user account that this application pool will run as.
# <URL> is the public URL for this web application.
# <Port> is the port on which the web application will be created in IIS.

# For Non-SSL
New-SPWebApplication -Name “Web Portal – 80” -ApplicationPool “Web Portal Application Pool – 80” -ApplicationPoolAccount (Get-SPManagedAccount “sathiya\sp_appPool”) -URL http://webportal.sathiya.com -Port 80 -HostHeader webportal.sathiya.com -DatabaseName WSS_Content_WebPortal_80 -Path “D:\Web_Portal_80” -AuthenticationProvider $ap 

# For SSL 
New-SPWebApplication -Name “Web Portal – 443” -ApplicationPool “Web Portal Application Pool – 443” -ApplicationPoolAccount (Get-SPManagedAccount “sathiya\sp_appPool”) -URL https://webportal.sathiya.com -Port 443 -HostHeader webportal.sathiya.com -DatabaseName WSS_Content_WebPortal_443 -Path “D:\Web_Portal_443” -SecureSocketsLayer -AuthenticationProvider $ap

1

2

3

4

5

6

7

8

9

10

11

12

13

14

Add-PSSnapin Microsoft.SharePoint.Powershell

$ap = New-SPAuthenticationProvider

New-SPWebApplication -Name <Name> -ApplicationPool <ApplicationPool> -ApplicationPoolAccount <ApplicationPoolAccount> -URL <URL> -Port <Port> -AuthenticationProvider $ap

# <Name> is the name of the new web application that uses claims-based authentication.

# <ApplicationPool> is the name of the application pool.

# <ApplicationPoolAccount> is the user account that this application pool will run as.

# <URL> is the public URL for this web application.

# <Port> is the port on which the web application will be created in IIS.

# For Non-SSL

New-SPWebApplication -Name “Web Portal – 80” -ApplicationPool “Web Portal Application Pool – 80” -ApplicationPoolAccount (Get-SPManagedAccount “sathiya\sp_appPool”) -URL http://webportal.sathiya.com -Port 80 -HostHeader webportal.sathiya.com -DatabaseName WSS_Content_WebPortal_80 -Path “D:\Web_Portal_80” -AuthenticationProvider $ap

# For SSL

New-SPWebApplication -Name “Web Portal – 443” -ApplicationPool “Web Portal Application Pool – 443” -ApplicationPoolAccount (Get-SPManagedAccount “sathiya\sp_appPool”) -URL https://webportal.sathiya.com -Port 443 -HostHeader webportal.sathiya.com -DatabaseName WSS_Content_WebPortal_443 -Path “D:\Web_Portal_443” -SecureSocketsLayer -AuthenticationProvider $ap

Cheers…!

October 23, 2015

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

Creating Managed Metadata Service Application by Powershell Script

As we are all knows, the SharePoint Powershell can be fast and simple. Here the sample script for creating Managed Metadata Service Application;

New-SPServiceApplicationPool -Name “Managed Metadata Service App Pool” -Account sathiya\SPAppPool
New-SPMetadataServiceApplication -Name “Managed Metadata Service Application” -ApplicationPool “Managed Metadata Service App Pool” -DatabaseName “MMD”
New-SPMetadataServiceApplicationProxy -Name “Managed Metadata Service App Pool” -ServiceApplication “Managed Metadata Service Application”

1

2

3

New-SPServiceApplicationPool -Name “Managed Metadata Service App Pool” -Account sathiya\SPAppPool

New-SPMetadataServiceApplication -Name “Managed Metadata Service Application” -ApplicationPool “Managed Metadata Service App Pool” -DatabaseName “MMD”

New-SPMetadataServiceApplicationProxy -Name “Managed Metadata Service App Pool” -ServiceApplication “Managed Metadata Service Application”

Cheers!

September 15, 2015

Script to disable list, libraries from SharePoint crawler

This script will disable all list and libraries from search result in the site collection.

Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue
$site = Get-SPSite http://spapplication 
$site | Get-SPWeb -Limit ALL | ForEach-Object {   
    foreach ($list in $_.lists) 
    {                  
                $list.NoCrawl = $true
                $list.Update()
    }
}
$site.Dispose()

1

2

3

4

5

6

7

8

9

10

Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue

$site = Get-SPSite http://spapplication

$site | Get-SPWeb -Limit ALL | ForEach-Object {

foreach ($list in $_.lists)

{

$list.NoCrawl = $true

$list.Update()

}

$site.Dispose()

You can disable it from list/library’s advanced settings. If numerous lists then the script will make it easier.

January 8, 2015

Category: Powershell