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

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?

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

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

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

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

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

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?

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

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

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

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.

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

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

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

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

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

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

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?

Requirement: Import term set in SharePoint Online 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.c…

SharePoint Online: Remove User from Group using PowerShell

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

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?

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.…