kwizcom banner advertisement

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  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\Microsoft.SharePoint.Client.Runtime.dll" #Set parameter values $SiteURL=
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

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#9" -limit ALL -includepersonalsite $True | Select URL, Owner | Format-table -autosize | Out-string -width 8096 | Out-file C:\temp\OneDriveSites.txt Just change the $AdminSiteURL
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

Get-Set OneDrive Site Collection Storage Quota Size using PowerShell

December 26, 2017    , , ,
Get OneDrive Site collection Storage Quota Information: To get the storage quota data for a particular OneDrive site, use this PowerShell cmdlet in SharePoint Online Management Shell Get-SPOSite -Identity "https://crescent-my.sharepoint.com/personal/salaudeen_crescent_com" This gets you the currently allocated storage quota data for a single site collection. Get Storage Quota Details of All OneDrive Site collections Use this script in SharePoint Online Management Shell. $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 $OneDriveSites = Get-SPOSite -Template "SPSPERS#9" -Limit ALL -includepersonalsite $True $Result=@() # Get storage quota of each site Foreach($Site in $OneDriveSites) { $Result += New-O
Get-Set OneDrive Site Collection Storage Quota Size using PowerShell Get-Set OneDrive Site Collection Storage Quota Size using PowerShell Reviewed by Salaudeen Rajack on December 26, 2017 Rating: 5

Get All SharePoint Online Site Collections Inventory using PowerShell

December 24, 2017    , , ,
Requirement: Get all site collections inventory in SharePoint Online using PowerShell PowerShell to Get All SharePoint Online Site Collections Inventory: Import-Module Microsoft.Online.SharePoint.Powershell -DisableNameChecking #Config Parameters $AdminSiteURL="https://crescent-admin.sharepoint.com" $ReportOutput="C:\Temp\SPOStorage.csv" #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 site collections $SiteCollections = Get-SPOSite -Limit All Write-Host "Total Number of Site collections Found:"$SiteCollections.count -f Yellow #Array to store Result $ResultSet = @() #Loop through each site collection and retrieve details Foreach ($Site in $SiteCollections) { Write-Host "Processing Site Collection :"$Site.URL -f Yellow #Get site collection details $Result = new-object PSObject $Resu
Get All SharePoint Online Site Collections Inventory using PowerShell Get All SharePoint Online Site Collections Inventory using PowerShell Reviewed by Salaudeen Rajack on December 24, 2017 Rating: 5

SharePoint Online: Add Site Column to List using PowerShell

December 20, 2017    , , , ,
Requirement: Add an existing site column to SharePoint list or library using PowerShell. How to Add a Site Column to SharePoint Online List? Site columns in SharePoint provides great re-usability without having to recreate same columns multiple times! Once created at top level site, we can utilize them to store metadata in any number of lists and libraries under the hierarchy. To add a site column to SharePoint list, follow these steps: Go to List Settings >> Under Columns, Click on "Add from existing site columns" link. From the available site columns, pick the required site column(s) and click on Add button. Click OK to save your changes. Add Site Column to List or Library with PowerShell: #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\
SharePoint Online: Add Site Column to List using PowerShell SharePoint Online: Add Site Column to List using PowerShell Reviewed by Salaudeen Rajack on December 20, 2017 Rating: 5

How to Add a Custom Tile to SharePoint 2016 App Launcher?

November 28, 2017    ,
Requirement: Add new tile to App Launcher in SharePoint Online. How to Add a Custom Tile to SharePoint 2016 App Launcher? We wanted to place a new tile in SharePoint 2016 app launcher for support center site, as an end-user usability improvement. SharePoint 2016 Feature Pack 1 brought us the capability to add new tile to app launcher. Here is how you can customize SharePoint 2016 App launcher. Step 1: Enable the "Custom Tiles" feature in SharePoint 2016 with PowerShell: Use this PowerShell script to enable custom tiles feature.  Enable-SPFeature -Identity CustomTiles -Url "http://intranet.crescent.com" -Force This creates a new list "Custom Tiles" in the given web application's root site collection. Step 2: Create new Tile in "Custom Tiles" list Once the feature is activated, navigate to: http://intranet.crescent.com/Lists/Custom%20Tiles/AllItems.aspx URL and add a new entry with desired URL and image for tile for your custom t
How to Add a Custom Tile to SharePoint 2016 App Launcher? How to Add a Custom Tile to SharePoint 2016 App Launcher? Reviewed by Salaudeen Rajack on November 28, 2017 Rating: 5
Powered by Blogger.