SharePoint Knowledge Base

This Blog is a knowledgebase of my daily business. I hope you'll find answers to your questions.

Download and Deploy CRLs fully automated

COMMENT BEGIN ************************************************************************************...

Author: Thomas Bernhard Date: 05/31/2017

Get Database Size for all SharePoint DBs via PowerShell

Add-PSSnapin microsoft.sharepoint.powershell $size = 0foreach ($db in Get-SPContentDatabase){ $size...

Author: Thomas Bernhard Date: 01/21/2015

Perform an IIS Reset on all your SP Servers via PowerShell

This script will list all your SP Servers and restarts IIS on all of them. add-pssnapin...

Author: Thomas Bernhard Date: 12/08/2014

Very slow SharePoint > what can you do against it without upgrading your hardware

There is a very important support article out there, about what you can do if your SharePoint is...

Author: Thomas Bernhard Date: 11/18/2014

Add Query Suggestions via PowerShell

$myquerysuggestions_en = "SharePoint English"$language_en = "EN-US"...

Author: Thomas Bernhard Date: 11/18/2014

Partial Index Reset of a single content source

This script will remove and re-add your content source's start addresses.SharePoint will more or...

Author: Thomas Bernhard Date: 11/18/2014

Replace Text within multiple Wikipages using PowerShell

Script for Sharepoint 2010 Enterprise Wikis! $logfile = "c:\logfile.txt"$web = Get-SPWeb...

Author: Thomas Bernhard Date: 05/29/2013

The password for the content access account cannot be decrypted.....

Errormessage: The password for the content access account cannot be decrypted because it was stored...

Author: Thomas Bernhard Date: 05/29/2013

Add a User and/or Group to all SiteCollections as SiteCollection Admin

This Script will automatically add a User and/Or Group to ALL SiteCollections in ALL WebApplications...

Author: Thomas Bernhard Date: 05/29/2013

Event 2159 / 5586

Event 5586 (SharePoint Foundation) of severity 'Error' occurred 540 more time(s) and was suppressed...

Author: Thomas Bernhard Date: 05/29/2013

WebDav: Prompt for Credentials When Accessing FQDN Sites From a Windows Vista or Windows 7 Computer

https://support.microsoft.com/kb/943280 Click Start, type regedit in the Start Search box, and then...

Author: Thomas Bernhard Date: 05/29/2013

Event ID 8193 Volume Shadow Copy Service Error

Volume Shadow Copy Service error: Unexpected error calling routine...

Author: Thomas Bernhard Date: 05/29/2013

IIS ApplicationHost.config - Request Filtering (e.g. Filetype *.mdb)

If you want to allow a filetype like e.g. *.mdb it's not enough to allow that type within...

Author: Thomas Bernhard Date: 05/29/2013

SQL Query: Force to Shrink all DBs

DO NOT USE THIS SCRIPTS WITHIN YOUR PROD ENVIRONMENT!!!! sp_MSForEachDB ' backup log [?] to disk =...

Author: Thomas Bernhard Date: 05/29/2013

AntiVirus for SharePoint 2013 - Status 05.Mar 2013

Microsoft's Position on Antivirus Solutions for Microsoft SharePoint Portal Server...

Author: Thomas Bernhard Date: 05/29/2013

List all Dataabases from your SQL Server via PowerShell

I've created this script, because some guys wanted to know which DBs are available. It can be used...

Author: Thomas Bernhard Date: 05/29/2013

SharePoint Crawl Log Error: “The SharePoint item being crawled returned an error when attempting to download the item” .. for eg. *.aspx files

After some research I found a solution for that problem Open Regedit on your search server/sNavigate...

Author: Thomas Bernhard Date: 05/29/2013

Partial "Index Reset" (per ContentSource or StartAddress)

This script will remove and re-add your content source's start addresses. SharePoint will more or...

Author: Thomas Bernhard Date: 05/29/2013

Delete Webs Recursive with PowerShell

$web = Get-SPWeb "https://localhost/sites/webwithsubwebs/" function...

Author: Thomas Bernhard Date: 05/29/2013

Check a Lists BrowserFileHandling. --> Set it to Strict or Permissive

Add-PSSnapin -Name Microsoft.SharePoint.PowerShell –erroraction SilentlyContinue $problem_web...

Author: Thomas Bernhard Date: 05/29/2013

SharePoint Social Rating Updates moreoften than once per hour

These two TimerJobs are responsible for Social Rating Updates:...

Author: Thomas Bernhard Date: 05/29/2013

Calculate and Set Distributed Cache Size

#calculation from: https://technet.microsoft.com/en-us/library/jj219613.aspx $membanks =get-wmiobject...

Author: Thomas Bernhard Date: 05/29/2013

The site is not valid. The 'Pages' document library is missing.

ULS Log tells me that: The site is not valid. The 'Pages' document library is missing. .........

Author: Thomas Bernhard Date: 05/29/2013

UserProfileApplication.SynchronizeMIIS: Failed to configure ILM, will attempt during next rerun. Exception: System.Data.SqlClient.SqlException

RUN AS FARMADMIN!!!!! $sync_db = "PROD_SA_UPS_Sync" $ups_service_app_name = "User Profile Service"...

Author: Thomas Bernhard Date: 05/29/2013

set max degree of parallelism (MAXDOP) to 1 on SQL Server instances that host SharePoint Server databases

Storage and SQL Server capacity planning:...

Author: Thomas Bernhard Date: 05/29/2013

This KB describes the problem exactly and brings up a solution:...

Author: Thomas Bernhard Date: 05/29/2013

HTTP 400 - Bad Request (Request Header too long) -- error in Internet Information Services (IIS)

https://support.microsoft.com/kb/2020943 MaxTokenSize: https://support.microsoft.com/kb/327825 By...

Author: Thomas Bernhard Date: 05/29/2013

WebDav: Move Files between WebDav Folders

https://support.microsoft.com/kb/825522/en-us It's most of all only possible to "move" data between...

Author: Thomas Bernhard Date: 05/29/2013

Upgrade all Content DBs (after e.g. CU)

PSConfig.exe -cmd upgrade -inplace b2b -force -cmd applicationcontent -install -cmd installfeatures...

Author: Thomas Bernhard Date: 05/29/2013

PeoplePicker -> Multiple Domains

$domain_trust = "mycompany.local"$pp_user_in_trusted_domain =...

Author: Thomas Bernhard Date: 05/29/2013

Health Analyzer: Missing server side dependencies

[MissingWebPart] WebPart class [baf5274e-a800-8dc3-96d0-0003d9405663] is referenced [25] times in...

Author: Thomas Bernhard Date: 05/29/2013

Health Analyzer: InfoPath Forms Service Cannot be filled out....

$application_name = “Shared State Service Application”$application_db =...

Author: Thomas Bernhard Date: 05/29/2013

WarmUp Script

Add-PsSnapin Microsoft.SharePoint.PowerShell -erroraction silentlycontinue foreach ($webApp in...

Author: Thomas Bernhard Date: 05/29/2013

Change Site Collection Administrator

$webappurl = "https://portal" $account1= "domainname\username" $account2= "domainname\username"...

Author: Thomas Bernhard Date: 05/29/2013

List all Databases from your SQL Server via PowerShell

I've created this script, because some guys wanted to know which DBs are available. It can be used...

Author: Thomas Bernhard Date: 05/29/2013

Start Healh Analyzer Manually

Get-SPTimerJob | Where {$.Name -like "Health" -and $.Name -like "-all-"} | Start-SPTimerJob

Author: Thomas Bernhard Date: 05/29/2013

Add listitems using PowerShell

$weburl = "https://mysharepoint"$listname = "TestList"$a = "Text1"$b = "Text2"$c =...

Author: Thomas Bernhard Date: 05/29/2013

Clear SharePoint Config Cache with PowerShell

Add-PSSnapin -Name Microsoft.SharePoint.PowerShell –erroraction SilentlyContinue write-host "CLEAR...

Author: Thomas Bernhard Date: 05/29/2013