kwizcom banner advertisement

SharePoint Online: Find All Large Files using PowerShell

November 12, 2018    , , ,
Requirement: Find all large files in SharePoint Online site collection. How to Find Large Files in SharePoint Online? To find large files in SharePoint Online, you can use "Storage Metrics" page. Navigate to your SharePoint Online site collection >> Click on Settings Gear >> Site Settings In Site Settings page, Click on "Storage Metrics" link under "Site Collection Administration" (https://crescent.sharepoint.com/_layouts/15/storman.aspx) The Storage Metrics page gives you the current Storage consumption of the site. You can navigate to each site/folder objects to get the storage stats of the particular object. You can also include the OOTB "File Size" column in your document library views to get the size of individual files! Explorer view also helps!! SharePoint Online: PowerShell to Get All Large Files in a Site Collection Getting large files by navigating into each folder from the above Storage metrics page is cumb
SharePoint Online: Find All Large Files using PowerShell SharePoint Online: Find All Large Files using PowerShell Reviewed by Salaudeen Rajack on November 12, 2018 Rating: 5

SharePoint Online: Site Collection Permissions Report using PowerShell

September 06, 2018    , , , ,
Requirement: Generate permissions report for a SharePoint Online site collection. SharePoint Online: Site Collection Permissions Report using PowerShell This PowerShell script generates permission report on all objects which has unique permissions on the given site collection. It scans through following securables: Site collection administrators group Given site collection and sub-sites with unique permissions All lists and libraries with unique permissions All list items with unique permissions. #Load SharePoint CSOM Assemblies Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.dll" Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.Runtime.dll" #To call a non-generic method Load Function Invoke-LoadMethod() { param( [Microsoft.SharePoint.Client.ClientObject]$Object = $(throw "Please provide
SharePoint Online: Site Collection Permissions Report using PowerShell SharePoint Online: Site Collection Permissions Report using PowerShell Reviewed by Salaudeen Rajack on September 06, 2018 Rating: 5

SharePoint Online: Permission Report for Specific User in a Site Collection using PowerShell

September 04, 2018    , , , ,
Requirement:   Generate a permission report to audit a specific user's permissions in given SharePoint Online site collection, sub-sites, all its lists, libraries and list items. SharePoint Online PowerShell permissions report This PowerShell script checks user permissions and exports the findings into a CSV file. How to run this script? Just change the Parameters from Line#6 to Line#8 according to your environment and hit run. SharePoint Online: PowerShell to get user permissions on a given site collection  Here is how to check user permissions using PowerShell in SharePoint Online. Please note, there is a limitation in the script: This PowerShell script doesn't scan Active Directory security groups! #Load SharePoint CSOM Assemblies Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.dll" Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\M
SharePoint Online: Permission Report for Specific User in a Site Collection using PowerShell SharePoint Online: Permission Report for Specific User in a Site Collection using PowerShell Reviewed by Salaudeen Rajack on September 04, 2018 Rating: 5

SharePoint Online: How to Remove Feedback Button?

July 18, 2018    ,
Requirement: Disable feedback button in SharePoint Online! Feedback button in bottom right of SharePoint Online gets your feedback comments to Microsoft Uservoice directly. In my case, End users thought their comments are going to the IT team of the organization and we wanted to hide feedback button in SharePoint Online to avoid the confusion. Disable Feedback Button in SharePoint Online: To remove remove feedback button in SharePoint Online, Open SharePoint Online Management Shell and run this PowerShell script. You'll be prompted for credentials.  #Set parameter values $AdminSiteURL="https://crescenttech-admin.sharepoint.com/" #Connect to SharePoint Online Admin Site Connect-SPOService -Url $AdminSiteURL -Credential (Get-Credential) # Disable Feedback button Set-SPOTenant -UserVoiceForFeedbackEnabled $False This turns off feedback for SharePoint Online at tenant level. We used CSS to hide feedback button in the past. But this is the perfect way to remove
SharePoint Online: How to Remove Feedback Button? SharePoint Online: How to Remove Feedback Button? Reviewed by Salaudeen Rajack on July 18, 2018 Rating: 5

Limit Search Results to a Specific Content Source in SharePoint 2016

May 03, 2018    , ,
Requirement:   HR team wants to setup a dedicated search portal to search a confidential file share. If its SharePoint 2010, we would have created a search scope and added rules to include only that specific content source to it. Now from SharePoint 2013 on wards search scopes has been replaced by result sources. So, lets see how to create a result source to limit search results only from a specific content source in SharePoint 2016. Before starting, I've following things configured already: A content source is created to index the specific file share with name "HR FileShare". Full crawl has been completed already. There is a subsite created with "Basic Search center" template to server as a dedicated search center. How to setup Search Result Source to Limit results to a Content Source? Result Sources can be created on three different levels: Search Service Application, Site collection and Site. For our requirement, lets create it at site level. Here
Limit Search Results to a Specific Content Source in SharePoint 2016 Limit Search Results to a Specific Content Source in SharePoint 2016 Reviewed by Salaudeen Rajack on May 03, 2018 Rating: 5

Find All OneDrive Site Collections in SharePoint Online using PowerShell

April 23, 2018    , , , ,
Requirement: Get a list of all OneDrive site collections from SharePoint Online. I was asked to get the list of all OneDrive sites to get the usage of OneDrive for Business in our Office 365 tenant. Its bit tricky to find all of your OneDrive site collections and here is how I achieved using Get-SPOSite cmdlet: Find All OneDrive Sites using SharePoint Online Management Shell: Here is the PowerShell script to get all OneDrive site collections in SharePoint Online. $AdminSiteURL="https://crescent-admin.sharepoint.com" #Get Credentials to connect to SharePoint Admin Center $Cred = Get-Credential #Connect to SharePoint Online Admin Center Connect-SPOService -Url $AdminSiteURL –credential $Cred #Get all Personal Site collections and export to a Text file Get-SPOSite -Template "SPSPERS" -limit ALL -includepersonalsite $True | Select URL, Owner | Format-table -autosize | Out-string -width 8096 | Out-file C:\temp\OneDriveSites.txt Just change the $AdminSiteURL t
Find All OneDrive Site Collections in SharePoint Online using PowerShell Find All OneDrive Site Collections in SharePoint Online using PowerShell Reviewed by Salaudeen Rajack on April 23, 2018 Rating: 5

SharePoint Online: Export List Version History to Excel using PowerShell

January 15, 2018    , , , , ,
Requirement: Export all versions of SharePoint Online List Items to CSV (Excel) file. PowerShell to Extract and Export List Item's Version History to CSV File: This article assumes you have an existing SharePoint Online list with columns given below. You may have to create and change columns according to your requirement. #Load SharePoint CSOM Assemblies Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.dll" Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.Runtime.dll" Function Export-VersionHistory() { param ( [Parameter(Mandatory=$true)] [string] $SiteURL, [Parameter(Mandatory=$true)] [string] $ListName, [Parameter(Mandatory=$true)] [string] $CSVFile ) Try { #Delete the Output report file if exists if (Test-Path $CSVFile) { Remove-Item $CSVFile }
SharePoint Online: Export List Version History to Excel using PowerShell SharePoint Online: Export List Version History to Excel using PowerShell Reviewed by Salaudeen Rajack on January 15, 2018 Rating: 5

SharePoint Online: Find and Delete Orphaned Users using PowerShell

January 04, 2018    , , , ,
What is "Orphaned Users" in SharePoint Online? In short, Orphaned users are those who deleted from the authentication provider (such as removed from Active Directory when user leaves the organization), and still continue to exist in SharePoint online sites! scanning each user in SharePoint online site collection for orphaned users could take days to complete! Since, Here is my PowerShell script to search for orphan users and delete them. Pr-Requisites: Before using this script, you need to have SharePoint Online Management Shell ( https://www.microsoft.com/en-us/download/details.aspx?id=35588 ) and Azure Active Directory Module ( https://technet.microsoft.com/en-us/library/dn975125.aspx ) installed on your machine! Find Orphan Users in SharePoint Online using PowerShell: This script scans each and every user from the given site collection URL and exports list of orphaned users to a CSV file. #Import SharePoint Online and Azure Online modules Import-Module Micro
SharePoint Online: Find and Delete Orphaned Users using PowerShell SharePoint Online: Find and Delete Orphaned Users using PowerShell Reviewed by Salaudeen Rajack on January 04, 2018 Rating: 5
Powered by Blogger.