SharePoint Diary

How to Set SharePoint 2013 Content Database to Read Only Mode using PowerShell?

January 29, 2016 Content Database, PowerShell, SharePoint, SharePoint 2007, SharePoint 2010, SharePoint 2013, SharePoint 2016, SQL Server

Requirement: Set content database to read only in SharePoint 2013 using PowerShell. Solution: We may have to set SharePoint databases to read-only mode in scenarios such as: upgrades, disaster recovery / highly available maintenance, patching, etc. Setting SharePoint content database in read…

How to Move SharePoint Content Databases to Another Drive?

January 29, 2016 Content Database, SharePoint, SharePoint 2007, SharePoint 2010, SharePoint 2013, SharePoint 2016, SQL Server

Requirement: Move SharePoint content database from one drive to another in SQL Server! By default, SharePoint creates its databases in the default SQL Server location: "C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA" folder (SQL Server 2016). We don't have any…

Replace "Edit" Permissions with "Contribute" in SharePoint 2016 using PowerShell

January 22, 2016 Migration/Upgrade, Permission, PowerShell, SharePoint 2013, SharePoint 2016

Problem: Prior to SharePoint 2013, Members group of the site has "Contribute" permission. From SharePoint 2013, there was a new permission level "Edit" introduced with more rights. This introduced additional issue like members can delete lists and libraries! Solution: Remo…

SharePoint Online: Remove a Site Column from Content Type using PowerShell

January 20, 2016 Client Side Object Model (CSOM), Content Type, PnP PowerShell, PowerShell, SharePoint Online, Site Columns

Requirement: Remove a Site Column from Content Type in SharePoint Online. How to Remove a Column from Content Type in SharePoint Online ? When you remove a site column from a content type, It does not delete the column from SharePoint Online. It simply removes the site column's associati…

SharePoint Online: Remove a Field from List Content Type using PowerShell

January 20, 2016 Client Side Object Model (CSOM), Content Type, PowerShell, SharePoint Online

Requirement: Remove a field from SharePoint list content type in SharePoint Online. PowerShell to Remove a Column from List Content Type in SharePoint Online: #Load SharePoint CSOM Assemblies Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Mi…

Fix "MissingAssembly" Errors of Test-SPContentDatabase in SharePoint 2013 Migration

January 19, 2016 Event Receivers, Migration/Upgrade, PowerShell, SharePoint, SharePoint 2007, SharePoint 2010, SharePoint 2013, SharePoint 2016

