SharePoint Site Collections and Subsites Inventory Report

Requirement: Get a list of all site collections and their subsites in an HTML formatted report! PowerShell Script to generate an HTML report for Site Collections & Subsites: Are you looking for a way to generate an inventory report of all your SharePoint site collections and subsites? In this blog post, I…

Read more

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 unit. If you’re responsible for managing a SharePoint Online environment, sooner or later, you’ll…

Read more

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

Requirement: PowerShell to list all subsites in a SharePoint Online Site collection. How to Get a List of Subsites in a SharePoint Online site? There are a few different ways that you can list all subsites in a site collection in SharePoint Online. One option is to use the site contents page….

Read more

Get Site Collection Administrators of All SharePoint Sites using PowerShell

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

Read more

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 Service Host in the Services console, (Service.msc), Provisioned the Usage…

Read more

SharePoint Online: Delete Version History using PowerShell

The 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 a user makes edits, SharePoint automatically creates a new version with metadata such as created by, Timestamps, etc. How to Delete Version…

Read more

How to Create a Site Collection in SharePoint using PowerShell?

PowerShell is a powerful scripting language that you can use to automate administrative tasks in SharePoint. If you’re a SharePoint administrator, then you know that there are many different ways to create site collections. This blog post will explore how to create a site collection in SharePoint using PowerShell. We have to…

Read more

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 parents in all levels of SharePoint. E.g., Subsites inherit permissions from their parent site collection (or parent site), lists and libraries inherit permissions from the site, and items in the list…

Read more

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 of 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 on Person or Group Field:

Read more

Import Data from SQL Server Table to SharePoint List using PowerShell

Requirement: We have 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” by mapping relevant columns as per the SQL Server table, and then here is my…

Read more