CAML Query to Get List Items from SharePoint using PowerShell

CAML stands for Collaborative Application Markup Language. It’s an XML based query language used to query against data in SharePoint How to use CAML query in PowerShell? Basically, we create a CAML query and pass a SPquery object to retrieve filtered list items from the object. Here is a basic example for…

Read more

How to Test Outgoing Emails in SharePoint using PowerShell?

On troubleshooting SharePoint Email issues, as a first step, we have to check outgoing Email settings applied on the SharePoint Central Administration site are valid. So, how to test SharePoint outgoing email quickly? Here are my PowerShell scripts to test outgoing email in SharePoint 2013 or in SharePoint 2016. Method 1: Send…

Read more

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-only mode from SQL Server Management Studio is explained in my…

Read more

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 option from SharePoint side to specify where the data and log files for the database…

Read more

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        : MissingAssemblyError           : TrueUpgradeBlocking : FalseMessage         : Assembly [DealEventEventhandler, Version=1.2.6.0, Culture=neutral, PublicKeyToken=b4122bae67581526] is referenced in the database [wss_content], but is not installed on the current farm. Please install any feature/solution which contains this assembly.Remedy          :…

Read more

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

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

Read more

Delete a Site Column using PowerShell in SharePoint

Requirement: Delete site column with PowerShell in SharePoint How to Delete a Site Column in SharePoint? Site columns in SharePoint can be deleted when we don’t need them anymore. When you delete a site column, any lists and libraries with the particular site column don’t get affected. That site column becomes a…

Read more

Get All Users of SharePoint Farm-Web Application-Site Collection-Site using PowerShell

Requirement: Get all users of SharePoint Farm. SharePoint PowerShell to Get All Users in Farm PowerShell script to get all SharePoint users at Farm-Web Application-Site Collection-Web levels: This script can be used to get all users in site collection and export all users to excel. Get All Unique Users in SharePoint Farm…

Read more

Determine the Installed SharePoint Edition: Standard or Enterprise?

Here is how to check whether standard or enterprise edition is installed in SharePoint 2013. Go to Central Admin >> Upgrade and Migration >> Click on “Enable Enterprise Features” This procedure stays same to check standard or enterprise SharePoint 2010 and SharePoint 2007: When the “Enterprise” is selected and grayed-out, it’s an…

Read more

Installing and Configuring ADFS Integration with SharePoint 2013 – Step by Step Guide

Introduction:Active directory federation services is the solution for extending enterprise identity beyond corporate firewall. It simplifies sharing identities between trusted partners across organizations. It’s a common requirement in a typical business scenario, users in one organization want to access a secured application/website from another organization. Without ADFS, we’d end-up re-creating user logins…

Read more