SharePoint Site Collections and Subsites Inventory Report

Requirement: Get a list of all site collections and their subsites in a HTML formatted report! PowerShell Script to generate a HTML report for Site Collections & Subsites: #Add SharePoint Snapin if ( (Get-PSSnapin -Name "Microsoft.SharePoint.PowerShell" -ErrorAction SilentlyCont…

SharePoint Online: Get All Site Collections using PowerShell

Requirement: Get all site collections using PowerShell in SharePoint Online. How to Get a List of Site Collections in SharePoint Online?   A site collection is a group of sites, generally organized by department, project, region, function or business units. If you want to get a list of ShareP…

SharePoint Online: PowerShell to Get All Subsites in a Site Collection

Requirement: PowerShell to list all subsites in a SharePoint Online Site collection. SharePoint Online: Get All Subsites using PowerShell How to get all subsites in a site collection in SharePoint Online? To get all subsites of a site (either a top-level site or sub-site), use this PowerShe…

Get Site Collection Administrators of All SharePoint Sites using PowerShell

Requirement: Get all Site collection Administrators of a SharePoint 2016 site collection. Solution: SharePoint site collection administrators possess full control to the entire site collection - including top-level site, subsites and all lists and libraries in the site collection. SharePoint…

SharePoint 2013 Search: Unable to retrieve topology component health states. This may be because the admin component is not up and running

Problem: SharePoint 2013 Search service application displays the error message "Unable to retrieve topology component health states. This may be because the admin component is not up and running" Solution: After making sure the account configured to run Search service & Search …

SharePoint Online: Delete Version History using Powershell CSOM

Versioning feature in SharePoint Online allows you to access previous copies of a document or list items. By default versioning is enabled on your SharePoint Online document libraries . When user makes edits, SharePoint automatically creates new version with metadata such as, Created by, Timestam…

How to Create a Site Collection in SharePoint using PowerShell?

We have to use New-SPSite cmdlet to create a site collection in SharePoint. It takes URL and Owner parameters as mandatory with several other parameters. Here is an example: PowerShell to Create New Site Collection in SharePoint 2016: To create a site collection using PowerShell in SharePoint…

SharePoint Online: Delete Unique Permissions for All Items in a List using PowerShell

Requirement: Reset all customized permissions in all documents of a SharePoint online document library. By default, Permissions are inherited from their parent in all levels of SharePoint. E.g. Site inherits permissions from its parent site collection (or parent site), lists and libraries inhe…

PowerShell-CAML SPQuery to Filter List Items based of Person or Group Field Value

Requirement: In a project tracking SharePoint list, want to quickly get the list the projects where a particular user is listed as Project Manager - person or group (People picker) field. Solution: Use SPQuery with PowerShell as in the below example. PowerShell to Filter List Items based of…

Import Data from SQL Server Table to SharePoint List using PowerShell

Requirement: We've an External CRM application from which data is to be extracted and inserted into a SharePoint List! PowerShell to Read Data from SQL Server and Insert into SharePoint: We created a new list "Projects" mapping relevant columns as per the SQL Server table and …

Create Subscription Settings Service Application in SharePoint using PowerShell

What is subscription settings service application in SharePoint? Well, SharePoint Apps platform relies on Microsoft SharePoint Foundation Subscription Settings service application. So, If you want to use Apps in SharePoint, its a prerequisite to create Subscription Settings service application. …

Deactivate Feature on All Sites in SharePoint using PowerShell

Requirement:  After deploying Office web apps with edit licenses in SharePoint, we wanted to disable open in client feature on all site collections in SharePoint. Deactivating a feature is straight forward from SharePoint web UI by getting into: Site Settings >> Site Collection Features …

Activate Feature on All Sites in SharePoint using PowerShell

In some scenarios, you may have to activate a feature for all sites or site collections in SharePoint. In my case today, I had to activate "Open In Client" feature of SharePoint to disable browser based editing for all site collection in a SharePoint web application. How to Activate …

How to Create a SharePoint 2013 Farm using PowerShell to Avoid GUIDs?

Why to use PowerShell to create SharePoint farm rather the nice SharePoint products configuration wizard? Because, SharePoint Products configuration wizard creates Central Administration database names with GUIDs. Create SharePoint 2013 farm using PowerShell: How to start? follow these steps t…

The Complete SharePoint 2013/2016 Site Collection Permission Report using PowerShell

Another PowerShell report generating requirement: SharePoint Site Collection Permission Report to audit permissions on each and every object under a site collection. This PowerShell script generates a report in HTML format, which consists of Permission setup on All subsites under a site colle…

How to Check Replicate Directory Changes Permission for UPS Account?

Replicate Directory Changes Permission is required for user profile import account in SharePoint. While my another article How to grant Replicate Directory Changes permission walks through the steps to grant replicate directory permission,  Now the question is: How to check if a particular accou…

Event ID 8321: A certificate validation operation took X milliseconds and has exceeded the execution time threshold

Problem:  Event ID 8321 logged multiple times in the SharePoint 2013 Application server's Event Log, with the message "A certificate validation operation took 1500.8983 milliseconds and has exceeded the execution time threshold.  If this continues to occur, it may represent a configurat…