SharePoint Diary

SharePoint Site Collections and Subsites Inventory Report

February 28, 2016 Admin Reports, PowerShell, SharePoint

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

February 27, 2016 Admin Reports, Client Side Object Model (CSOM), CSV, Office 365, PnP PowerShell, PowerShell, SharePoint Online, SharePoint Online Management Shell, Site Collection

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

February 27, 2016 Client Side Object Model (CSOM), Office 365, PnP PowerShell, PowerShell, SharePoint Online, Subsite

Requirement: PowerShell to list all subsites in a SharePoint Online Site collection. SharePoint Online: Get All Subsites using PowerShell To get all subsites of a site (could be a site collection or sub-site), use this PowerShell: #Requirement: sharepoint online get all subsites powershell…

Get Site Collection Administrators of All SharePoint Sites using PowerShell

February 27, 2016 Admin Reports, PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016, Site Collection Administrator

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

February 27, 2016 Known Issues, Search, SharePoint 2013

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

February 23, 2016 Client Side Object Model (CSOM), PowerShell, SharePoint Online, Version History

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?

February 21, 2016 PowerShell, SharePoint 2010, SharePoint 2013, SharePoint 2016, Site Collection

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

February 20, 2016 Client Side Object Model (CSOM), List, List Item, Office 365, Permission, PnP PowerShell, PowerShell, SharePoint Online

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

February 16, 2016 CAML, People Picker, PowerShell, SharePoint

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

February 15, 2016 List, PowerShell, SharePoint, SQL Server

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

February 13, 2016 PowerShell, Service Application, SharePoint 2013, SharePoint 2016

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

February 13, 2016 Features, PowerShell, SharePoint 2010, SharePoint 2013, SharePoint 2016

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

February 13, 2016 Features, PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

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?

February 12, 2016 Installation, PowerShell, SharePoint 2010, SharePoint 2013, SharePoint Products Configuration Wizard

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

February 08, 2016 Admin Reports, Permission, PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

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?

February 06, 2016 Active Directory, PowerShell, User Profile

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

February 06, 2016 Event Log, Known Issues, Performance Optimization, SharePoint 2013, SharePoint 2016

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…

Disclaimer