Problem: During SharePoint 2013 migration, we ran Test-SPContentDatabase cmdlet and the output report contains several MissingAssembly errors! Category : MissingAssembly Error : True UpgradeBlocking : False Message : Assembly [DealEventEventhandler, Version=1.2.6.0, Cu…

Remove a Web Part from All Pages in SharePoint Site Collection using PowerShell

January 18, 2016 PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016, Web Parts

Requirement: After the SharePoint migration from SharePoint 2013 to SharePoint 2016, decided to remove a broken web part from all pages wherever its being used. How to Remove a Web Part from Page in SharePoint? To remove a web part from page, you can edit the page and simply delete the web pa…

SharePoint Online: How to Add a Site Column to Content Type using Powershell?

January 18, 2016 Client Side Object Model (CSOM), Content Type, PnP PowerShell, PowerShell, SharePoint Online, Site Columns

Requirement: Add a site column to content type in SharePoint Online using PowerShell. How to add field to existing content type in SharePoint? By default Title column gets added to the content type. However, you may want to add additional columns. Go to the SharePoint Online site where yo…

Test-SPContentDatabase: Fix MissingWebPart Issue in SharePoint 2013 Migration

January 17, 2016 Migration/Upgrade, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

Problem: MissingWebPart Issues when running Test-SPContentDatabase cmdlet on SharePoint content database during SharePoint 2013 migration project. Category : MissingWebPart Error : True UpgradeBlocking : False Message : WebPart class [9a43cf43-…

Fix MissingSetupFile Error of Test-SPContentDatabase in SharePoint Migration

January 17, 2016 Migration/Upgrade, PowerShell, SharePoint 2010, SharePoint 2013, SharePoint 2016

Problem: Getting "MissingSetupFile" errors when you run the "Test-SPContentDataBase" cmdlet on SharePoint content databases during a migration process. [MissingSetupFile] File [Features\Feature-folder\feature-artifact] is referenced [1] times in the database [SharePoint_Cont…

SharePoint Online: Enable Content Types using PowerShell

January 16, 2016 Client Side Object Model (CSOM), Content Type, Document Library, List, PnP PowerShell, PowerShell, SharePoint Online

As the name suggests, Content type defines type of the content such as item or document. In a real world scenario, A content type could refer to a invoice template or project plan document, etc. Content types provide a effective method of grouping relevant columns (metadata), document template, w…

Test-SPContentDatabase: Cannot open database [Database Name] requested by the login. The login failed.

January 16, 2016 Migration/Upgrade, SharePoint 2013, SharePoint 2016

Problem: In a SharePoint 2013 to SharePoint 2016 migration, Got this error message on testing the content database with Test-SPContentDatabase cmdlet to identify possible issues: "Cannot open database [Database Name] requested by the login. The login failed" Troubleshooting: If…

SharePoint Online: How to Hide a Column in Content Type using PowerShell

January 15, 2016 Client Side Object Model (CSOM), Column, Content Type, Office 365, PnP PowerShell, PowerShell, SharePoint Online

Requirement: Hide a Column from Content Type in SharePoint Online. How to Hide a Column using Content types in SharePoint Online? Columns can be hidden at both content type level or list level in SharePoint. You can hide a column from appearing in list forms, such as: NewForm.aspx, EditForm.a…

Power Query to Extract SharePoint List Data using Excel

January 12, 2016 SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

Microsoft Power Query is a free add-in for Excel - Part of PowerBI that provides self-service Business Intelligence features. Lets see how to extract SharePoint list data using Power Query for Excel. Step 1: Download & Install Power Query Add-in To start with, Download the Power Query Add-…

Find the Last Login Time of a SharePoint User from AD with PowerShell

January 11, 2016 Active Directory, PowerShell, SharePoint, User Profile

Requirement: Find the last login time of all SharePoint users of the farm to find out inactive users. Solution: We can retrieve the user's last login time from Active directory (if the authentication provider is AD) using PowerShell. Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAct…

Get All Web Applications in SharePoint using PowerShell

January 11, 2016 Admin Reports, Audit, PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016, Web Application

Web Applications are the top level containers in SharePoint. Each Web Application we create in SharePoint central administration is associated with site in IIS. How to get all web applications in SharePoint farm? To get a List of all available web applications in SharePoint, Navigate to: Sha…

Current Number of Site Collections is 0 in SharePoint After Database Attachment

January 11, 2016 Content Database, Migration/Upgrade, SharePoint, SharePoint 2010, SharePoint 2013

Problem: During a production SharePoint site cloning into UAT using Database attachment method, after attaching the content database to the web application in UAT environment, found the current current number of site collections is 0 (zero). All site collections missing! Tried "View All Sit…

Find All InfoPath List Forms in SharePoint using PowerShell

January 10, 2016 Admin Reports, Audit, CSV, InfoPath, List Forms, PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

Requirement: Find all customized InfoPath list forms in SharePoint. Tasked to report a listing all the InfoPath List forms customized in SharePoint web application during a migration project. PowerShell Script to Find All InfoPath List Forms in SharePoint Add-PSSnapin Microsoft.SharePoint.Pow…

SharePoint Online: How to Import Term Set from CSV File?

January 07, 2016 CSV, Managed Metadata, SharePoint Online, Term Store

How to Import a Term Set from CSV file in SharePoint Online? Here is how to import term sets from a CSV file. Open SharePoint Online Admin center as Tenant administrator or SharePoint online Admin. (E.g. https://yourdomain-admin.sharepoint.com) Click on the "Term Store" link on the…

SharePoint Online: Remove User from Group using PowerShell

January 06, 2016 Client Side Object Model (CSOM), Permission, PnP PowerShell, PowerShell, SharePoint Online, SharePoint Online Management Shell, Users and Groups

Requirement: Remove User from Group in SharePoint Online using PowerShell SharePoint Online - How to Remove a User from Group? Removing users from SharePoint Online security groups can be done in just few clicks. Follow these steps to delete users from a SharePoint Online group: Navigate t…

PowerShell to Add Entry in Web.config AppSettings

January 06, 2016 PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016, web.config

SharePoint Web applications (or any web site built on ASP.NET) uses Web.config file to store and retrieve web site configurations such as database connection strings, security, etc. web.config file is actually a XML file with .config extension, typically located at the root of your web applicatio…

How to Move All SharePoint Databases to a New SQL Server?

January 04, 2016 Content Database, SharePoint, SharePoint 2007, SharePoint 2010, SharePoint 2013, SharePoint 2016, SharePoint Database, SQL Server

Requirement: Move SharePoint databases to new SQL Server! You'll have to move SharePoint databases including all content databases, configuration databases and service application databases to an another SQL Server at least in a couple of circumstances: Upgrading SQL Server to new version.…