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 an SPQuery object to retrieve filtered list items from the object. Here is a basic example of using…

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 SharePoint 2016. Method 1: Send Email…

Read more

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

Requirement: Set content database to read only in SharePoint Server 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 another…

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

Read more

Fix “MissingAssembly” Errors of Test-SPContentDatabase in SharePoint 2013 Migration

Problem:During SharePoint 2013 migration, we ran the 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, and that site column becomes…

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 Do you want to get a list of all users in your SharePoint farm? PowerShell can help you with this! This blog post will show you how to use PowerShell to quickly find all users in your…

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 the same to check standard or enterprise SharePoint 2010 and SharePoint 2007: When the “Enterprise” is selected and grayed-out, it’s…

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

Read more