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 ************************************************************************************...
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...
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...
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...
Date: 11/18/2014
Add Query Suggestions via PowerShell
$myquerysuggestions_en = "SharePoint English"$language_en = "EN-US"...
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...
Date: 11/18/2014
Replace Text within multiple Wikipages using PowerShell
Script for Sharepoint 2010 Enterprise Wikis! $logfile = "c:\logfile.txt"$web = Get-SPWeb...
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...
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...
Date: 05/29/2013
Event 2159 / 5586
Event 5586 (SharePoint Foundation) of severity 'Error' occurred 540 more time(s) and was suppressed...
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...
Date: 05/29/2013
Event ID 8193 Volume Shadow Copy Service Error
Volume Shadow Copy Service error: Unexpected error calling routine...
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...
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 =...
Date: 05/29/2013
AntiVirus for SharePoint 2013 - Status 05.Mar 2013
Microsoft's Position on Antivirus Solutions for Microsoft SharePoint Portal Server...
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...
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...
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...
Date: 05/29/2013
Delete Webs Recursive with PowerShell
$web = Get-SPWeb "https://localhost/sites/webwithsubwebs/" function...
Date: 05/29/2013
Check a Lists BrowserFileHandling. --> Set it to Strict or Permissive
Add-PSSnapin -Name Microsoft.SharePoint.PowerShell –erroraction SilentlyContinue $problem_web...
Date: 05/29/2013
SharePoint Social Rating Updates moreoften than once per hour
These two TimerJobs are responsible for Social Rating Updates:...
Date: 05/29/2013
Calculate and Set Distributed Cache Size
#calculation from: https://technet.microsoft.com/en-us/library/jj219613.aspx $membanks =get-wmiobject...
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. .........
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"...
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:...
Date: 05/29/2013
PowerPoint: Link within Email -> Check out do not work properly
This KB describes the problem exactly and brings up a solution:...
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...
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...
Date: 05/29/2013
Upgrade all Content DBs (after e.g. CU)
PSConfig.exe -cmd upgrade -inplace b2b -force -cmd applicationcontent -install -cmd installfeatures...
Date: 05/29/2013
PeoplePicker -> Multiple Domains
$domain_trust = "mycompany.local"$pp_user_in_trusted_domain =...
Date: 05/29/2013
Health Analyzer: Missing server side dependencies
[MissingWebPart] WebPart class [baf5274e-a800-8dc3-96d0-0003d9405663] is referenced [25] times in...
Date: 05/29/2013
Health Analyzer: InfoPath Forms Service Cannot be filled out....
$application_name = “Shared State Service Application”$application_db =...
Date: 05/29/2013
WarmUp Script
Add-PsSnapin Microsoft.SharePoint.PowerShell -erroraction silentlycontinue foreach ($webApp in...
Date: 05/29/2013
Change Site Collection Administrator
$webappurl = "https://portal" $account1= "domainname\username" $account2= "domainname\username"...
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...
Date: 05/29/2013
Start Healh Analyzer Manually
Get-SPTimerJob | Where {$.Name -like "Health" -and $.Name -like "-all-"} | Start-SPTimerJob
Date: 05/29/2013
Add listitems using PowerShell
$weburl = "https://mysharepoint"$listname = "TestList"$a = "Text1"$b = "Text2"$c =...
Date: 05/29/2013
Clear SharePoint Config Cache with PowerShell
Add-PSSnapin -Name Microsoft.SharePoint.PowerShell –erroraction SilentlyContinue write-host "CLEAR...
Date: 05/29/2013