Change Page Layout in SharePoint 2013 using PowerShell

October 30, 2014    , , , ,
In a public internet SharePoint web site based on publishing site template, We got a requirement to update existing page layouts and create new ones. So, the development team created new page layouts, Updated existing Page layouts with required changes. Any page going to be created with these upd…

Archive SharePoint Library Files into Sub-Folders using PowerShell

October 29, 2014    , , , ,
Requirement: We've a very large library with more than 20,000 files stored in the root of the document library without any sub-folders. Got to move files into Sub-folders to improve performance. Solution: We analyzed the library content and decided to move files into sub-folders based on f…

Get SharePoint Documents Inventory Report with PowerShell

October 27, 2014    , , , , , , ,
This PowerShell script generates detailed report on the given SharePoint library's inventory in addition with its storage data. The output report contains: File Name File Size(KB) Versions Size(KB) Total File Size(KB) Created on Last Modified Created by Parent Folder URL ShareP…

Some Farm Products and patches were not detected on this or other servers - Fix

October 25, 2014    , , , , , ,
After patching a SharePoint 2013 Farm, Attempted running SharePoint Products configuration wizard and receive this error message: "Error: Some farm products and patches were not detected on this or other servers.  If products or patches are missing locally, you must quit this program and in…

SharePoint Active Directory Group Membership Sync Problem and Solution

October 25, 2014    , , , , , ,
Problem: SharePoint AD group membership permission changes are not reflecting immediately. Active directory group users get access denied in SharePoint! In a SharePoint site where users are managed from AD security groups, newly added members to Active Directory security groups couldn't ac…

Copy List Permissions in SharePoint using PowerShell

October 22, 2014    , ,
Ever wanted to clone permissions between SharePoint lists or Libraries? Well, Here is the nifty PowerShell script to copy permissions between SharePoint lists: Add-PSSnapin Microsoft.SharePoint.PowerShell -erroraction SilentlyContinue #PowerShell Function to copy permissions between Lists in Sh…

Add-Remove Permissions to SharePoint List using PowerShell

October 18, 2014    , , , , ,
Requirement: Set list permissions using PowerShell PowerShell can be utilized to Add/Remove permission to SharePoint List. Here is my PowerShell script to grant and remove permissions to SharePoint sites, lists and libraries  Grant Permission to a user or group to SharePoint List Add-PSS…

SharePoint PowerShell Error: Cannot open database "Database-Name" requested by the login. The login failed. Login failed for user 'Domain\UserName'.

October 17, 2014    , , ,
Problem:  SharePoint Admin tried backing up a SharePoint 2013 site collection with Backup-SPSite PowerShell cmdlet and got an error "Cannot open database "WSS_Content_demo" requested by the login. The login failed. Login failed for user 'HOSTING\DemoUser'." Root…

How to Sync SharePoint 2013 Document Library with Local Folder?

October 16, 2014    , , ,
In SharePoint Server 2013, users can perform two way sync between files stored in SharePoint document libraries and their local machine. The OneDrive for Business sync client performs the synchronization of files between document libraries and the user's local disk, So that users can take the…

Find and Replace URL Links from Hyperlink Columns in SharePoint

October 15, 2014    , , , , ,
Requirement: We had a SharePoint portal site called "Crescent Portal" with URL: http://portal.crescent.com. After migrating from SharePoint 2010 to SharePoint 2013, we made a decision to replace both site name and URL as "Crescent Intranet" with URL "http://intranet.cre…

Copy-SPSite - Clone SharePoint Site Collection using PowerShell

October 15, 2014    , , , ,
Copy-SPSite is a new feature introduced in SharePoint 2013, allows us to copy an existing site collection in to a new site collection. Copy-SPSite cmdlet clones/duplicates existing site collection into new one. Optionally, You can specify "Destination Database" parameter to copy the si…

This view cannot be displayed because the number of lookup and workflow status columns it contains exceeds the threshold (8) enforced by the administrator.

October 14, 2014    , , ,
Problem: "This view cannot be displayed because the number of lookup and workflow status columns it contains exceeds the threshold (8) enforced by the administrator." Root Cause: Usually, You'll get this error message when your List view has many Lookup fields. Threshold feat…

Check if SharePoint Site Collection, Site, List, Document, Column Exists in PowerShell

October 11, 2014    , , , , , ,
Here is my nifty PowerShell scripts to check if a given URL of Site collection, Site, List, Document (File) and column objects exists in SharePoint. You can utilize these helper functions wherever required. PowerShell to check if Site Collection Exists: Here is my custom function and function …

Fix "This page can't be displayed" "Internet Explorer Cannot Display This Page" Errors when Creating Web Application in SharePoint 2013

October 04, 2014    , , , , ,
Web application creation process through SharePoint 2013 central administration site stopped in middle with error messages "This page can't be displayed", Internet Explorer Cannot Display This Page"!. However, I noticed that the IIS Web Sites, Application Pools, content databas…

Fix The website cannot display the page - HTTP 500 Internal Server Error in SharePoint

October 04, 2014    , , , , , ,
Problem:  When I opened SharePoint 2013 Central Administration site, it returned an error message: HTTP 500 Internal Server Error: The website cannot display the page error message! Troubleshooting: Check all required ports are open in Firewall in web & database servers. Update passwor…

Powered by Blogger.