sharepoint

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

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

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.

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:

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)

### 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

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()

# 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…!