Export SharePoint Users and Group Permissions to Excel

Requirement: Export users and group permissions to Excel in SharePoint. Here is the shortcut to export SharePoint users and groups permission to Excel: Open your SharePoint site in Internet Explorer. Navigate to either site permissions or any User group.  Right-click on the users list page, choose the “Export to Excel” item. You…

Read more

Get All Site Collections Size (Storage Used, Allocated), Owners, Database Details with STSADM

Do you know the STSADM command-line tool can do this, still in SharePoint 2013? Yes! It can get you a quick peek view of all site collections in the given web application. It gets you details such as: Storage space allocated – Storage used, warning and maximum levels Site collection GUIDs Site…

Read more

Find All Large Lists Exceeding Threshold Limit in SharePoint using PowerShell

Requirement: Find all lists exceeding the list view threshold limit configured on Web Application’s resource throttling settings. PowerShell Script to find all Large Lists that exceeds the configured threshold limit: Larger lists in SharePoint consume more resources and performance killers. We wanted to find all larger lists and libraries in the SharePoint…

Read more

SharePoint 2013 / 2016: Specific User Permission Analysis Report using PowerShell

Analyzing SharePoint permissions for a particular user is often a common task in SharePoint administration. Generally, How do we check what permissions a user has on SharePoint content? By getting into the site or list settings page and checking permissions for the particular user, isn’t it? Well, You may want to analyze…

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

PowerShell Script to Find All Active Directory Groups in SharePoint

Requirement: Get the list of All AD Security groups used in SharePoint sites. We need to generate a report on AD groups used in a SharePoint web application. PowerShell script to find AD Groups in SharePoint: Here is my PowerShell script to find and export Active Directory groups on all SharePoint sites…

Read more

Get SharePoint Documents Inventory Report with PowerShell

Requirement: Get all files in a SharePoint Document Library using PowerShell This PowerShell script generates a detailed report on the given SharePoint library’s inventory in addition to its storage data. The output report contains: File Name File Size(KB) Versions Size(KB) Total File Size(KB) Created on Last Modified Created by Parent Folder URL…

Read more

Find All Site Templates Used by SharePoint Sites

Requirement: Find all Site templates used in a SharePoint 2010 environment and generate a report before proceeding with Migration, as certain templates are discontinued in SharePoint 2013. Solution: let’s get a site template usage report on all sites using PowerShell. PowerShell Script to Get Web Templates of all sites and Export to…

Read more

SharePoint Site Detailed Storage Report using PowerShell

Requirement: Generate a detailed report on all lists and library sizes of a SharePoint site. Are you curious about how much storage space your SharePoint site is using? Or, maybe you’re wondering what lists and libraries are taking up the most space. In either case, you can use PowerShell to generate a…

Read more

Storage Analysis Report for SharePoint Document Library

Requirement: On a huge document library, We needed to analyze all documents stored and figure out what files are taking up the most space to move documents into individual libraries/folders, as this larger library causes latency issues. PowerShell script to generate storage metrics report on SharePoint library: Are you looking for a…

Read more