SharePoint Diary

Remove Field from View using PowerShell in SharePoint

November 30, 2015 List View, PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

How to Remove Column from View in SharePoint? Browse to your list or library in SharePoint >> Click on the List or Library tab from ribbon. Click on "Modify View" button under "Manage Views" group. In Edit View page, uncheck the column(s) you wish to remove from the …

Create Content Type Hub in SharePoint 2013

November 30, 2015 Central Administration, Content Type, Managed Metadata, Service Application, SharePoint, SharePoint 2013, SharePoint 2016, Site Collection

What is Content Type Hub SharePoint 2013? Content Type Hub is a centralized repository of SharePoint Content types where we can manage and publish content types. Any Web application that subscribed to this content type hub can consume content types from this store. Content type hub is associated…

Cascading Dropdown in SharePoint List using Infopath Forms

November 28, 2015 InfoPath, List Forms, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

What is Cascading drop downs? Well, Cascading drop downs are linked drop down controls where the content of the second drop down depends on the selection of the first one. E.g. When you Choose Country in the first drop down, the second drop down State is automatically filtered to the list of stat…

Create Word Automation Service Application using PowerShell in SharePoint 2016

November 27, 2015 PowerShell, Service Application, SharePoint, SharePoint 2013, SharePoint 2016

The Word Automation Services Service Application provides developers a way to perform server-side conversion of documents that are supported by Microsoft Word (such as .doc, .docx, .rtf, etc) into other formats such as PDF,XPS, RTF, Docx,etc. In other words, Word Automation Services provides the…

How to Remove Content Database in SharePoint using PowerShell?

November 26, 2015 Central Administration, Content Database, PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

SharePoint content databases are the most important artifacts in SharePoint platform as they hold majority of the data. However, at times we may have to delete the content database from SharePoint. Here is how you can utilize PowerShell to delete database: How to delete content database in cent…

Get/Set Hyperlink Field Values in SharePoint using PowerShell

November 22, 2015 Column, PowerShell, SharePoint

Requirement: PowerShell to get and update hyperlink URL field value in SharePoint Here is my PowerShell scripts to get and set hyperlink column values: Get Hyperlink Field Value using PowerShell: Here is how to get URL value of SharePoint hyperlink field using PowerShell Add-PSSnapin M…

Export Document Library File-Folder-SubFolder Structure to CSV

November 20, 2015 CSV, Document Library, PowerShell, SharePoint

Requirement: Get the complete structure of all folders-subfolder-files from a SharePoint document library and export to CSV file. PowerShell Script to Iterate through each folder and Sub-folder and get all files: Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue #Fu…

How to Add Managed Metadata Column to SharePoint List using PowerShell?

November 20, 2015 Column, Managed Metadata, PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

Requirement: Add a Managed Metadata Column to SharePoint List using PowerShell. PowerShell Script to Add Managed Metadata Column in SharePoint List Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue #Variables $WebURL="https://portal.crescent.com/sites/Sales/&qu…

SharePoint Products Configuration Failed: Unable to create a Service Connection Point in the current Active Directory domain. Verify that the SharePoint container exists in the current domain and that you have rights to write to it.

November 17, 2015 Patching, Service Packs, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016, SharePoint Products Configuration Wizard

Problem: After applying a service pack, Ran SharePoint Products Configuration Wizard. It failed with this error message: " An exception of type microsoft.sharepoint.postsetupconfiguration.postsetupconfigurationtaskexception was thrown. additional exception information: Failed to upgrade Sha…

How to Recover Credentials from Secure Store Service in SharePoint using PowerShell?

November 15, 2015 PowerShell, Security, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

So the previous SharePoint administrator left without documenting passwords from SharePoint secure store Service? Unfortunately, There is no way to get stored user name, passwords from SharePoint secure store service from Central Administration site. No worries, Lets use PowerShell to decrypt…

Another component has already added an HTTPSessionState to the Context. Please make sure only one session state module should be registered

November 14, 2015 IIS, Known Issues, SharePoint, web.config

Problem: After changing web application properties from SharePoint central administration site to support "anonymous access", sites started giving this error message: Another component has already added an HTTPSessionState to the Context. Please make sure only one session state module …

People Search relevance is not optimized when the Active Directory has errors in the manager reporting structure - SharePoint 2013 Health analyzer error

November 14, 2015 Active Directory, Health Analyzer, Known Issues, PowerShell, SharePoint, SharePoint 2013, User Profile

Problem: SharePoint 2013 Health analyzer logged this error - People Search relevance is not optimized when the Active Directory has errors in the manager reporting structure. Also in Windows Event Viewer, from MSSQL$SHAREPOINT Source, "An exception occurred while enqueuing a message in …

How to Delete a Master Page in SharePoint using PowerShell?

November 13, 2015 Master Page, PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

Requirement: After deploying a new master page as part of new branding, We wanted to delete the old master page from all SharePoint sites. As we've applied the new master page, we don't want our existing custom master page to be appear in the master page gallery and master page selectio…

Add Attachment to List Item in SharePoint using PowerShell

November 08, 2015 Attachment, PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

How to Add Attachment to a SharePoint List Item? To add attachment to SharePoint list item, Navigate to the list, select a list item Click on "Attach File" button from the "Items" tab of the ribbon. Browse and select the file to attach. Click OK to attach the file to it…

Copy Permission Levels in SharePoint using PowerShell

November 07, 2015 Permission, PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

Requirement : Copy permission level in SharePoint 2013 using PowerShell PowerShell to Copy permission level programmatically in SharePoint Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue #Configuration parameters $WebURL="https://portal.crescent.com" $S…

The password supplied with the username Domain\Username was not correct. Verify that it was entered correctly and try again.

November 07, 2015 SharePoint, SharePoint 2010, SharePoint 2013, STSADM

Problem: While trying to create a new web application from SharePoint 2013 central administration site, It gave this error message: Sorry, something went wrong The password supplied with the username Domain\Username was not correct. Verify that it was entered correctly and try again. Root…

How to Increase Distributed Cache Memory Size in SharePoint 2013?

November 07, 2015 Best Practices, PowerShell, Service Application, SharePoint, SharePoint 2013, SharePoint 2016

By default, the Distributed cache memory allocation size defaults to a value of 10% of total physical memory when SharePoint Server 2013 installs. The Distributed Cache service uses half of that memory allocation for data storage (also known as cache size, 5% cache size). You can change the memor…

Distributed Cache Service in SharePoint 2013 - Explained

November 06, 2015 PowerShell, Service Application, SharePoint, SharePoint 2013, SharePoint 2016

What is Distributed Cache in SharePoint 2013: The SharePoint Distributed Cache service is an additional caching mechanism introduced in SharePoint 2013 to support beyond the options that already exist (such as Object Cache, BLOB Cache, and Page Output Cache) from the earlier versions of SharePo…

Create My Site for All Users in SharePoint using PowerShell

November 03, 2015 My Site, PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

SharePoint My Sites are automatically created when the first time users click on the My Content link in welcome menu. However, To promote the usage of SharePoint social, we deiced to pre-create SharePoint My sites for all users. Create Mysite for All Users in SharePoint using PowerShell Add…

Open Documents in Client Application Instead of Browser in SharePoint

November 01, 2015 Office Web Apps, PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

Requirement: Enable Microsoft Word documents, Excel Spread sheets and PowerPoint Presentations to open in client applications like Microsoft Word, Excel and PowerPoint instead of opening them in browser directly. Solution: When you configure Office Web Apps (or Microsoft Office Online Server) t…

How to Make Attachments Mandatory in SharePoint List?

November 01, 2015 Attachment, Javascript, List Forms, SharePoint, SharePoint 2013, SharePoint 2016

Requirement: In a SharePoint list, make attachment required field! Solution: While, creating a Document library with metadata columns is one option, requirement is only to make the attachments mandatory in SharePoint list forms. To make attachment mandatory in SharePoint list we can use si…